Download information from URL using Alteryx

[edwinyapweitian]

Hi Alteryx Community

Ed here and new to Alteryx.

I am using Alteryx Designer version 2022.

I am looking to download the latest zip file from below website, unzip the file, download, and saved in a location for further processing.

Below are the steps I am trying to achieve:

1. URL: https://www.gleif.org/en/lei-data/lei-mapping/download-isin-to-lei-relationship-files#

2. Locate the latest Zip file that is updated on daily basis

e.g., 2025-03-23: isin-lei-20250323T080327.zip

3. Download the zip file to defined output folder

4. Unzip and extract the file to defined output folder

Can this be done via Alteryx?

Please advise

Thanks

[KGT]

You have an advantage here that there is only one table on that page, and it has a link.

So, the method I would take is to parse the webpage, grab out the most recent file from that table and then download that. It's going to be multi-step, as downloading form a URL and then unzipping can be done, but might be really finicky.

This is the part that parses the table:

Then the grab the most recent date using a filter, parse the link and you have the what looks like a link to the file. The trick here is that the link is actually to somewhere, and then something else is processing to get the file.

So, here is part-way, but it will require a bit of research to get the next step. I suggest specifying where it's downloaded to (from a field) and once the file is downloaded, then use that field in a dynamic input to bring in the contents of the zip.

[edwinyapweitian]

Hi KGT

Thanks for the response.

However, I am stuck with the Download tool.

Regards

Edwin

[KGT]

OK, I'm guessing something is blocking you then. I can run that again now and it works... you may have extra info in the download headers as to what is blocking you.

[edwinyapweitian]

Thanks KGT for the response. Let check again.