ChatMessages
Returns messages sent and received in Microsoft Teams chat threads.
Table Specific Information
Select
The add-in 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 add-in.
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. |