Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Engine API and vba

Hi,

I managed to successfully use the protocol tester on http://localhost:4848/ but I'd like to know if it is possible to use the Qlik Engine API with vba (Excel or Access for example) to do automation on Qlik Sense Desktop ? We can send json request with Excel-REST maybe..but what is the url to use (http://locaslhost:4848/api ???). Do you have an example of this ?

Thanks a lot.

Guen (sorry for my english...french are so bad in english !!)

6 Replies
Not applicable

Re: Qlik Engine API and vba

Hi,

If it's not necesary to use COM there is the Qlik Sense .Net SDK that you could use. You will find more information about the .Net SDK on https://help.qlik.com/sense/en-us/developer/

Lars-Göran Book

Not applicable

Re: Qlik Engine API and vba

Hi,

I saw this SDK effectively but I don't know if Y can use .net object in vba environment... may be with an external connector...

thanks

Not applicable

Re: Qlik Engine API and vba

OK, I can create a dll to use it in vba but... where can I find the qlik's dll (I run desktop version) ???

thank's

Not applicable

Re: Qlik Engine API and vba

Hi, i am still looking for a solution for this topic... it is not possible to use the .net sdk because i am not a qlik  partner... so i try with json request on the local url but...no success..is it possible by this way ?

Thanks

Not applicable

Re: Qlik Engine API and vba

Hi you will find the dlls in a zip file under "Downloads" (QliokSense.NetSDK1.0.x_x64.zip). Be sure to download the version as you have on your desktop. You will also find useful help under the developer site in help.qlik.com.

Not applicable

Re: Qlik Engine API and vba

yes...but I have not this file under Downloads, I am not a Qlik partner..I "only" use free QLik Sense Desktop...