Modify table before using API connector

Ali_Hojjat — Tue, 28 Dec 2021 20:24:16 GMT

Hi Everyone,

I`m a new Qlik sense user & loved it so far. I am trying to use the Rest API connector for the following situation and I couldn’t come up with any solution. Any suggestions are welcome.

I`d like to get the traffic counts data from different counters.There are around 200 traffic count sites with unique site Id`s that I can get the list of all of them though an unique URL : https://apieco.eco-counter-tools.com/api/1.0/site in Json and it returns

“site Id”

“site name”.

To get the data for each induvial site, specific request URL needs to be sent through the API connection. For example if I`d like to get the counting volume of Site ID no 101133846, the request URL would be https://apieco.eco-counter-tools.com/api/1.0/data/site/101133846

And it returns

“date”,

“Count”,

“status”.

As you see, I wouldn’t have the site id as a result of this query.

My concerns are:

Since I`d like to get the counting data for all 200 sites with different site id`s, how can I manage to send one request rather than making tones of API connectors. I`ve read about “with connection “but I`m unsure how to apply it in this case.
As the result data counting table doesn’t have the site id, how can I add the site id in prior to send a request URL to the server?

Here is the API document that I`m trying to get access to with demo token. https://apiadmin.eco-counter-tools.com/store/apis/info#/

Your help would be much appreciated.

topic Modify table before using API connector in Connectivity & Data Prep

Modify table before using API connector