topic Re: Fetching raw data values using Qlik Engine JSON Api in Integration, Extension & APIs

Fetching raw data values using Qlik Engine JSON Api

gokulmanojnair — Tue, 16 Oct 2018 07:23:16 GMT

I have a Qlik sheet in which I have added a few dimensions and measures. eg. Geography and Sales.

I want to use the Engine JSON Api to get data values on the fly. i.e I want to pass a selection eg. Geography = 'XYZ' through the API and get the resulting raw Sales values.

How can I do this?
Should I use a table or hypercubes or fields or can I directly use the dimensions and measures ?
What APIs should I use?

I am planning to implement this code in JAVA.

Re: Fetching raw data values using Qlik Engine JSON Api

Øystein_Kolsrud — Wed, 17 Oct 2018 06:48:28 GMT

This is definitely what you would use the Engine API for. The exact endpoints to use would depend on what type of selections and data extraction you want to do, but if you just want to do a selection on a field and then extract the "Sum(Sales)", then you could use these two endpoints:

https://help.qlik.com/en-US/sense-developer/September2018/apis/EngineAPI/services-Field-SelectValues.html

https://help.qlik.com/en-US/sense-developer/September2018/apis/EngineAPI/services-Doc-Evaluate.html

For more complex data extraction you might need to use a hypercube.

I don't think there are any ready API's available for this in Java though, but I have a very experimental one that I could put up on git hub if you like. Otherwise the most common languages to use for this are JavaScript and C#. This is the most popular one in JavaScript:

https://help.qlik.com/en-US/sense-developer/September2018/Subsystems/APIs/Content/Sense_ClientAPIs/enigmajs/enigmajs-int…

And this is for C#:

https://help.qlik.com/en-US/sense-developer/September2018/Subsystems/NetSDKAPI/Content/Sense_NetSDKAPI/Introduction/Net-…

This project illustrates how to use hypercubes for selection and data extraction using C#:

Qlik Branch

Re: Fetching raw data values using Qlik Engine JSON Api

deeksha_yekkant — Mon, 26 Nov 2018 12:29:16 GMT

Hi Yko,

I am planning to read the data from qlik sense using engine JSON api through java code.

Could you please provide me the Java Api code.It will be really helpful.

Many thanks in advance.

Regards,

Deeksha

Re: Fetching raw data values using Qlik Engine JSON Api

Øystein_Kolsrud — Tue, 27 Nov 2018 09:02:00 GMT

Hmm... Looking at my old code, I don't think it will be very helpful. It's a mess, and it only supports desktop connections anyway.