JSON not found

[patricklshan]

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

[gabrielvilella · Accepted solution]

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)

[patricklshan]

Thank you very much