Downloading a CSV directly into a workflow

[aaronindm]

I've seen and read many posts on this topic but cannot seem to connect the dots.  There is a CSV on this page that I am trying to download

https://www.cboe.com/us/indices/dashboard/DDA/dda-history.csv/

When I copy the link address I get this:

blob:https://www.cboe.com/b82ea170-7f04-40dc-a931-23754deeb0a3

Do I need to use the blob functionality to download this?

Any help would be appreciated!

[fmvizcaino]

Hi @aaronindm ,

I was not able to find a solution to your problem, but only to help you out a bit more, I've found a information related to the blob use in href links.

https://stackoverflow.com/questions/14952052/convert-blob-url-to-normal-url

Best,

Fernando Vizcaino

[danilang]

Hi @aaronindm 

The particular website that you're trying to download data from is a dynamic site.  The final page is actually built of several secondary scripts kicked off when you download the main url into a scripting enabled browser such as Chrome, FireFox and even MS Edge.  The download tool in Alteryx can't run these secondary scripts so all you get is a static HTML with some non-executed scripts.  

Luckily, there is a way to have the entire page loaded and the final result passed to Alteryx.  Selenuim is a web testing framework that can run the secondary scripts and can be executed inside a Python tool.  See this link for a tutorial on how to use it 

Dan