GET THINGS DONE.

SharePoint



HTTP Rapid Development

Use HTTP/REST to access SharePoint lists (read/write) and users/groups easily from web applications and Mobile devices. Allows you to specify custom queries (CAML automatically created).

GET ENZO_URI/bsc/sharepoint/getlistitemsex HTTP/1.1
authToken: YOUR_AUTH_TOKEN
_config: myconfigname
viewname: mylist
where: State='FL'

No SDK or client libraries required.


Works with: Enzo UnifiedEnzo Online


Native SQL

Access SharePoint lists (read/write) and users/groups directly from within SQL Server databases and SQL Server Jobs; query SharePoint list fields; cache lists in Enzo; automatic paging for large lists and more.


SELECT ID, Title, Amount,Age FROM sharepoint.list@Posts WHERE Age >= 40

EXEC SharePoint.GetDocumentAt '/documents/personal/2016/scienceproject.docx'

SELECT * FROM sharepoint.groupusers where name = 'owners'

Integrate with SQL Server directly.


Works with: Enzo Unified