topic Web Service request in extension in QlikView

Web Service request in extension

Mon, 26 Jan 2026 16:26:21 GMT

I'm currently working on a Google Map extension where i want to consume an XML output from a web service that i am attempting to call. I'm not an expert in Javascript or jQuery (which i belive will help me collect the XML) so i'm learning as i go along.

Does anyone have an example of an extension that they are doing something similar what they wouldn't mind sharing in order that i can gain the knowledge needed to implement it into my extension?

This is my code which currently fails in the pareseResult function on the 'length' flag

    Qva.LoadScript ("Extensions/Mouchel/GMapsRealTime/jquery-1.4.4.min.js", function () {
                    // For more information on doing XMLHR with jQuery, see these resources:
                    // http://net.tutsplus.com/tutorials/javascript-ajax/use-jquery-to-retrieve-data-from-an-xml-file/
                    // http://marcgrabanski.com/article/jquery-makes-parsing-xml-easy
                    $(document).ready(function() {
                      $.ajax({
                              type: "POST",
                              url: "http://localhost/CEOStatusWebService/CEOStatus.asmx/GetStatusForAllCEOs",
                              data: "{}",
                              contentType: "application/xml; charset=utf-8",
                              dataType: "xml",
                              success: ajaxCallSucceed,
                              failure: ajaxCallFailed
                              // success: function(msg) {
                              // alert( "Data Saved: " + msg.d );
                              // ServiceSucceeded(msg);
                                // $('#RSSContent').removeClass('loading');
                                // $('#RSSContent').html(msg.d);
                                // alert("got here");
                              // }
                              // failure: function(msg) {
                              // funcitonToCallWhenFailed(msg);
                              // }
                      });
                    });
          }); 
          function ajaxCallSucceed(response) {
            alert("in success message");
                              $('#divLoading').hide();
            var CEO = eval('(' + response.d + ')');
                              alert(response.d);
                              alert(CEO);
            pareseResult(CEO);
        }
          function ajaxCallFailed(error) {
                    alert("in failed message");
                    $('#divLoading').hide();
                    alert('error: ' + error);
                    $('#divResults').hide();
          }
          function pareseResult(CEO) {
                    var lists = '';
                    for (var i = 0; i < CEO.length; i++) {
                              if (lists == '') {
                                        lists = CEO.ProductName;
                              }
                              else {
                                        lists = lists + " <br />" + CEO.ProductName;
                              }
                    }
                    $('#divResults').html(lists);
                    $('#divResults').show();
          }

Thanks

Lewis

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 16:06:43 GMT

Hi Lewis,

Could you please post the XML code that is returned when you access the page directly?

Also, are you needing to send information to the server in order to get the AJAX back? The data parameter is used to send data to the server, so it's a little strange that you'd be sending over empty brackets.

http://api.jquery.com/jQuery.ajax/

Have you tried using the $.get jQuery method instead?

Thanks

Re: Web Service request in extension

Fri, 23 Sep 2011 16:17:16 GMT

Brian

This is the contents of my returned XML. In this instance there is only one set of info however in a live situation there could be a couple of hundred records.

I don't need to send any data to the server but from the reading i had done in the cintax i was using it just needed an empty data param.

I've not looked at the $getjquery method but i'll have a look

- <string xmlns="http://tempuri.org/">
          - <CEOStatus>
                    - <CEO>
                                <Number>WS6178</Number> 
                                <Lat>51.4934183333</Lat> 
                                <LatNS>N</LatNS> 
                                <Long>-0.1469100000</Long> 
                                <LongEW>W</LongEW> 
                                <LastGPSUpdate>2024-07-23T08:28:32+01:00</LastGPSUpdate> 
                                <IsActive>0</IsActive> 
                                <LastStatusUpdate>2011-07-13T09:52:59.1+01:00</LastStatusUpdate> 
                      </CEO>
            </CEOStatus>
  </string>

Thanks

Lewis

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 16:25:35 GMT

try replacing the ajax call with:

$.get("http://localhost/CEOStatusWebService/CEOStatus.asmx/GetStatusForAllCEOs", function(data) {

alert($(data).length);

});

See if you get an alert box with a number besides 0 in it.

Re: Web Service request in extension

Fri, 23 Sep 2011 16:37:17 GMT

Brian

