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

Reading Data from IATI

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


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



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  (