download multiple zip files from url

Question

Hi,

I am trying to download multiple zip files which have shape files included from the following url:-

https://www2.census.gov/geo/tiger/TIGER2010/TABBLOCK/2010/

I tried using download tool and getting the following message :-

DownloadHeaders
HTTP/1.1 200 OK

Is there a way to download all of zip files in url ?

Thanks!

test.yxmd

grossal · Accepted Answer

Hi @Inactive User,

you are currently downloading the webpage itself and not the zip-files, that isn't wrong, because we need to do this anyway, but we don't need it as a file.

1) Download the Webpage

2) Text-To-Column with "Split to rows" setting to have separate rows

3) Regex to get all the filenames

4) Filter to remove all rows that don't have a filename

5) Remove not needed columns

6) Formula to create the actual download link

7) Text-Tool with Download Folder

😎 Append Fields to append the folder to all rows

9) Formula to create final output name (Path+Name)

10) Download everything

This will take a while. You can see the process in the Results Windows.

Let me know if this is what you are looking for. I'll attach the workflow.

Best

Alex