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.
Syntax:
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%2DDB5B%2D434B%2DB2FC%2DB9AB9EE18A91}&View={B959F555%2D798B%2D4F47%2D9FBB%2D81513B85F906}&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%2DDB5B%2D434B%2DB2FC%2DB9AB9EE18A91}&View={B959F555%2D798B%2D4F47%2D9FBB%2D81513B85F906}&XMLDATA=true”);
myRequest.Credentials =
System.Net.CredentialCache.DefaultCredentials;
HttpWebResponse response = (HttpWebResponse)myRequest.GetResponse();
XmlDocument doc = new XmlDocument();
doc.Load(response.GetResponseStream());
Leave a Reply