haufe.sharepoint is a Python module that allows to interact Python-based application with Sharepoint lists through the Sharepoint SOAP API.
Usage:
In order to connect to Sharepoint you need the following parameters
* the Lists WSDL URL
* the ID/Name of the related Sharepoint list you want to interact with
* a valid Sharepoint username and password (having the related rights)
API usage
Example usage:
from connector import Connector
url = "http://sharepoint/bereiche/onlineschulungen/_vti_bin/Lists.asmx?wsdl"
username = 'YourDomain\\account'
password = 'secret'
list_id = '60e3f442-6faa-4b49-814d-2ce2ec88b8d5'
service = connector.Connector(url, username, password, list_id)
# field descriptions
fields = service.model
# all items
all_items = service.getItems()
# delete items with primary key value '54' and '55'
result = service.deleteItems('54', '55')
print result
print result.result
print result.ok
# update an item (existing ID)
data = dict(ID='77', Title=u'Ruebennase', FirstName=u'Heinz')
result = service.updateItems(data)
print result
print result.result
print result.ok
# update an item (non-existing ID)
data = dict(ID='77000', Title=u'Becker')
result = service.updateItems(data)
print result
print result.result
print result.ok
# add an item
data = dict(Title=u'Ruebennase', FirstName=u'Heinz')
result = service.addItems(data)
print result
print result.result
print result.ok
print 'assigned ID:', result.result[0]['row']._ows_ID
Command line usage
haufe.sharepoint comes with a small sharepoint-inspector commandline utility:
sharepoint-inspector --url < URL > --list < LIST-ID-OR-NAME > --username < USERNAME > --password < PASSWORD > --cmd < CMD >
where < CMD > is either fields or items
Product's homepage
Here are some key features of "haufe.sharepoint":
· retrieve Sharepoint list definitions
· retrieve all list items
· add list items
· delete list items
· update list items
· authentication over NTLM
Requirements:
· Python
What's New in This Release: [ read full changelog ]
· fixed some documentation glitches
· added logging at connection time