topic Re: Access data in your Qlikview via API in QlikView

Access data in your Qlikview via API

pauljohansson — Fri, 29 Jan 2016 10:15:53 GMT

Hi,

If I have published a Qlikview on the Accesspoint. Would it then be possible to access its data based on bookmarks via a API?

Thanks in advance,

Paul

Re: Access data in your Qlikview via API

petter — Fri, 29 Jan 2016 11:54:27 GMT

Yes it is. The API that you can use is COM. So you can reference the type library called QlikTech.QlikView. A prerequisite for this is that you install QlikView Desktop. The type library and COM object will then be installed when the QlikView Desktop is installed.

You can through COM access both local QVW-files and files located on a QlikView Server. Through the object model exposed through COM you can select bookmarks and then access the subset of data. Mind you this is not a high performance massive data manipulation API.

Re: Access data in your Qlikview via API

pauljohansson — Thu, 04 Feb 2016 16:35:13 GMT

Hi Petter,

Thanks for your reply!

I have trouble finding a simple example on this. Perhaps you have a basic code example on this, or maybe you can point in any direction on how to access a qvw using COM and perform a simple(any) operation.

thanks in advance,

Paul

Re: Access data in your Qlikview via API

petter — Thu, 04 Feb 2016 16:55:53 GMT

Which language would you like to use to access the COM-API from? VBscript, JScript, VBA, C#, VB.NET ?

Any of them could be used - but giving you an example that is relevant is better right?

Re: Access data in your Qlikview via API

petter — Thu, 04 Feb 2016 17:11:46 GMT

Here is an example in C# with Visual Studio Community 2013.

- To add a reference to QlikView type library and get access to the COM Object Model you need to go to

PROJECT / Add Reference / Type Library (see the dialog box underneath) :

The nice thing here is that you get full IntelliSense into the object model of QlikView and it is so much nicer than having to lookup the API-documentation manually.