Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Downloading a CSV directly into a workflow

aaronindm
8 - Asteroid

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!

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

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
19 - Altair
19 - Altair

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

Labels