Do you mean like this?

    Qva.LoadScript ("Extensions/Mouchel/GMapsRealTime/jquery-1.4.4.min.js", function () {
                    // For more information on doing XMLHR with jQuery, see these resources:
                    // http://net.tutsplus.com/tutorials/javascript-ajax/use-jquery-to-retrieve-data-from-an-xml-file/
                    // http://marcgrabanski.com/article/jquery-makes-parsing-xml-easy
                    $.get("http://localhost/CEOStatusWebService/CEOStatus.asmx/GetStatusForAllCEOs", function(data) {
                    alert("test");
                    alert($(data).length);
                    });
          });

If so then i'm not getting any alerts coming back

thanks

Lewis

Re: Web Service request in extension

Fri, 23 Sep 2011 16:40:50 GMT

Brian

If it helps this it the complete script...

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 16:41:22 GMT

Actually, now that I look closer, I'm not sure you're including jQuery properly. If you add an alert after the

$(document).ready(function()

line of code, does it pop up? Are you properly adding the extension to the document itself by using

Qva.AddExtension(...

Thanks

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 16:50:02 GMT

Ok, got the full script.

As far as I know, you need to use the server path when including script files. So the jquery load script

Qva.LoadScript ("Extensions/Mouchel/GMapsRealTime/jquery-1.4.4.min.js", function () {

should maybe be changed to

Qva.LoadScript ("/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/Mouchel/GMapsRealTime/jquery-1.4.4.min.js", function () {

I would change that and do the test I mentioned above in $(document).ready to test that jquery is being loaded at all.

Web Service request in extension

Fri, 23 Sep 2011 16:55:19 GMT

Brian

I've changed the path and added an alert after the(docuemtn).ready(function... which does fire. Ive added a few more alerts into the following succeed functions and they also fire so it looks liek its making its way through the code...

if i add alert($(data).length); into my succeed function i get an undefined error

Lewis

p.s thanks for you time looking at this

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 17:02:49 GMT

No problem.

Were the success functions firing before? I'm assuming that you're using the $.ajax method again if the succeed functions are firing? If so, you need to pass the successfully retrieved data into the function. Right now you have:

success: ajaxCallSucceed,

it should be

success: ajaxCallSucceed(data),

which will pass the data into your function. It looks like you call it response in that function, so the success alert would be

alert($(response).length);

Re: Web Service request in extension

Fri, 23 Sep 2011 17:21:13 GMT

right done that to pass across the data but unfortunately its returning an error saying date is undefined.

And yes the success functions were firing before which made me think i was nearly there with it...

again yes i put back the original function to make the URL call

This is what i know have

 Qva.LoadScript ("/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/Mouchel/GMapsRealTime/jquery-1.4.4.min.js", function () {
                    // For more information on doing XMLHR with jQuery, see these resources:
                    // http://net.tutsplus.com/tutorials/javascript-ajax/use-jquery-to-retrieve-data-from-an-xml-file/
                    // http://marcgrabanski.com/article/jquery-makes-parsing-xml-easy
                    // $.get("http://localhost/CEOStatusWebService/CEOStatus.asmx/GetStatusForAllCEOs", function(data) {
                    // alert("test");
                    // alert($(data).length);
                    // });
          // });
                    $(document).ready(function() {
                    alert("test");
                       $.ajax({
                              type: "POST",
                              url: "http://localhost/CEOStatusWebService/CEOStatus.asmx/GetStatusForAllCEOs",
                              data: "{}",
                              contentType: "application/xml; charset=utf-8",
                              dataType: "xml",
                              success: ajaxCallSucceed(data),
                              failure: ajaxCallFailed
                              // success: function(msg) {
                              // alert( "Data Saved: " + msg.d );
                              // ServiceSucceeded(msg);
                                // $('#RSSContent').removeClass('loading');
                                // $('#RSSContent').html(msg.d);
                                // alert("got here");
                              // }
                              // failure: function(msg) {
                              // funcitonToCallWhenFailed(msg);
                              // }
                      }) ;
                    });
          }); 
          function ajaxCallSucceed(response) {
            alert("in success message");
                              alert($(response).length);
                              $('#divLoading').hide();
            var CEO = eval('(' + response.d + ')');
                              alert(response.d);
                              alert(CEO);
            pareseResult(CEO);
        }
          function ajaxCallFailed(error) {
                    alert("in failed message");
                    $('#divLoading').hide();
                    alert('error: ' + error);
                    $('#divResults').hide();
          }
          function pareseResult(CEO) {
                    var lists = '';
                    for (var i = 0; i < CEO.length; i++) {
                              if (lists == '') {
                                        lists = CEO.ProductName;
                              }
                              else {
                                        lists = lists + " <br />" + CEO.ProductName;
                              }
                    }
                    $('#divResults').html(lists);
                    $('#divResults').show();
          }

Re: Web Service request in extension

Fri, 23 Sep 2011 17:25:35 GMT

one thing i guess i should try is that the URL will return data to a script language. I know if i invoke it through a browser i get data but would there be any restrictions through something like JavaScript and JQuery? Someone mentioned SoapUI at work so i will take a look at that as well

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 17:43:58 GMT

A sure way to determine if the XML is being loaded at all would be to put the following at the beginning of your success function:

alert(response);

Some sort of message saying [Object XMLdocument] or something like it should pop up.

Thanks.

Re: Web Service request in extension

Fri, 23 Sep 2011 19:42:25 GMT

Seem to be getting somewhere now - hopefully. I've removed the passing of the data to the succeed function yet have kept in the alert(response) which now returns [Object] from within the succeed function. The alert for the response length now returns 1, although i've just amended the data in the DBase so that 2 records are returned within the xml and its still giving me a count of 1.

I'm now getting the code to succefully work through to the Parese results function although i'm still not 100% if it actually has the XML data within the responjse object

Re: Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 19:59:04 GMT

Returning a value of only 1 actually makes sense because at that level of the XML, there is only one object.

Try this and you might be good to go if you use this method to retrieve the data. If it works, I can explain it better.

$.each($(response).find("CEO"), function (key) {

alert($(this).find("Number").text());

});

That should alert the <Number> value for each CEO in the XML.

Re: Web Service request in extension

Fri, 23 Sep 2011 20:10:47 GMT

I've added that script into the parseResult function as below and the code will alert me with the 'in parse true' comment but i don't get the alert with the number returned. not that i want to appear thick but have i put the code in where you thought it should go?

 function pareseResult(response) {
                    var lists = '';
                    alert("in parse"+$(response).length);
                    for (var i = 0; i < $(response).length; i++) {
                                                  if (lists == '') {
                                                  alert("in parse true");
                                        $.each($(response).find("CEO"), function (key) {
                                        alert($(this).find("Number").text());
                                        }); 
                                        //lists = $(response).ProductName;
                              }
                              else {
                                        alert("in parse false");
                                        lists = lists + " <br />" + $(response).ProductName;
                              }
                    }
                    $('#divResults').html(lists);
                    $('#divResults').show();
                    alert("in parse exut");
          }

Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 20:14:08 GMT

Oh i see. As a test replace that entire for loop with the $.each code I mentioned (which is jquery's version of a for loop).

BTW, I'm assuming the XML still looks similar to what you posted. I'm not sure where .ProductName would be coming from.

Re: Web Service request in extension

Fri, 23 Sep 2011 20:58:16 GMT

not seeing the alert with the 'Number' value coming out. This is the code now. The ProductName came from the example code that i have been using so once i had things working i would have replaced it.

If i can get this working i'll defenitely owe you a beer! mind you the flights out to where ever your based might cost a bit!

 function pareseResult(response) {
                    var lists = '';
                    alert("in parse: "+$(response).length);
                     // for (var i = 0; i < $(response).length; i++) {
                                                  // if (lists == '') {
                                                  // alert("in parse true");
                              $.each($(response).find("CEO"), function (key) {
                              alert($(this).find("Number").text());
                              }); 
                                        //lists = $(response).ProductName;
                              // }
                              // else {
                                        // alert("in parse false");
                                        // lists = lists + " <br />" + $(response).ProductName;
                              // }
                    //}
                    $('#divResults').html(lists);
                    $('#divResults').show();
                    alert("in parse exit");
          }

Re: Web Service request in extension

Brian_Munz — Fri, 23 Sep 2011 21:30:41 GMT

Ha that could be expensive.

Hmm I feel we might be getting close.

Before the $.each loop try alerting:

alert($(response).find("CEO").length);

Also try

alert($(response).find("string").length);

And is the XML at all different from before?

Re: Web Service request in extension

Fri, 23 Sep 2011 22:08:52 GMT

alert($(response).find("CEO").length); This returned '0'

alert($(response).find("string").length); This returned '1'

The XML will be the same as i've not altered anything to do with the web service