Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Python tool returning .yxdb error but my code isnt writing to a yxdb?

nickmartella
7 - Meteor

Hello, in my python tool I am doing an API POST call and I only want the returned data to go downstream in my workflow. However, my code is returning the following metadata error.

 

 

Here is my code:

 

 

import requests
import json
from ayx import Alteryx
import pandas as pd

df = Alteryx.read("#1")
Token = df["JSON_ValueString"].values[0]
url = "(placeholder url)"

headers = {
    'Content-Type': 'application/json',
    'Authorization': f'Bearer {Token}',
    'Cookie': '(placeholder)'
}

responses = []

for part_number in df["SUPPLIER_PART_NUMBER"]:
    payload = {
        "transactionId": "1111",
        "externalPartnerNumber": "",
        "departmentNumber": "",
        "locale": "en",
        "sections": [],
        "identifiers": {
            "mmmStockNumber": part_number,
            "upc": "",
            "mmmCatalogNumber": part_number,
            "customerPartNumber": part_number,
            "requestedDeliveryQty":"1"
        }
    }

    response = requests.request("POST", url, headers=headers, json=payload)
    if response.status_code == 200:
        response_data = response.json()
        responses.append(response_data)

df_responses = pd.DataFrame(responses)
Alteryx.write(df_responses, 1)

 

 

 

 

error

SUCCESS: reading input data "#1"
[Datafile.writeData]: metadata arg is required for yxdb and expected to be dict like {'Field1': {'type': 'FixedDecimal', 'length': (8, 3), 'source': 'PythonTool:', 'description': 'my description'}, 'Field2': {...}}
Error: unable to write output (C:\Users\nmartella\AppData\Local\Temp\Engine_15176_59528846cac4401382bf420bd17f360d_\d827adaccb4f5027467ed3663ce95353\output_1.yxdb)
ERROR: writing outgoing connection data 1
0 REPLIES 0
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels