Connect to CSV file on from web URL?

[BigDataGeek]

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.

[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&i...

[Joe_Mako]

As far as I know, Yahoo no longer provides an API to download finance data:
https://www.programmableweb.com/news/oh-about-api-yahoo-killed-without-warning-developers/analysis/2...

https://www.alphavantage.co/ is a free option to get stock data.

After you sign up, they will provide an API key.

https://www.alphavantage.co/documentation/ has example URLs for each function, and their options.

For example to download the daily time series of ^HSCE for the past 100 days, just replace "demo" with your actual API key, and run it through the download tool.
https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=%5EHSCE&apikey=demo&datatype=csv

Notice that the ^ is encoded to %5E for the URL.

Attached is an example workbook made in 2019.1, and the API key is set in the Formula tool.