QlikSense Rest Connector - Use Variable for a Query Header Value

[nhaataja]

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.

[Aurelien_Martinez]

Hi,

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

For example :

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