Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
NitinK7
Specialist
Specialist

Find qliksense sheet id

Hi team,

There is any way to find out qliksense sheetid in script and set to variable.

 

Thanks,

Nitin.

Labels (1)
1 Solution

Accepted Solutions
kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant

View solution in original post

1 Reply
kfoudhaily
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant