How to get sheets data as json object of qlik Application

[Manpreet]

Hi,

Can you please let us know to we can get the sheets data as json object of an application created in qlik. We have tried details provided in below link.

https://qlik.dev/apis/javascript/capabilities#%23%2Fdefinitions%2FQApp%2Fentries%2FgetObject

But not able to find the way to get all sheets with complete data in json format.

[Chip_Matejowsky · Accepted solution]

Hi @Manpreet,

You can use the Qlik REST connector to load json data.

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-c...
https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-R...

Best Regards

[KunalChugh]

Hi,

Is there any other way like using "Capability APIs" and other  Rest API,s as our client doesn't want to use connectors.

[Bill_Britt · Accepted solution]

Hi,

Using the QRS API the below will work

/qrs/app/object/{sheet_id}

[fruityhost]

Hi! There's also an external solution to this - Gitoqlok browser extension for Qlik Sense for version control. Since it seamlessly integrates with Git providers (GitHub, GitLab, BitBucket, etc.), you can selectively commit Qlik objects to the repository so that sheets json file is stored right there. It's a convenient way because besides getting sheets data as json object  you're also capturing the history of changes for a current sheet. Check out https://docs.gitoqlok.com/