topic Re: How to query qlikview via a RESTFUL API in QlikView

How to query qlikview via a RESTFUL API

Wed, 25 Nov 2020 16:16:04 GMT

I have been contracted to a company that is using qlik-view to aggregate their data. I have an external system that needs to be able to query the data stored in qlik-view so therefor:

1. Is this possible?

2. If this is possible is there either a REST or SOAP connector.

Thank you

Re: How to query qlikview via a RESTFUL API

jerrysvensson — Tue, 28 Jun 2016 09:57:01 GMT

Download QlikRESTConnector. It is free and will probably have everything you need.

Search forum for download link.

Re: How to query qlikview via a RESTFUL API

Tue, 28 Jun 2016 12:43:11 GMT

Thanks for replying @Jerry Svensson. Apologies if I sound silly for checking, I have never used qlik view before. QlikRESTConnector is only for qlik sense according to QlikRESTConnector install page.

I asked the guy who deals with it here and he said we only have qlik view and not qlik sense and after some of my own research it appears qlik view can only post data.

I want to create an endpoint in qlikview that I can hit.

For example qlikview contains aggregated client data from multiple systems and in qlikview we have created this aggregated client entity.

I want an endpoint like qlikview/client that when hit should return this client object to the calling web service.

Re: How to query qlikview via a RESTFUL API

Joaquin_Lazaro — Tue, 28 Jun 2016 13:46:27 GMT

Hello DH

If I understand you right, you want to read QlikView data using other software, well I think this is no available software for doing it,

But I will follow this post because it's a interesting question

Regards

Joaquín

Re: How to query qlikview via a RESTFUL API

jerrysvensson — Tue, 28 Jun 2016 13:53:55 GMT

Ah, my bad. Read it the other way..

You could store the data as qvd files using textformat. If that solves your problem.

Re: How to query qlikview via a RESTFUL API

Wed, 29 Jun 2016 06:23:02 GMT

Hi Jerry, thanks for following up, so we discussed that option and just for the start of integration we are going to have qlikview produce a csv which our system will consume.

We are not so happy with this option and we were hoping that there was some way for our system to access the qlikview data store directly. Either through opening the end point as I have suggested above or some other mechanism.

Just a note, this is an investigation to see if this is possible with qlik view. But we do need to report our finding by tomorrow.

Thank you for the help

Re: How to query qlikview via a RESTFUL API

Wed, 29 Jun 2016 06:24:54 GMT

Hi joaquinlr

Yes you are right, qlik view basically contains all the data our external system needs and we want to read directly from it.

Thanks for your input

Re: How to query qlikview via a RESTFUL API

Joaquin_Lazaro — Wed, 29 Jun 2016 06:43:48 GMT

Hi DH:

There are two products QlikView OCX and QlikView Workbench for using your data and charts in your company web or business software ... but you must buy both of them.

Joaquín

Re: How to query qlikview via a RESTFUL API

Anil_Babu_Samineni — Wed, 29 Jun 2016 06:57:08 GMT

DH,

Before moving please confirm me.

1) Yes, It's possible

2) Might be you are new to QlikView - So, How do you contact to another company to get the data. Is there any key to release the BRD.

3) If Yes, Let me know what they are thoughts.

- Anil

Re: How to query qlikview via a RESTFUL API

Wed, 29 Jun 2016 07:27:25 GMT

Hi Joaquín

Do you mean that QlikView OCX and QlikView Workbench can be used to extract the data?

Just to give some more info I am a software dev. So with a team we are creating a new front and back end system for the client. We are writing the backend in C#. Reading through the workbench docs it looks like you have to add qlik view components on your web site.

This indicates to me that there is a .dll which contains code that has the ability to query qlik view for data. Basically I would just like to access those functions without having to include a qlik view component on my site.

We are creating custom site and therefor will manipulating the data and displaying it on the website with our custom components and graphs.

Please if anything I have said is unclear I will explain further .

Re: How to query qlikview via a RESTFUL API

Wed, 29 Jun 2016 07:47:15 GMT

Hi Anil

Just to check, you are stating that it is possible right?

I am brand new to Qlik view. I am a software dev working with a qlik view contractor.

The business is reliant on qlik view for its reporting. So we don't want to change anything there.

Our new system needs to tap into the information contained within qlik view. If this is possible it will save us a lot of work. But we just want the data.

Re: How to query qlikview via a RESTFUL API

Fri, 29 Jul 2016 12:41:07 GMT

After much searching and testing we have eventually come back to what we currently decided to do which was to consume a csv file produced by Qlik view.

Re: How to query qlikview via a RESTFUL API

Clever_Anjos — Fri, 29 Jul 2016 13:19:25 GMT

Data stored into a Qlikview ecosystem are not exposed using a API.