Hi Qlik Community,
I am currently facing a challenge with the implementation of a script involving a REST connector. Specifically, the query works as expected when entered within the request body box of the REST connector, but encounters difficulties when incorporated into a script.
The variable v_cursor serves as a key that dynamically changes with each execution and comes from the previous query.
I would greatly appreciate any guidance or assistance you could provide in resolving this matter.
Below is the relevant script snippet:
LET v_cursor = Peek('cursor', 0, 'items_page');
// STEP 2 - Next item page
LET v_next_page_body = ' "{""query"":""{next_items_page(cursor: $(v_cursor) ) { cursor items { id name column_values { column { title } text } }}""}" ';
// The query that works inside the box:
// { "query": "{ next_items_page(cursor: \"MSwxNjM2MjU3NzkzLG9tV2VnQVpfWnJCVnFLNEZQMzFaeCw5MTgsMjUsfDEyNjkxMzAzMTg\" ) { cursor items { id name column_values { column { title } text } }}"}
RestConnectorMasterTable:
SQL SELECT
"account_id",
"__KEY_root",
(SELECT
"__KEY_data",
"__FK_data",
(SELECT
"cursor",
"__KEY_next_items_page",
"__FK_next_items_page",
(SELECT
"id",
"name",
"__KEY_items",
"__FK_items",
(SELECT
"text",
"__KEY_column_values",
"__FK_column_values",
(SELECT
"title",
"__FK_column"
FROM "column" FK "__FK_column")
FROM "column_values" PK "__KEY_column_values" FK "__FK_column_values")
FROM "items" PK "__KEY_items" FK "__FK_items")
FROM "next_items_page" PK "__KEY_next_items_page" FK "__FK_next_items_page")
FROM "data" PK "__KEY_data" FK "__FK_data")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(
Url "https://api.monday.com/v2",
HTTPHEADER "Authorization" $(v_auth),
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "API-Version" "2023-10",
BODY $(v_next_page_body)
);
