topic How to fetch dimensions and measures data using Qlik Sense engine API? in Integration, Extension & APIs

How to fetch dimensions and measures data using Qlik Sense engine API?

Anonymous — Thu, 01 Mar 2018 03:49:34 GMT

Hi all,

I am currently exploring Qlik Sense Engine API to fetch data from application & my flow is,

1. OpenDoc method. I passed appId as qDocName & document got opened.

2. CreateSessionObject is to create dummy object for data fetch.

Here I got stuck what to do next?

Though I have dimensions and measures names. but I don't know how to use it to fetch the data.

Is above flow in right way? if no then please do suggest and provide steps or code to follow.

I want HyperCube which contains my dimensions & measures values.

Any help will be appreciated.

Bhargav Patel.

Re: How to fetch dimensions and measures data using Qlik Sense engine API?

_jespers_ — Thu, 01 Mar 2018 07:27:59 GMT

Hi Bhargav,

Is there a reason you must use the Engine API to do this?

Otherwise, have you looked at the documentation for create cube with the App API?

https://help.qlik.com/en-US/sense-developer/February2018/Subsystems/APIs/Content/CapabilityAPIs/AppAPI/createCube-method…

Re: How to fetch dimensions and measures data using Qlik Sense engine API?

ErikWetterberg — Thu, 01 Mar 2018 10:04:57 GMT

Hi,

I have written a post on this here:

https://extendingqlik.upper88.com/qlik-sense-generic-object-ii-hypercube-properties/

Note that you can use the mashup editor in dev-hub to help you with this. Hypercube format is the same whether you use Engine api or capabilities APIs.

If you prefer a video, there is one at youtube:

https://www.youtube.com/watch?v=pDbDbkc22Ds

Hope this helps

Erik Wetterberg

Re: How to fetch dimensions and measures data using Qlik Sense engine API?

Anonymous — Thu, 01 Mar 2018 13:20:45 GMT

Thanks for your response Jesper.

The reason to explore Engine API is to connecting qlik with python using websockets.

Re: How to fetch dimensions and measures data using Qlik Sense engine API?

Anonymous — Thu, 01 Mar 2018 13:24:22 GMT

again awesome response Erik but is there any tutorial available so that i could interact with qlik sense using websockets in python?

Re: How to fetch dimensions and measures data using Qlik Sense engine API?

mark_casselman — Sun, 03 Feb 2019 01:12:48 GMT

Look at this python library: https://github.com/qliknln/pyqlikengine.

Examples in the test folder.

Although the library is not maintained anymore it worked perfectly for me.