I got a task to work on developing the windows application which will fetch the List View data from sharepoint and process the data in win forms app.
Previously i used to fetch the data using Lists.asmx,views.asmx.
Now i came to know there is other way to fetch the data from List View.
Sintaxă:
https://myserver.com/_vti_bin/owssvr.dll?Cmd=Display&List={list Id}&View={View Id}&XMLDATA=true
Example URL:
https://myserver.com/_vti_bin/owssvr.dll?Cmd=Display&List={EA1BD05B-DB5B-434B-B2FC-B9AB9EE18A91}&View={B959F555-798B-4F47-9FBB-81513B85F906}&XMLDATA=true
Now it will give the xml data as response.
write the response to xmldoc and process the data.
HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(“https://myserver.com/_vti_bin/owssvr.dll?Cmd=Display&List={EA1BD05B-DB5B-434B-B2FC-B9AB9EE18A91}&View={B959F555-798B-4F47-9FBB-81513B85F906}&XMLDATA=true”);
myRequest.Credentials =
System.Net.CredentialCache.DefaultCredentials;
HttpWebResponse response = (HttpWebResponse)myRequest.GetResponse();
XmlDocument doc = XmlDocument noi();
doc.Load(response.GetResponseStream());
Plecare un Reply