topic Re: Need to call webservice macro from load script in QlikView

Need to call webservice macro from load script

sbumeshqlik — Fri, 15 May 2015 16:44:37 GMT

Hello,

In my QV, I have macro to call webservice

function getAirportWSDL(vInput)

vURL = "http://www.webservicex.com/airport.asmx/getAirportInformationByISOCountryCode?CountryAbbrviation="+ vInput

'set txt1 = ActiveDocument.Variables("vXMLSent")

'txt1.setContent "Null", true

'Create xmlhttp opject

Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

xmlhttp.open "GET", vURL, false

xmlhttp.setRequestHeader "Content-Type", "text/xml"

xmlhttp.send ""

result = xmlhttp.responseText

result = replace(result, ">", ">")

result = replace(result, "<", "<")

set txt = ActiveDocument.Variables("vXMLReceived")

txt.setContent result, true

'getAirportWSDL = vInput

End Function

-----------------------------------------------------------------------------------------

in my load script,after reloading, it is not fetching any values to vXMLReceived

let vXMLReceived = ' ';

LET Creat = getAirportWSDL( 'BH');

Any help, would be appreciated.

Regards,

Umesh.

Re: Need to call webservice macro from load script

petter — Sat, 16 May 2015 23:03:50 GMT

You can't access the ActiveDocument from a VBscript-function that you call from a Load Script. The ActiveDocument hasn't been intialized yet. So you will have to return the result as a return result from the function:

getAirportWSDL = result

End Function

and then the variable Creat get the result as a value.

LET Creat = getAirportWSDL('BH');

I would suggest that you rename the variable to resultAirport

LET resultAirport = getAirportWSDL('BH');

This variable you can easily access in your application once the Load Script has finished running and the application has started.

Re: Need to call webservice macro from load script

petter — Sat, 16 May 2015 23:19:41 GMT

Re: Need to call webservice macro from load script

ToniKautto — Sun, 17 May 2015 00:46:41 GMT

It looks like your macro only makes a HTTP GET to a web source and retrieves XML data. Why do you not just load this as an XML source directly in the load script?

Re: Need to call webservice macro from load script

sbumeshqlik — Sun, 17 May 2015 02:23:54 GMT

Hi Peter,

Thanks, a lot.

Would, appreciate, if you Can please let me know how to parse xml string resultAirportXML.

Re: Need to call webservice macro from load script

petter — Sun, 17 May 2015 07:11:37 GMT

You should consider Toni's good advice since a load statement will help you parse the XML properly. If you tell more about how you intend to use the data in your application it would be easier for us to give you further advice.

For a small XML-payload like this service it is rather straight forward anyway to parse it manually. Where do you prefer to have the code? In the load script or in VBScript? VBScript has some limitations as to how you can run it and how efficiently it will run on a server. If you do everything in the load script it will be quite easy to do the same in Qlik Sense in the future whereas a VBScript solution has to be converted.

Re: Need to call webservice macro from load script

sbumeshqlik — Sun, 17 May 2015 15:26:26 GMT

Hi Peter,

Thanks, in that case, would prefer to have, XML string parsing, in QV LOAD script.

Re: Need to call webservice macro from load script

petter — Sun, 17 May 2015 16:15:33 GMT

If you consider your question answered you could close this thread and I will have something for you on your new question on how to parse XML in the Load Script.

Re: Need to call webservice macro from load script

sbumeshqlik — Sun, 17 May 2015 22:49:40 GMT

Hi Peter,

Thanks.

Re: Need to call webservice macro from load script

petter — Mon, 18 May 2015 06:17:25 GMT

If you start a new question with for example "XML string parsing, in QV LOAD script" as a title - I can respond and upload something I have as a response to that.

Thanks

Re: Need to call webservice macro from load script

sbumeshqlik — Wed, 20 May 2015 13:11:19 GMT

Thanks a lot, for all your help. Will start a new question about XML String Parsing.

Re: Need to call webservice macro from load script

sbumeshqlik — Sat, 23 May 2015 21:44:07 GMT

Hi Petter,

Started a new question about "XML string parsing, in QV LOAD script"

enclosed URL below

https://community.qlik.com/message/779723?et=watches.email.thread#779723t

On Mon, May 18, 2015 at 2:17 AM, Petter Skjolden <qcwebmaster@qlikview.com>