Programmatically load REST data

[danabb]

Hello,

I am new to Qlik and I am trying to programmatically query a REST endpoint, using parameters that I have previously loaded with another endpoint.

Basically, in pseudocode:

GET "http://myapi/api/v1/Site?apikey=blablabla" // returns a table with a "SiteId" column.

for each vSite in SiteId:
  GET "http://myapi/api/v1/vSite?apikey=blablabla?param=extraparam
  NEXT

The WITH CONNECTION keyword seems to be what I am looking for, but I am missing some concrete example on how to use it when iterating over another table?

[simonaubert · Accepted solution]

Hello,

You will find some examples here
https://community.qlik.com/t5/Qlik-Design-Blog/REST-connector-Using-WITH-CONNECTION/ba-p/1523257

https://community.qlik.com/t5/App-Development/REST-Connector-WITH-CONNECTION-Syntax/td-p/1314

On the first link, there is a with connection url that looks like what you need.

Best regards,

Simon