Alteryx Designer

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

API connect

Alteryx Certified Partner

Hi there,;password:wySG...


The following link or API has GUI that should make it possible to download a CSV file.  Does anyone know how I can do this ?


Thanks in advance 



9 - Comet

Hey @ohruud , 


The link opens up to a HTML page with a json output format as mentioned in attached image. 


Could you please provide more details on the Google Bigquery that is being run as part of the query at the end of the URL .


This way we can make an API call to the URL and then run the query to fetch the data and parse it to later store it as a csv and consume.




16 - Nebula

You have to create a header in the download tool mimic a browser.


Name: User-Agent

Value: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.73 Safari/537.36


Then, in the URL, replace all the %20 in the Select Statement with a space. The result looks like this:


If you change the SQL query in the url to Select *, there are more fields available if you need them.


Workflow attached.


download data image.png



Alteryx Certified Partner

Thank you so much  David



16 - Nebula

This will give you the full dataset