topic Re: QlikSense App Object metadata relationships in Integration, Extension & APIs

QlikSense App Object metadata relationships

schatterjee — Fri, 15 Nov 2024 23:39:01 GMT

Hi,

I am using QRS API to get the metadata for the app and its app objects, like sheets, barchart, etc. But in the metadata response I am not able to find any relationship attribute which can let me know which chart is part of which sheet, or which dimension and measure is part of which chart, etc.

Is there any way I can get this information through any API?

Thanks

Re: QlikSense App Object metadata relationships

Øystein_Kolsrud — Wed, 06 Oct 2021 10:02:08 GMT

You'll have to go through the engine API to get that type of information. The QRS has no knowledge of the relations between objects.

Re: QlikSense App Object metadata relationships

schatterjee — Wed, 06 Oct 2021 10:42:21 GMT

Ok. Thanks. If possible can you refer me to the correct engine API method which can be used to get this information?

Re: QlikSense App Object metadata relationships

Øystein_Kolsrud — Wed, 06 Oct 2021 11:48:22 GMT

There are multiple ways to achieve this, but to find all instances of master object usage I'd probably go with first getting a list of all the sheets, then do a call to "GetFullPropertyTree" and traverse the result and identify all master object instances. This would be the endpoint to call:

https://help.qlik.com/en-US/sense-developer/August2021/Subsystems/EngineJSONAPI/Content/models-genericobjectentry.htm

Re: QlikSense App Object metadata relationships

Øystein_Kolsrud — Wed, 06 Oct 2021 11:49:25 GMT

If you want to identify all master measure and dimensions as well, then that's harder as you would have to analyze the expressions used in the different objects.

Re: QlikSense App Object metadata relationships

schatterjee — Thu, 07 Oct 2021 04:51:58 GMT

Thank you. Will look into it