JSON not found

Question

My workflows can't find the JSON files. How can this be fixed?

Python Integration Test 2.yxmd

Python Integration Test.yxmd

gabrielvilella · Accepted Answer

You need to add the JSON to a new column on the existing pandas dataframe then write it to an Alteryx anchor.

from ayx import Package
from ayx import Alteryx
try:
    import requests
except:
    Alteryx.installPackage('requests --user')

df = Alteryx.read('#1')
url = df.iloc[0,0]
page = requests.get(url)
df.json = page.text
df['json'] = df.json
Alteryx.write(df,1)