API connect

[ohruud]

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 

[SubratDas5]

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 · Accepted solution]

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.

[ohruud]

Thank you so much  David 🙂

[DavidP]

This will give you the full dataset