community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More
SOLVED

Reading Data from IATI

Highlighted
Alteryx Certified Partner

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.

Download from web.PNG

 

 

 

 

 

I updated your workflow

1. use the downlaod data filed for further parsing 

2. use multiple xml parse tool for each outerxml 

 

Alteryx Certified Partner

Thanks 

Meteor

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)

 

 

Labels