Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
carlhunter
New Contributor III

REST Connector - WITH CONNECTION Syntax

Hi All

Can anyone point me in the direction for syntax or usage guidelines for the WITH CONNECTION keyword of the REST SQL command?

I am wanting to override the Query Parameters i.e. iterate through a list of IDs, firing the GET command for each iteration, and the Query Headers i.e. changing the Authorization and Bearer Tokens at run time.

I've found a few forum posts, but, I can't see any technical guidelines.

The Qlik Online Help talks about the "WITH CONNECTION" keyword which is what I believe I need to use, but, doesn't go into the detail of what it can do (see here > https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/1.2/Load-REST-data/Sel...)

Any assistance greatly appreciated !

Cheers

Carl.

Tags (2)
1 Reply
carlhunter
New Contributor III

Re: REST Connector - WITH CONNECTION Syntax

I think I've figured out that if I use the QUERY attribute of WITH CONNECTION, I am able to override the values set in the Data Connection... as per below...

RestConnectorMasterTable:

SQL SELECT

"Column1",

"Column2",

"Column3"

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION

(

     QUERY "Authorization"     "$(vBearerToken)",

     QUERY "ApiKey "           "$(vApiKey)",

     QUERY "startDate"         "$(vReportStartDate)",

     QUERY "endDate"           "$(vReportEndDate)"

);