topic Re: Reading Data from IATI in Alteryx Designer Desktop Discussions

Reading Data from IATI

Guruprem — Thu, 24 May 2018 01:36:30 GMT

Hi ,

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

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

s_pichaipillai — Wed, 02 Mar 2016 11:22:33 GMT

I updated your workflow

1. use the downlaod data filed for further parsing

2. use multiple xml parse tool for each outerxml

Guruprem — Wed, 02 Mar 2016 12:13:19 GMT

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 — Wed, 02 Mar 2016 21:45:22 GMT

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)