How can I get a list of all objects in a Qlik Sense sheet for an App!

[nirav_bhimani]

Hi,

I am looking for a list of all the objects used in the sheet, along with the following information,

ObjectID, ObjectName, ObjectType, SheetID, SheetName, AppID, AppName

e.g. hvUm, Timeline Trend, Line Chart, 5d1b84ba-30fc-4f30-b2b0-c9f604e1ca5f, Dashboard, 027a72f6-d874-41bb-abfb-0ac9afa7bae9, Sales Dashboard

I used below query to get the App & Sheet level Information but not getting sheet Objects information.

App_Sheets:
SELECT
ao."ID" AS "SheetId",
ao."Name" as "SheetName",
ao."ObjectType",
a."ID" as App_ID,
a."Name" as App_Name
FROM
"AppObjects" ao
JOIN
"Apps" a ON ao."App_ID" = a."ID"
WHERE
ao."ObjectType" = 'sheet' and
a."ID" = 'e4e92eac-be67-4f4a-b59d-db6f6569c6b5';

Can any one help!

Regards,

Nirav Bhimani

[rwunderlich]

I looks like you are reading directly from the Repository DB? The preferred method is to use the QRS API. But in either approach, I don't think the data you are looking for is in the repository. It's stored in the app itself and can be fetched using the Engine API. 

You can also use my product QSDA Pro to extract the data you are looking for. You can view the data with the QSDA UI or export if you want to ingest elsewhere. QSDA Pro can be used with a browser UI or REST API. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com