Downloading csv from zip file from hyperlink

[tbuenaflor]

Hello!

Looking for some help on downloading a csv file that is in a zip file from the DOL 5500 website. Right now we manually download the file to a shared folder on our network and use that as the input in a workflow, however I'm looking to sort of dynamically get this data. Some of the threads I've tried looking at where archived so I couldn't use those as examples. 

The below site is were the zip links are and the other two are direct links to the zip file. 

https://www.dol.gov/agencies/ebsa/about-ebsa/our-activities/public-disclosure/foia/form-5500-dataset...

https://askebsa.dol.gov/FOIA%20Files/2022/Latest/F_5500_2022_Latest.zip?_ga=2.168214697.982608220.16...

https://askebsa.dol.gov/FOIA%20Files/2021/Latest/F_5500_2021_Latest.zip?_ga=2.168214697.982608220.16...

Any help on where to get started would be great! Thanks! 

[danilang · Accepted solution]

Hi @tbuenaflor 

The go-to post for this topic was always "https://community.alteryx.com/t5/contentarchivals/contentarchivedpage/message-uid/444413" provided by someone from Alteryx.  The post has gone, but I snagged a copy of the workflow since it was so useful.

Alteryx Input tools can read a file from within a zip archive, but you have to know the name of the file that you want to extract.  The attached workflow uses a python tool to read the directory of the zip file, which is then passed to a batch file to extract the individual files.   You can use this as the basis for your workflow by replacing the initial Directory browse tool with a download tool that writes to a specific location.

Dan   

[tbuenaflor]

@danilang you're awesome for saving the workflow! Going to give it a shot. Thank you so much!