I had a requirement to get all the social comments from a news board web part for a specific page. Though this can be achieved using “Server Side Object Model,” it is restricted for some of the companies to run their “SSOM” code on production environment. Thus, we came up with an idea of creating PowerShell script using CSOM to retrieve social comments using “Social Data Web Service”.
Here you will be seeing how to get all the social comments in SharePoint 2013 using the PowerShell + CSOM for a specific page using “Social Data WebService” (SocialDataService.asmx)
The below code retrieves all the comments for the specified page URL and exports the resulting data to Excel.
Code Usage


Scenario 2
To iterate all the page URL’s from excel and to retrieve all the social comments from social data web service based on page URL.

All the Page URL’s are stored under “PageUrl” column in excel sheet.

SharePoint 2013 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.