Hi All,
I am an absolute newbie to Alteryx having used it all of 1 week and have learnt a lot from the community board, however I have come unstuck with APIs (especially parsing the JSON output) and need help. I have searched all the available tips but nothing seems to fit my requirements hence the new post.
I have an API download from Scopus and the data is available in the 2nd column and I am unable to convert it into a tabular form. I would be grateful for any help/tips.
PS: The easiest workaround is to save the output into an xml file and then manipulate in Alteryx, but I want the full process from initiating the API to work through Alteryx.
Thanks in advance.
Solved! Go to Solution.
Unfortunately your workflow does not pass any data from the download tool as you have exceeded the rate limit for the API with your key.
However, the process of parsing a json output into a tabular format as usually very standard, so I have attached a workflow from a different API which you can use as a base.
Ben
Unfortunately your workflow does not pass any data from the download tool as you have exceeded the rate limit for the API with your key.
However, the process of parsing a json output into a tabular format as usually very standard, so I have attached a workflow from a different API which you can use as a base.
Ben
Hi Ben,
That sort of makes sense (something that I hadn't thought of as I am new to both publishing and Alteryx), however funnily when I amended the url and tagged it with "httpAccept=application%2Fxml" it ran perfectly. Your examples will help me hone my Alteryx skills enormously, so I am very grateful for your help.
Thanks again.