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 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.
Solved! Go to Solution.
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!