topic Re: QlikView 11 and Java Integration via QMS API in QlikView

QlikView 11 and Java Integration via QMS API

Mon, 26 Jan 2026 16:26:21 GMT

Hello everyone,

I've been trying to utilize the QV web service on Java but I'm getting errors on the WSDL file.

Even in C#.net, I was not able to succeed using the web service by following the sample implementation mentioned at QMS API documentation.

Is there someone, succeeded utilizing the QV 11 web service ?

Please help.

Any response is highly appreciated.

Thanks,

Arnold

Re: QlikView 11 and Java Integration via QMS API

alex_nerush — Tue, 17 Apr 2012 06:45:37 GMT

Hello Arnold,

I'm not specialist in Java... But I have successful implementation using C#.NET and QMS API v.11...

Re: QlikView 11 and Java Integration via QMS API

Wed, 18 Apr 2012 07:58:50 GMT

Hi Alex,

Really apreciate the time and response.

Currently I was able to make the C#+QMS work. Do you know if QMS api can access the sheets and other objects inside the qvw file?

Basically, what I want to achieve is to get all the TableBox object together with its row and column values inside a specific document.

I read the API documentation, but I couldn't find the right method.

Please help.

Thanks,

Arnold

Re: QlikView 11 and Java Integration via QMS API

alex_nerush — Wed, 18 Apr 2012 08:16:51 GMT

I think such functionality doesn't available in current release (but you can get field list, field content)... You can look forward 3rd party software - like this http://www.qvsconnector.com/. Or you can try to use QlikOCX component to achive such functionality.

Re: QlikView 11 and Java Integration via QMS API

Wed, 18 Apr 2012 08:25:30 GMT

thanks a lot Alex!

Do you know if it is possible to integrate the QlikOcx with Java?

Re: QlikView 11 and Java Integration via QMS API

alex_nerush — Wed, 18 Apr 2012 08:34:30 GMT

Sorry, i have no idea regarding Java and QlikOcx.. Maybe this link will be useful for you http://javaactivex.com/

Re: QlikView 11 and Java Integration via QMS API

Thu, 19 Apr 2012 01:40:02 GMT

Hi Alex,

Do you have a sample .net program using QlikOcx to retrieve tablebox objects together with its values within a specific qvw document?

Thanks,

Arnold

Re: QlikView 11 and Java Integration via QMS API

alex_nerush — Thu, 19 Apr 2012 06:26:49 GMT

Here are you couple lines of code from my project, maybe this will be helpful for you. Documentation available right here http://community.qlik.com/docs/DOC-2639(see The QlikView Core COM API)

axQlikOCX1 - instance of QlikOCX object.

axQlikOCX1.ActiveDocument.GetSheetObject(objectId) - this method i've used to retrieve reference for appropriate object in the document.

....

public void OpenDocument(string link, string username, string password)

{

if (axQlikOCX1.HasOpenDocument())

{

axQlikOCX1.ActiveDocument.CloseDoc();

}

if(!String.IsNullOrEmpty(username))

axQlikOCX1.OpenDocument(link, username, password);

else

axQlikOCX1.OpenDocument(link);

}

...

public void Select(string fieldName, string fieldValue)

