We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help with parsing JSON file

RPS
7 - Meteor

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.

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

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
ACE Emeritus
ACE Emeritus

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
7 - Meteor

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.

Labels
Top Solution Authors