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

Alteryx designer Discussions

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

Read XML from URL

Meteor

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

 

https://www.estv.admin.ch/estv/de/home/mehrwertsteuer/dienstleistungen/fremdwaehrungskurse/archiv-de...

 

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 www.pwebapps.ezv.admin.ch/apps/rates/estv/getavgxml?lang=1&j=2019&m=01
 
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.
 

 

Alteryx
Alteryx

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.

 

 

Alteryx
Alteryx

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

Highlighted
Meteor

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

Labels