Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)"
);