Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE operations with Google Drive.

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

CData MCP Server for Google Drive Stored Procedures


Name	Description
CopyResource	Duplicates a file or folder in Google Drive and places the copy in the specified destination path.
CreateFolder	Creates a new directory within a user's Drive with optional parent folder assignment and metadata tagging.
DeleteResource	Removes a file or folder from Google Drive and sends it to the trash or deletes it permanently if already in trash.
DownloadFile	Fetches and downloads a file from Drive, returning it in the requested format if applicable (for example, PDF, DOCX).
EmptyTrash	Permanently deletes all items currently in the user's Google Drive trash, freeing up storage space.
GetAuthenticatedUserInfo	Returns profile details about the current authenticated user, such as email, name, and account status.
GetOAuthAccessToken	Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Google services.
GetOAuthAuthorizationURL	Obtains the OAuth authorization URL used for authentication with various Google services.
MoveResource	Reassigns a file or folder to a new parent directory by updating its list of parent folder IDs.
RefreshOAuthAccessToken	Obtains the OAuth access token to be used for authentication with various Google services.
RevokeToken	Invalidates the user's current access token, terminating an application's access to Google Drive.
StopWatchingResources	Cancels existing notification channels that monitor changes to Drive files or user activity.
SubscribeToFileChanges	Creates a webhook to receive real-time notifications when a specific file is modified in Drive.
SubscribeToUserChanges	Creates a notification channel to track changes across all Drive resources owned by the authenticated user.
UpdateResource	Modifies metadata, content, or sharing settings for an existing file or folder in Google Drive.
UploadFile	Adds a new file to Drive from a local or remote source, with support for specifying Multipurpose Internet Mail Extensions (MIME) type and folder location.