Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Read XML from URL


I'm trying to convert a macro enabled Excel file to an Alteryx workflow.  The Excel uses the VB function ActiveSheet.QueryTables.Add to grab a table from the URL


I can't find a way for Alteryx to do the same.  But, the URL provides a way to open the XML in a new tab or window.  You can also right click the link and select "Save Target As..." to same a file local.  The URL for the XML file is
I have found a couple of XML tools in Alteryx, but none that can read from a URL.  I also can't find a way to download the XML file since it isn't stored on an FTP site.
Hoping the community can help.



Hey @afinzerillo ,


Have you tried using the download tool? The download tool will allow you to retrieve the XML data in what is called the "download data" column generated from the download tool. You will have to use a text input tool to store the URL and pass it through the download tool. From here you could simply use the XML Parse tool within the Parsing Category.




No issues here as well - do you need to save the XML as well?


That works.  Thanks!.  Now to build the URL dynamically!