API connection

[the-null]

Hi,
I want to connect data from a Qlik Sense application with an external application. My goal is to retrieve only a specific dataset from a specific sheet within the application through an API connection. What are the steps to achieve this?

[Ray_Strother]

Hello,

1. I don't think what you are asking is possible.
2. You can export the data and then upload to your application (review below links on exporting).
3. You should also consider the possibility of embedding the Qlik Sense sheet (per below link).

Article links:

1. https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/APIs/Content/Sense_ClientAPIs/Capabil...

2. https://help.qlik.com/ja-JP/sense-developer/June2018/apis/EngineAPI/services-GenericObject-ExportDat...

3. https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/Dev-Hub/Content/Sense_Dev-Hub/Howtos/...

[Øystein_Kolsrud]

It's certainly possible to extract data from a specific visualization through the engine API. Is that what you are looking for? If so, the key is to use the following method to extract your data:

https://qlik.dev/apis/json-rpc/qix/genericobject/#gethypercubedata

There are plenty of examples on how to use this method available including this one that illustrated how to work with data in C#:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/tree/master/HypercubeUsage

In particular, this method illustrates how to retrieve all data from a specific visualization:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/blob/master/HypercubeUsage/Program.cs#L7...