Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

API connect

ohruud
7 - Meteor

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 

 

 

4 REPLIES 4
SubratDas5
11 - Bolide

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

DavidP
17 - Castor
17 - Castor

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

 

 

ohruud
7 - Meteor

Thank you so much  David 🙂

 

 

DavidP
17 - Castor
17 - Castor

This will give you the full dataset

Labels
Top Solution Authors