GetListItems - External Lists?

Mar 12, 2012 at 4:43 AM

I'm trying to pull items from an External Lists.  I'm getting a 'List not found' error.  Here's my code...

  $().SPServices({
    operation: "GetListItems",
    listName: "QBCustomers",
    CAMLViewFields: "<ViewFields><FieldRef Name='FullName' /></ViewFields>",
    CAMLQuery: "<Query><OrderBy><FieldRef Name='FullName' /></OrderBy></Query>",
    async: false,
    completefunc: function (xData, Status) {
alert(xData.responseXML.xml);
alert(xData.responseText);
alert($(xData.responseXML).find("[nodeName='rs:data']").attr("ItemCount"));

      $(xData.responseXML).find("[nodeName='z:row']").each(function() {
        externalParties.push($(this).attr("FullName"));
      });
    }
  });

Mar 12, 2012 at 1:46 PM
Fubak,
Look into the webURL parameter to SPServices operations. As with any browser application, its value needs to respect the 'same domain' rules.

_____
Paul

Sent from mobile device.

Aug 28, 2012 at 9:54 PM

Hi Paul,

R u able to resolve this issue? If yes, can you please post the resolution---

Thanks

Aug 28, 2012 at 10:01 PM
kireetij,
I was not having the issue directly, and only posted a possible solution... I did not see a response from Fubak...
But the concept if simple: if you are trying to pull information from another list in a different Sharepoint site, then you should be able to use the webURL input parameter to point at that other site... (again, as long as that other "site" is within the same url domain)
Try it and let us all know if it works.
_________
Paul T