Download Data from website

[Mancunian]

How do I download data from the following website in the attachment using xml spare, download tool or API?

[danielbrun2]

Hi Ama.

I would suggest something like the attached workflow. Please note that I have limited the input to 5 records.

Best,

Daniel

[danielbrun2]

Hi,

Did the suggested solution work out for you?

Have a nice weekend,

Daniel

[Mancunian]

Hi Daniel

Thank you for your reply. I'm afraid I am still unsure about what to do as when I open the attchment all I can see is the Xml code.

Would you be able to attach the actual Alteryx Module for me?

Thank you

Regards

AMA

[danielbrun2]

Hi, AMA,

Does it show the XML in the browser? I would suggest that you right click and say "save destination as". It is the actual module I have uploaded. 

Bonus info: An Alteryx module is just a textfile with XML in it.

Best regards,

Daniel

[Mancunian]

Thank you so much for the bonus information! I had no idea!

I have right clicked and aved it as .yxmd but I am afraid I am using version 8.6.2 and so it won't let me open a module from a newer version (or so it says!)

AMA

[danielbrun2]

You are very welcome. I do not have 8.6.2, but I will see if a colleague can save the flow in that version.

Best regards,

Daniel

[danielbrun2]

Could you maybe try this flow. I have just edited the version inside the XML (not supported), so if you can open the flow I suggest you make a new one with inspiration from mine.

Best regards,

Daniel

[Mancunian]

Sorry for not replying earlier. I have been caught up with some other work.

The last Alteryx Module you attached still does not open on my version.

Could you send me instructions on how I could best get the doenload tool to work?

[danielbrun2]

No worries.

I have tried to make some screenshots as well as a description of what I am doing.

The flow:

So here is a description of the 6 tools:

1. It all start with the excel sheet you provided.
2. Next comes the download tool which does the actual magic. Choose the "Website" as the field user for the URL (the rest is just parsing ect.)
1. 
3. Takes away unescessary fields 
1. 
4. Uses the build in XML parser
1. 
5. Takes away unescessary fields - Download data(data can build up fast if you dont do this)
1. 
6. Browse tool. Choose your preferred output.
1. 

And that's it. Please let me know if it solves your problem, and you are able to replicate it. 

Best regards,

Daniel