Programmatically load REST data

danabb — Wed, 17 Nov 2021 21:30:30 GMT

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?

Re: Programmatically load REST data

simonaubert — Thu, 18 Nov 2021 07:11:39 GMT

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

topic Programmatically load REST data in Connectivity & Data Prep

Programmatically load REST data

Re: Programmatically load REST data