topic How to fetch Visualization data from Postgres. in Integration, Extension & APIs

How to fetch Visualization data from Postgres.

VatsalyaSolanki — Fri, 12 Apr 2024 12:40:55 GMT

Hi Community,

In which table in postgres can I find information regarding the visualization used in my app. From the table AppObjects I did get the sheet Id, but where can I find the information regrading the visualizations in the sheets.

Any help would be appreciated.

Re: How to fetch Visualization data from Postgres.

alex_colombo — Wed, 17 Apr 2024 09:18:56 GMT

Hey @VatsalyaSolanki , why you need to get this info from Postgres? I reccomend to get this information using Engine APIs.

Re: How to fetch Visualization data from Postgres.

VatsalyaSolanki — Thu, 18 Apr 2024 11:54:14 GMT

Hi @alex_colombo , Its not necessary to use Postgres, I am not aware about which method to use, could you suggest me which method should be used for fetching the AppObjects data.

Re: How to fetch Visualization data from Postgres.

Øystein_Kolsrud — Thu, 18 Apr 2024 12:01:48 GMT

You can get information about app objects through this endpoint:

https://help.qlik.com/en-US/sense-developer/February2024/APIs/RepositoryServiceAPI/index.html?page=1538

But as @alex_colombo points out, you might need to go through the engine API to get the full picture. The repository (and therefore the database) only knows about the top level objects, like sheets. If you need to look at what objects are in the sheets, then you'll need to go through the engine.