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