Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
There is any way to find out qliksense sheetid in script and set to variable.
Thanks,
Nitin.
hello,
you can query qrs via rest connector to get the sheetid:
RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u2",
"engineObjectId",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"description",
"objectType",
"publishTime" AS "publishTime_u0",
"published" AS "published_u0",
"approved",
"name" AS "name_u2",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"id" AS "id_u1",
"__KEY_app",
"__FK_app"
FROM "app" PK "__KEY_app" FK "__FK_app")
FROM JSON (wrap on) "root" PK "__KEY_root";
easiest way t get more info about this is to reverse "operations monitor" application in monitoring apps
regards,
hello,
you can query qrs via rest connector to get the sheetid:
RestConnectorMasterTable:
SQL SELECT
"id" AS "id_u2",
"engineObjectId",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"description",
"objectType",
"publishTime" AS "publishTime_u0",
"published" AS "published_u0",
"approved",
"name" AS "name_u2",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"id" AS "id_u1",
"__KEY_app",
"__FK_app"
FROM "app" PK "__KEY_app" FK "__FK_app")
FROM JSON (wrap on) "root" PK "__KEY_root";
easiest way t get more info about this is to reverse "operations monitor" application in monitoring apps
regards,