Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Microsoft Office 365.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Office 365, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Microsoft Office 365 Stored Procedures
| Name | Description |
| AddAttachments | Adds one or more attachments to an existing email message based on message ID. |
| AssignLicense | Assigns or removes Microsoft 365 subscriptions for a user and enables or disables specific service plans within those subscriptions. |
| CancelEvent | Cancels an existing calendar event and updates the event status across invitees. |
| CreateFolder | Creates a new folder or updates the contents of an existing file in OneDrive or SharePoint. |
| CreateSchema | Generates and saves a schema definition file for a specified Office365 table or view. |
| DeleteAttachment | Removes an attachment from an email message based on the message and attachment IDs. |
| DownloadAttachments | Downloads one or more attachments from a specified email message. |
| DownloadEmail | Downloads the full contents of an email message, including metadata and body content. |
| DownloadFile | Downloads a specified file from OneDrive or SharePoint. |
| FetchAdditionalUserFields | Retrieves additional Tier 1, Tier 2, and Tier 3 user fields for enhanced profile data. |
| ForwardEvent | Forwards a calendar event invitation to one or more recipients. |
| ForwardMail | Forwards an existing email message to specified recipients. |
| GetAdminConsentURL | Returns a URL to initiate the admin consent process for granting application access using custom OAuth credentials. |
| GetOAuthAccessToken | Gets an authentication token from Office365. |
| 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. |
| MoveMail | Moves an email message to a specified folder within a user's mailbox. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various Office 365 services. |
| SendMail | Sends an email message from the authenticated user's mailbox with optional attachments. |
| UploadFile | Uploads a new file or replaces the content of an existing file in OneDrive or SharePoint. |