topic REST API to pull data from sheet for integrating with other systems in Integration, Extension & APIs

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

ariunbat — Wed, 28 Apr 2021 08:02:03 GMT

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

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

JuanGerardo — Wed, 28 Apr 2021 08:34:19 GMT

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.

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

Øystein_Kolsrud — Wed, 28 Apr 2021 10:56:19 GMT

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/mashups-introduction.htm

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-visualization-sheet.htm