Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft Teams.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Teams, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Microsoft Teams Stored Procedures
| Name | Description |
| ArchiveTeam | Archives a specified Microsoft Team, preserving content in read-only mode while preventing further edits or changes. |
| CreateChat | Initiates a one-on-one or group chat in Teams by specifying participants and chat metadata. |
| DeleteChat | Permanently removes a Teams chat thread, including all associated messages and metadata. |
| DeleteChatMessage | Deletes a specific message from a Teams chat, identified by message ID and chat context. |
| DeleteMessage | Removes a message from a Teams channel conversation, typically used for moderation or compliance. |
| FetchAdditionalUserFields | Pulls extended profile data (T1, T2, T3 fields) for a specific Teams user for reporting or personalization. |
| GetAdminConsentURL | Creates a secure admin authorization link for granting delegated or application permissions to Teams-based apps. |
| GetAttachmentContentUrl | Retrieves a direct-access URL for a file attachment from a Teams chat message for downloading or embedding. |
| GetOAuthAccessToken | Gets an authentication token from MSTeams. |
| 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. |
| GetUserActivityCount | Returns statistics on user engagement in Teams, broken down by activities like chat messages, meeting participation, and calls. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various MSTeams services. |
| SendChatMessage | Sends a new message to a specified chat thread in Microsoft Teams, supporting text and rich content. |
| SendMessage | Posts a message to a Teams channel, optionally including formatting, mentions, and embedded content. |
| ShareSchedule | Publishes pending changes in a Teams schedule, such as shifts or time-off entries, making them visible to team members. |
| UnArchiveTeam | Reactivates an archived Microsoft Team, restoring full editing capabilities and collaboration access. |
| UpdateChat | Modifies properties of a Teams chat, such as adding participants or changing the topic name. |
| UpdateChatMessage | Updates the content of an existing Teams chat message, allowing corrections or content changes. |
| UpdateMessage | Revises an existing message in a Teams channel to reflect new information or correct errors. |