SharePoint Web Service Example – Grabbing Wiki Content
I presented a session at Tech Ready (Microsoft internal conference) yesterday. One of the samples I showed was how information can be consumed from a SharePoint web service and repurposed. The specific example was taking the Wiki content we host internally on our FAQ site (it's a great example of using Wikis to build a Frequently Asked Questions knowledgebase) and creating an html file from it.
The code sample is straightforward. I developed it using Visual C# Express Edition on my Vista laptop. The web reference I added was https://faq/sites/sharepoint/_vti_bin/lists.asmx.
In this particular sample, I retrieve content from a specific view. In that view, I've actually added the Wiki Content field which is why the content is returned. Instead of getting content from a specific view, I could have specified a query and the fields I wanted returned as parameters to the web service.
Here's the sample:
… SharePoint_FAQ_Lists.Lists ls = new SharePoint_FAQ_Lists.Lists(); ls.Credentials = System.Net.CredentialCache.DefaultCredentials; string url = "https://faq/sites/sharepoint"; ls.Url = url + @"/_vti_bin/lists.asmx";
//get all wiki pages from the "Wiki Pages" library from a particular view. The second parameter is the GUID of the view XmlNode wListItems = ls.GetListItems("Wiki Pages", "{3F1DB907-7D89-4139-99EC-443D1F9BECC7}", null, null, "", null, "");
//assemble the html content that will eventually string htmlBody = "<html><body>";
//iterate through the returned XML and parse out the relevant information foreach (XmlNode outerNode in wListItems.ChildNodes) { if (outerNode.NodeType.Equals(System.Xml.XmlNodeType.Element)) { foreach (XmlNode node in outerNode.ChildNodes) { if (node.NodeType.Equals(System.Xml.XmlNodeType.Element)) { XmlNode nameNode = node.Attributes.GetNamedItem("ows_LinkFilename"); XmlNode wikiNode = node.Attributes.GetNamedItem("ows_WikiField");
String wikiName = nameNode.InnerText; String wikiBody = wikiNode.InnerText;
htmlBody += "<a href=\"" + "https://faq/sites/sharepoint/wiki pages/"+ wikiName + "\">" + wikiName + "</a><br>"; htmlBody += wikiBody; } } } }
htmlBody += "</body></html>";
string fileName = @"c:\temp.html" GenerateFile(htmlBody, fileName); … |