Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT operations with Microsoft OneDrive.

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

CData MCP Server for Microsoft OneDrive Stored Procedures


Name	Description
CopyResource	Copies a specified file or folder from one location in OneDrive to another, preserving content and structure.
CreateFolder	Creates a new folder at a specified path within OneDrive to organize content.
CreateSubscription	Registers a webhook subscription to receive notifications for changes to OneDrive content (for example, file updates).
DeleteResource	Permanently deletes a specified file or folder from OneDrive, removing it from all views and history.
DeleteSubscription	Removes an existing webhook subscription to stop receiving change notifications from OneDrive.
DownloadFile	Retrieves and downloads a specified file from OneDrive storage to the local or application context.
FetchAdditionalUserFields	Retrieves tiered metadata fields (T1, T2, T3) for a specific user, typically for profiling or auditing.
GetAdminConsentURL	Generates a URL that an admin must visit to grant tenant-wide OAuth permissions to your app; used when setting up enterprise integrations.
GetOAuthAccessToken	Gets an authentication token from OneDrive.
GetOAuthAuthorizationURL	Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the auth token from this URL.
ModifySubscription	Creates or updates a webhook subscription to listen for changes in OneDrive files, folders, or other resources.
MoveResource	Relocates a file or folder within the OneDrive directory structure, maintaining metadata and permissions.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various Office 365 services.
RenameResource	Changes the name of a specified file or folder in OneDrive without affecting its contents or location.
UploadFile	Uploads a new file or overwrites an existing one in OneDrive, supporting binary content updates.