Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft SharePoint.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft SharePoint, along with an indication of whether the procedure succeeded or failed.

CData ODBC Driver for Microsoft SharePoint Stored Procedures


Name	Description
AddAttachment	Adds an attachment to a SharePoint list item. Useful for linking supplementary files to SharePoint records.
AddList	Creates a new SharePoint list with specified properties. Helps automate the setup of structured data storage.
AddListColumn	Adds a new column to a SharePoint list. Useful for dynamically modifying list structures.
AddUserToGroup	Adds a user to a specified SharePoint group. Helps in managing user access and permissions.
AddUserToRole	Assigns a user to a specified role in SharePoint. Useful for controlling access levels within the site.
CheckInDocument	Checks in a document, unlocking it for other users to modify. Ensures document updates are properly tracked.
CheckOutDocument	Checks out a document from a SharePoint library, locking it for editing. Prevents conflicts when multiple users need to work on the same file.
CopyDocument	Copies a document to a specified destination within SharePoint. Helps in content duplication and archiving.
CreateFolder	Creates a new folder within a SharePoint document library. Useful for keeping files organized in logical structures.
CreateSchema	Generates a schema definition file for a specified SharePoint table or view, aiding in documentation.
DeleteAttachment	Removes an attachment from a SharePoint list item. Helps manage file storage and remove outdated or unnecessary attachments.
DeleteDocument	Deletes a document from a SharePoint document library. Useful for content lifecycle management and ensuring obsolete documents are removed.
DeleteList	Permanently removes a SharePoint list from a site. Helps in decluttering SharePoint environments by removing deprecated lists.
DeleteListColumn	Removes a column from a SharePoint list. Useful for refining list structures and eliminating redundant fields.
DeleteUserFromGroup	Removes a user from a specified SharePoint group. Useful for revoking access when user roles change.
DeleteUserFromRole	Removes a user from a specified SharePoint role. Helps maintain security by adjusting permissions as needed.
DiscardCheckOutDocument	Reverts a checked-out document to its last saved state, canceling any unsaved changes. Useful for preventing unintended modifications.
DownloadAttachment	Downloads an attachment from a SharePoint list item. Allows users to access and retrieve important files.
DownloadDocument	Downloads a document from a SharePoint document library. Helps users retrieve SharePoint-stored files for offline use or processing.
MoveAttachmentOrDocument	Moves an attachment or document from one folder to another within SharePoint. Useful for reorganizing content and maintaining a structured document library.
RenameAttachmentOrDocument	Renames an attachment or document stored in a SharePoint list or document library. Useful for standardizing naming conventions without affecting file content.
UpdateGroup	Update a group in your SharePoint site collection.
UpdateList	Modifies properties or settings of a SharePoint list. Helps in dynamically adjusting list configurations.
UpdateListColumn	Updates the properties of an existing column in a SharePoint list. Useful for modifying column attributes without recreating the structure.
UpdateRole	Update a role in your SharePoint site collection.
UploadDocument	Uploads a document to a SharePoint document library. Essential for adding new files for collaboration and document management.