{

if (axQlikOCX1.HasOpenDocument())

{

axQlikOCX1.ActiveDocument.Fields(fieldName).Select(fieldValue);

}

...

public void SelectValues(string fieldName, IEnumerable<string> values, bool isNumeric)

{

if (axQlikOCX1.HasOpenDocument())

{

//axQlikOCX1.ActiveDocument.Clear();

QlikView.Field f = axQlikOCX1.ActiveDocument.GetField(fieldName);

QlikView.IArrayOfFieldValue fv = f.GetNoValues();

int i = 0;

foreach (string value in values)

{

double result;

if (isNumeric && Double.TryParse(value, out result))

{

fv.Add();

fv.Number = result;

fv.IsNumeric = true;

++i;

}

else

{

fv.Add();

fv.Text = value;

fv.IsNumeric = false;

++i;

}

// f.Clear();

f.SelectValues(fv);

}

...

public IEnumerable<string> GetPossibleValues(string fieldName)

{

List<string> values = new List<string>();

QlikView.Field f = axQlikOCX1.ActiveDocument.GetField(fieldName);

if (f != null)

{

QlikView.IArrayOfFieldValue fv = f.GetPossibleValues();

for (int i = 0; i < fv.Count; ++i)

{

if (fv.IsNumeric)

values.Add(fv.Number.ToString());

else

values.Add(fv.Text);

}

return values;

}

...

public void CopyObjectToClipboard(string objectId)

{

if (axQlikOCX1.HasOpenDocument())

{

QlikView.SheetObject o = axQlikOCX1.ActiveDocument.GetSheetObject(objectId);

if (o != null)

o.CopyTableToClipboard(true);

//o.CopyBitmapToClipboard();

}

QlikView 11 and Java Integration via QMS API

Thu, 19 Apr 2012 07:29:50 GMT

Hi Alex,

Would QlikOcx work with a console application?

Thanks a lot.

Regards,

Arnold

QlikView 11 and Java Integration via QMS API

alex_nerush — Thu, 19 Apr 2012 07:49:24 GMT

I've never used it in the console apps.

QlikView 11 and Java Integration via QMS API

Thu, 19 Apr 2012 13:07:54 GMT

The WSDL- and Schema-Files are not usable for Java (I used JAX-WS/METRO to generate the stubs - AXIS2 does'nt worked at all), you need to modify them a little bit. Sadly I cannot attach the files here. Is there a area where I can post attachments (if someone is interested)?

BR, Lars

Re: QlikView 11 and Java Integration via QMS API

Fri, 20 Apr 2012 07:41:50 GMT

Hi Lars,

I'm very interested with the wsdl. Kindly send it to me please.

Here is my email arnoldayaoanjr@yahoo.com.

Thanks,

Arnold

Re: QlikView 11 and Java Integration via QMS API

Fri, 20 Apr 2012 08:57:48 GMT

Done! Have fun with it 😉

Re: QlikView 11 and Java Integration via QMS API

Anonymous — Fri, 14 Sep 2012 20:34:02 GMT

Hi Arnold can you please help on how to connect to Qlikview server through JAVA. Any help on this is greatly appreciated.or els you if you have the document on wsdl can you please send that to me. My email id kumar91936@gmail.com

Re: QlikView 11 and Java Integration via QMS API

Tue, 08 Jan 2013 18:02:08 GMT

Could you please send your example to my email dabaipang@hotmail.com

Very appreciate your help!

Re: QlikView 11 and Java Integration via QMS API

Mon, 14 Jul 2014 10:41:16 GMT

Hi Lars Bayer,

Can you please help me out of the same. I need to integrate the Qlikview application to an Iframe. Any help on this would be useful.

Thanks..

Re: QlikView 11 and Java Integration via QMS API

Thu, 13 Nov 2014 17:50:43 GMT

I am also running into same issue not able to use the wsdl we get from http://<host_name>:4799/QMS/Service

I will really appreciate if someone can email (sharma.rakesh@rediffmail.com) me the working wsdl.

Thanks,

Rakesh

sharma.rakesh@rediffmail.com

Re: QlikView 11 and Java Integration via QMS API

rwunderlich — Thu, 13 Nov 2014 18:44:57 GMT

It's difficult to get Java to work with the QMS API. The API requires Windows Auth, which I've never been able to get working with Java.

-Rob

Re: QlikView 11 and Java Integration via QMS API

Thu, 13 Nov 2014 19:02:30 GMT

I am able to use org.apache.http.auth package to implement NTLM authentication and implemented sso from our web app to qlikview in JSP page. Now I am looking into how to use QMC web service api to use from java but issue I have WSDL from http://<host_name>:4799/QMS/Service is not working as I am getting parse errors.

In the post I see Lars Bayer said he was able to get the wsdl working. So I am looking for the either to generate the wsdl properly or working WSDL itself.

Thanks,

Rakesh

Re: QlikView 11 and Java Integration via QMS API

Fri, 22 Jul 2016 08:43:59 GMT

Hi Lars

Do you still have the modified wsdl?? I'm very interested. Would you kindly send it to me please?
My email is hugaro@gmail.com

Thank you! Hugo