ChatMessages
Returns messages sent and received in Microsoft Teams chat threads.
Table Specific Information
Select
The provider uses the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:
- ChatId supports '=' operator.
The rest of the filter is executed client side within the provider.
The following is an example query:
SELECT * FROM ChatMessages WHERE ChatId = '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_e4ea490e-b30c-4b1e-92b0-337117920315@unq.gbl.spaces'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the chat message in Microsoft Teams. |
| ChatId | String | Identifier of the chat thread containing the message. |
| BodyContent | String | Plaintext or rich text content of the chat message body. |
| BodyContentType | String | Specifies the format of the message body content, such as text or HTML. |
| MessageType | String | Type of chat message, such as standard or system notification. |
| CreatedDateTime | Datetime | Timestamp indicating when the chat message was created. |
| LastEditedDateTime | Datetime | Timestamp indicating when the chat message was last edited. |
| LastModifiedDateTime | Datetime | Timestamp indicating when the chat message was last updated. |
| DeletedDateTime | Datetime | Timestamp indicating when the chat message was deleted, or null if it has not been deleted. |
| Reactions | String | List of reactions applied to the chat message, such as like or heart. |
| Mentions | String | List of entities mentioned in the chat message. Supported entities include user, bot, team, and channel. |
| Attachments | String | References to objects attached to the message, such as files, tabs, or meetings. |
| Importance | String | Priority level of the chat message, such as normal, high, or urgent. |
| FromUserDisplayName | String | Display name of the user who sent the message. |
| FromUserId | String | Unique identifier of the user who sent the message. |
| FromUserIdentityType | String | Specifies the identity type of the user who sent the message. |
| ChannelIdentity | String | Identifier of the Microsoft Teams channel associated with the message, if applicable. |
| Locale | String | Locale setting of the message as defined by the client application, typically en-us. |
| ReplyToId | String | Identifier of the parent chat message if this message is part of a reply thread. |
| Subject | String | Subject line of the chat message, in plaintext. |
| Summary | String | Summary text of the chat message for use in notifications, previews, or fallback views. Applies only to channel chat messages. |
| PolicyViolation | String | Details about any policy violations associated with the chat message. |
| Etag | String | Version identifier for the chat message used for concurrency control. |
| FromApplication | String | Name of the application that sent the message, if applicable. |
| FromDevice | String | Name of the device used to send the message, if available. |
| WebUrl | String | Direct link to view the message in Microsoft Teams. |
| EventDetail | String | Details about the event associated with the chat message, if applicable. |