Reading Data from IATI

[Guruprem]

Hi ,

I am looking for a way to read the data from IATI website, Following URL can generate the Kenya data in XML format

http://datastore.iatistandard.org/api/1/access/activity.xml?recipient-country=KE

Please suggest in Alteryx, how can I read this data from web. Attached is what I tried.

[s_pichaipillai · Accepted solution]

I updated your workflow

1. use the downlaod data filed for further parsing 

2. use multiple xml parse tool for each outerxml 

[Guruprem]

Thanks s_pichaipillai , This just a beginning I am on way to create an App , Please help me if I post any more questions in this thread.

[MichelSza]

By experience, in addition to XML Parse, you may need to use the Regex tool when it is to extract the value for a known entity.

Also, to avoid too many API calls during development, you can add the cache dataset tool  (http://community.alteryx.com/t5/Engine-Works-Blog/The-Cache-Dataset-Macro/ba-p/3162)