My workflows can't find the JSON files. How can this be fixed?
Solved! Go to 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)
Thank you very much