topic Re: Calling webservice method out of Qlikview with macro in QlikView

Calling webservice method out of Qlikview with macro

louwriet — Sun, 09 Oct 2011 16:51:52 GMT

Hi,

I came across this threat by Rakesh Mehta http://community.qlik.com/docs/DOC-1320 that describes and give a solution to what I want to achieve.

I am uploading pdf reports out of Qlikview onto a FTP site where I host the reports(this work fine). But what I need to do is to call a method on the webserver through a webservice that will test if all reports were in fact uploaded successfully and return the names of all the reports that was uploaded.

I went through his example but I get the same errors as the two persons who posted in his threat. Does anyone know why this macro get stuck at “xmlhttp.send” and display “" Duplicate keys when loading Input Field"

My security is set to allow system access. I am using Qlikview ver 10

Would really like to get this example working.

Your help is appreciated

Regards

Louw

Re: Calling webservice method out of Qlikview with macro

Sun, 09 Oct 2011 17:34:35 GMT

Hi,

I had the same issues when executing that macro, so I have made two changes in it:

- set ws URL to "http://wsf.cdyne.com/WeatherWS/" instead '"http://ws.cdyne.com/WeatherWS/" (it seems that ws URL was changed in the meantime).

- xmlhttp object is initialized with CreateObject("MSXML2.ServerXMLHTTP"), instead CreateObject("Microsoft.XMLHTTP").

In attachment is macro with those changes.

regards

Re: Calling webservice method out of Qlikview with macro

louwriet — Wed, 12 Oct 2011 12:58:57 GMT

Hi Krunoslav,

Thanks so much for your help - it solved my problem.

Regards

Louw

Re: Calling webservice method out of Qlikview with macro

Anonymous — Mon, 17 Sep 2012 15:05:55 GMT

Hi Louw, I am uploading pdf reports out of Qlikview onto a FTP site where I host the reports(this work fine). But what I need to do is to call a method on the webserver through a webservice that will test if all reports were in fact uploaded successfully and return the names of all the reports that was uploaded.

for doing the above action can you please let me know how your url will look like . And what are the url parameters you have used. And format of the reponse. Any help on this is greatly appreciated.

Re: Calling webservice method out of Qlikview with macro

louwriet — Mon, 17 Sep 2012 17:50:19 GMT

Hi Vinay,

I ended up also just adding reports to a FTP site where my customers downloaded it. What you want to achieve would be interresting and i can understand the importance and that was my intention at that stage.

Sorry i cant help at this stage.

Regards

Louw

Re: Calling webservice method out of Qlikview with macro

Anonymous — Mon, 17 Sep 2012 21:02:33 GMT

Hi Louw,

Thank you for your response. Will let you know if i get anything .

Thanks,

Vinay

Re: Calling webservice method out of Qlikview with macro

varunjain — Thu, 05 Sep 2013 18:33:45 GMT

I have a scenrio where in there is a qlikview attribute SECS_ID which a user would select and according to that input a SOAP web service is called and shows the information accordingly.

I have gone through your doc but bein a webservice/XML illiterate, i am not able to understand which fields are static and dynamic and what all things do I need to ask from the Webservice guy.

Please help!

Thanks!

Re: Calling webservice method out of Qlikview with macro

varunjain — Thu, 05 Sep 2013 18:34:21 GMT

I have a scenrio where in there is a qlikview attribute SECS_ID which a user would select and according to that input a SOAP web service is called and shows the information accordingly.

I have gone through your doc but bein a webservice/XML illiterate, i am not able to understand which fields are static and dynamic and what all things do I need to ask from the Webservice guy.

Please help!

Thanks!