Alteryx Designer

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

API connect

Highlighted
Alteryx Certified Partner

Hi there, 

 

https://api.instarsuite.com/norwaytvov/IADS.asmx/GetData?iads_params=name:NRK-NO-API-1;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 

 

 

Highlighted
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.

 

Thanks,

Subrat

Highlighted
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

 

 

Highlighted
Alteryx Certified Partner

Thank you so much  David

 

 

Highlighted
16 - Nebula

This will give you the full dataset

Labels