Help with parsing JSON file

[RPS]

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.

[BenMoss]

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

[BenMoss · Accepted 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

[RPS]

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.