Programming Basahin ang List & Tingnan ang Nilalaman sa SharePoint

Nakakuha ako ng isang gawain upang gumana sa pagbuo ng mga application na bintana kung saan ay kunin ang data List View mula sharepoint at iproseso ang data sa panalo bumubuo ng app.

Noong nakaraan ay ginamit i upang makuha ang data gamit ang Lists.asmx,views.asmx.

Ngayon ay dumating i malaman mayroong iba pang mga paraan upang kunin ang data mula sa View ng Listahan.

Palaugnayan:
https://myserver.com/_vti_bin/owssvr.dll?Cmd = Display&Listahan ={list Id}&View={View Id}&XMLDATA=true

Example URL:

https://myserver.com/_vti_bin/owssvr.dll?Cmd = Display&Listahan ={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&Listahan ={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 = bagong XmlDocument();
doc.Load(response.GetResponseStream());