I am using Access and Sharepoint 2010. I am writing a python script, which periodically reads tables, checks some conditions, and eventually writes e-mail notifications. I do not have permission to access the Sharepoint server directly. Also :
Directly interacting with a SharePoint content database will cause your SharePoint installation to lose Microsoft support.
The simplest solution for now would be to download the database through access, but first, I don't know how to do this programatically. Second, when extending my application I might need to update Database as well.
So far I got this:
from suds import WebFault from suds.client import * from suds.transport.https import WindowsHttpAuthenticated # for https authentification USER = r'Domain\02345434' #the number is the user id PWD = 'secret' #My guess is that you need webs.asmx for accessing WebNodes instead of ListNodes URL = 'https://mysite.sharepointserver.com/_vti_bin/webs.asmx?WSML' ntml = WindowsHttpAuthenticated(username=USER, password=PWD) client = Client(URL, transport=ntml, timeout=200, cache=None) #try to get some info #http://msdn.microsoft.com/en-us/library/webs.webs.getwebcollection%28v=office.12%29.aspx print client.service.GetWebCollection() #fails with SaxParseException: <unknown>:1:0:syntax error