Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Gmail.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Gmail, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Gmail Stored Procedures
| Name | Description |
| AddMailbox | Adds a mailbox to the authorized Gmail account. |
| DeleteMailbox | Deletes the specified mailbox for the authorized Gmail account. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL used for authentication with Gmail. |
| GetPart | Gets the message part specified by LocalFile or PartId from the message specified by Id on the Gmail server. |
| MoveEmails | Moves the messages specified by Ids to the mailbox specified by Mailbox . |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Gmail. |
| RenameMailbox | Renames the specified mailbox for the authorized Gmail account. |
| SendMailMessage | Sends the message specified to the specified recipient. |
| SetFlags | Adds or Replaces existing flags with the specified flags. |
| SetLabels | Adds or replaces existing Labels with the specified Labels. |