Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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.
CreateShortcut	Creates a shortcut in Google Drive that points to an existing file or folder, placing the shortcut in the specified destination folder.
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.
GetDocumentContent	Extract the text from a document.
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.
MoveToTrash	Moves a file or resource to the trash.
RefreshOAuthAccessToken	Obtains the OAuth access token to be used for authentication with various Google services.
RestoreFromTrash	Restores a file or resource from the trash.
RevokeToken	Invalidates the user's current access token, terminating an application's access to Google Drive.
SetDriveVisibility	If a shared drive is set to hidden, it does not appear in the Google Drive interface by default, although it's still accessible. Google Drive manages this setting individually for each user, allowing each member of a shared drive to decide whether to keep the shared drive hidden or visible.
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.