Stored Procedures
Stored procedures are available to complement the data available from the SOAP Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
CData JDBC Driver for SharePoint Stored Procedures
| Name | Description |
| AddAttachment | Add an Attachment to a SharePoint List item. |
| AddList | Creates a list on a SharePoint site. |
| AddListColumn | Adds a new column to the specified list. |
| AddUserToGroup | Add the user to specified group. |
| AddUserToRole | Add the user to specified role. |
| CheckInDocument | Checks in a document to SharePoint and releases the lock on the document. |
| CheckOutDocument | Checks out a document from SharePoint. |
| CopyDocument | Copies a document from the SharePoint library. |
| CreateFolder | Adds a folder to a document library on a SharePoint site. |
| CreateSchema | Creates the schema file for the specified SharePoint list. The schema file may be customized manually to exclude unwanted columns or include additional information about columns. |
| DeleteAttachment | Delete an attachment from a SharePoint list item. |
| DeleteDocument | Delete a document on the SharePoint library. |
| DeleteList | Permanently deletes a list from a SharePoint site. |
| DeleteListColumn | Deletes a column from the specified list. |
| DeleteUserFromGroup | Delete the user from specified group. |
| DeleteUserFromRole | Delete the user from specified role. |
| DiscardCheckOutDocument | Discards a check out on a document in SharePoint. This does not check a new file into SharePoint. It only releases the lock on the document. |
| DownloadAttachment | Download a document from the SharePoint list. |
| DownloadDocument | Download a document from the SharePoint library. |
| UpdateList | Updates a list on a SharePoint site. |
| UpdateListColumn | Updates a column to the specified list. |
| UploadDocument | Upload a document to the SharePoint library. |