Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

louwriet
Contributor

Calling webservice method out of Qlikview with macro

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

1 Solution

Accepted Solutions
Not applicable

Re: Calling webservice method out of Qlikview with macro

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

7 Replies
Not applicable

Re: Calling webservice method out of Qlikview with macro

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

louwriet
Contributor

Re: Calling webservice method out of Qlikview with macro

Hi Krunoslav,

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

Regards

Louw

vinay_bangari
Valued Contributor III

Re: Calling webservice method out of Qlikview with macro

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.

louwriet
Contributor

Re: Calling webservice method out of Qlikview with macro

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

vinay_bangari
Valued Contributor III

Re: Calling webservice method out of Qlikview with macro

Hi Louw,

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

Thanks,

Vinay

varunjain
Contributor

Re: Calling webservice method out of Qlikview with macro

Hi

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!

varunjain
Contributor

Re: Calling webservice method out of Qlikview with macro

Hi

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!

Community Browser