Hi,
I have connected Act-On and Qlik via the RESt connector. First I get a token through the POST method. This token changes every hour and needs to be used in a REST connector with the GET method. I can enter the token hardcoded in the GET method. But I want to use it as a variable, so I don't have to change it every time. I have created the variable $actonToken. I found a case in the community (https://community.qlik.com/t5/Connectivity-Data-Prep/REST-connector-with-automatic-date-update/m-p/1...), but can't get it to work for me. Can someone help me out with this?
-----
This is the input in Data Load Editor.
Let vActonToken = 'Bearer $(actonToken)';
LIB CONNECT TO 'REST Act-On list';
RestConnectorMasterTable:
SQL SELECT
"listId",
"offset",
"count",
"totalCount",
"emailColumn",
"__KEY_root",
(SELECT
"@Value",
"__FK_headers"
FROM "headers" FK "__FK_headers" ArrayValueAlias "@Value"),
(SELECT
"__KEY_data",
"__FK_data",
(SELECT
"@Value" AS "@Value_u0",
"__FK_data_u0"
FROM "data" FK "__FK_data_u0" ArrayValueAlias "@Value_u0")
FROM "data" PK "__KEY_data" FK "__FK_data")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (
QUERY"Authorization" $(vActonToken));