REST API to pull data from sheet for integrating with other systems

[ariunbat]

Hi, we want to pull data or chart on the Qlik Sense to display on our internal web application with option to download, filter etc. Is it possible with REST APIs? I see that we could use Javascript API (capability API etc). But our application is based on Spring boot (Java). What are our options? 

Thanks 

[JuanGerardo]

Hi @ariunbat, I think your best option is to use the Qlik Engine JSON API: https://help.qlik.com/en-US/sense-developer/February2021/APIs/EngineAPI/index.html

You can use the ExportData method to export to CSV or Excel, and GetHyperCubeData to access directly the data used to draw a chart.

JG

[Øystein_Kolsrud]

There are no libraries available for interacting with the Qlik Sense APIs through Java as far as I know, so you would have to implement that on the websocket level. But you might want to look into the concept of "Mashups" and see if that provides you with sufficient capabilities for you application

https://help.qlik.com/en-US/sense-developer/February2021/Subsystems/Mashups/Content/Sense_Mashups/ma...

Even simpler is to use iframes to embed single visualizations in html:

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/embed...