I am trying to access sharepoint list using the GetListItems webservices using the following code in jscript. But I am not able to retrieve any list data from sharepoint, it always returns blank.
I have been struggling with this for a while and I would highly appreciate if anybody can help me understand the problem with this code.
Thanks in advance.
Afzal
**********************************************************************
function getSPListItems()
var xmlhttp=false;
var rowLimit=300;
var request;
try
{
xmlhttp=new ActiveXObject("MSXML2.XMLHTTP");
request = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
request += "<soap:Envelope ";
request += "soap:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" ";
request += "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ";
request += "xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" ";
request += "xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">";
request += "<soap:Body>";
request += "<GetListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\" />";
request += "<listName>";
request += "{D264C43B-1DD0-472E-875C-4E3A1D36B4AC}";
request += "</listName>";
request += "<viewName>";
request += "{0A45631E-B741-4615-93FA-91D3C0AE10EA}";
request += "</viewName>";
request += "<query>";
request += "<Query>";
request += "<Where>";
request += "<Eq>";
request += "<FieldRef Name=\"RefList\" />";
request += "<Value Type=\"Number\">1</Value>";
request += "</Eq>";
request += "</Where>";
request += "</Query>";
request += "</query>";
request += "<viewFields>";
request += "<ViewFields>";
request += "<FieldRef Name=\"Title\" />";
request += "<FieldRef Name=\"Ref.TypeID\" />";
request += "</ViewFields>";
request += "</viewFields>";
request += "<rowLimit>";
request += rowLimit;
request += "</rowLimit>";
request += "<queryOptions>";
request += "<QueryOptions>";
request += "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>";
request += "<DateInUtc>TRUE</DateInUtc>";
request += "</QueryOptions>";
request += "</queryOptions>";
request += "</GetListItems>";
request += "</soap:Body>";
request += "</soap:Envelope>";
XDocument.UI.Alert(request);
xmlhttp.open("POST", "https://<MySharepointserver>/_vti_bin/lists.asmx?op=GetListItems", true);
xmlhttp.setRequestHeader("Content-Type","text/xml; charset=utf-8");
xmlhttp.setRequestHeader("SOAPAction","http://schemas.microsoft.com/sharepoint/soap/GetListItems");
xmlhttp.setRequestHeader("Content-Length", request.length);
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4)
{
XDocument.UI.Alert(xmlhttp.responseText);
}
}
xmlhttp.send(request);
}
catch(e)
{
XDocument.UI.Alert(e.description);
}
}
**********************************************************************