topic QlikSense Rest Connector - Use Variable for a Query Header Value in Connectivity & Data Prep

QlikSense Rest Connector - Use Variable for a Query Header Value

nhaataja — Wed, 24 Apr 2024 12:47:23 GMT

I am working on a QlikSense application which connects to a SharePoint Online list via a Rest Connector. I need to be able to have a Query Header Name be "Authorization" and the Query Header Value set to an encryption key which will change daily. See the highlighted section below for where I am hoping to use the variable. Is it possible to use a variable in this field so that I do not have to manually go in every single day and set the new encryption key? See the highlighted section below for where I am hoping to use the variable.

Re: QlikSense Rest Connector - Use Variable for a Query Header Value

Aurelien_Martinez — Wed, 24 Apr 2024 12:55:30 GMT

Hi,

You can use a WITH CONNECTION parameter : https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm

For example :

SELECT [...] FROM JSON (wrap off) "result" WITH CONNECTION ( HTTPHEADER "auth_type" "$(vToken)" );