Microsoft doesn't allow reading from SharePoint ??

Jan 28, 2014 at 5:43 PM
Hi All...

One of the SharePoint admins in my org told me that I cannot use the SharePoint List Adapter to even read/query data from our SharePoint site because it violates the EULA and support policy with Microsoft.

Check this out: http://support.microsoft.com/kb/841057/en-us

And specifically, the section "Read operations addendum". It seems that Msft is saying that we cannot even query the database because it would cause problems.

And this Stackoverflow link points to the same link:
http://stackoverflow.com/questions/1665755/how-do-i-query-the-sharepoint-database

I thought that the SharePoint List Adapter used some of the exposed web services or sharepoint object model....and would be all right to use.

Does anyone have any thoughts on this...or am I out of luck?

thanks
will
Coordinator
Feb 10, 2014 at 6:18 PM
The sharepoint adapter does not query the SharePoint DB. It uses the webservices, which in your stackoverflow article says the following:

"Access SharePoint data the right way
1.Use SharePoint Object Model (Code can only be run on SharePoint server)
2.Use SharePoint WebServices (Run code from anywhere, from any application)
3.SharePoint 2013 now features REST API.
"

So I can't speak to support policies or EULA issues with your org, but present the information to your sharepoint admins stating that this tool uses the public webservice API only (which is what Excel and other tools use) and find out if that is something your sharepoint admins can work with.