Connect to CSV file on from web URL?

I have a dynamic report that gets downloaded in CSV format by clicking a static URL link.

How can I connect this as a data source?

UPDATE:

Able to connect to the data using Text Input > Download workflow, but it's not reading the data right. Seems to be taking all data and putting in one record.

Its a CSV file. Its throwing all the data in a column called 'DownloadData'. There are no headers in my data, just data.

Download

Accepted answers

KaneG

Try this one then

BreakCSVCellApart.yxmd

All comments

KaneG

You can either select to save it as a CSV on the 'Basic' tab of the download tool and then use a dynamic Input tool to bring it in, or you can just use the Text to Columns tool twice to parse the data. (Once with \n to split to rows, then split to columns on the comma.)

BigDataGeek

Having problems getting either of these solutions to work, probably because I'm new to Alteryx. Will keep trying though.

Joe_Mako

Another option instead of manually parsing a CSV file, is to use the Download too to download to a temp file, and Dynamic Input to read in that temp file. as in the attached workflow.

Also, here is another macro from removing null rows and/or columns: https://community.alteryx.com/t5/Data-Preparation-Blending/Macro-to-Delete-Null-Rows-and-or-Columns/m-p/66276

In that post is an example workflow that uses this macro.

download temp dyn input.yxmd

BigDataGeek

Thanks for the additional options. This is what I had originally vision as a way to work with the data, grab it, save it and then work with it. Both are pretty easy solutions after the first time setting up.

BigDataGeek

Also Joe,

For me, this solution works better all because of dynamic inputs 'Start Data Import on Line' feature! My data has a bunch of needless info on lines 1-6. This allows me to skip it. Perfect.

Gaurav_123

Hi All,

I'm pretty new to Alteryx. I'm trying something similar. Download data from below web URL using Alteryx.

Don't know why it gives me an error. I tried searching for answers on web but no luck. Hope someone can help me resolve the issue. Or find a solution to download data from below link using some other method.

Weblink.

https://query1.finance.yahoo.com/v7/finance/download/%5EHSCE?period1=1547725804&period2=1550404204&interval=1d&events=history&crumb=ieOjtTA2iG3

Download_web_csv.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335