Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Carl_Hunter
Partner
Partner

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.

1 Reply
Carl_Hunter
Partner
Partner
Author

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)"

);