ChatMessages
Get Chat Messages.
Table Specific Information
Select
The connector 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 connector.
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 | The Chat Messages Id. |
| ChatId | String | The Chat Id. |
| BodyContent | String | Content of the Body. |
| BodyContentType | String | Type of BodyContent. |
| MessageType | String | Type of chat message. |
| CreatedDateTime | Datetime | Timestamp of when the chat message was created. |
| LastEditedDateTime | Datetime | The timestamp on which this message was last edited. |
| LastModifiedDateTime | Datetime | The timestamp on which this message was last updated. |
| DeletedDateTime | Datetime | Timestamp at which the chat message was deleted, or null if not deleted. |
| Reactions | String | Reactions for the chat message (for example, Like). |
| Mentions | String | List of entities mentioned in the chat message. Supported entities are: user, bot, team, and channel. |
| Attachments | String | References to attached objects like files, tabs, meetings etc. |
| Importance | String | Importance of the messages. |
| FromUserDisplayName | String | From User Display Name. |
| FromUserId | String | From User Id. |
| FromUserIdentityType | String | From User UserIdentityType. |
| ChannelIdentity | String | Identity of the Channel. |
| Locale | String | Locale of the chat message set by the client. Always set to en-us. |
| ReplyToId | String | ID of the parent chat message or root chat message of the thread. |
| Subject | String | The subject of the chat message, in plaintext. |
| Summary | String | Summary text of the chat message that could be used for push notifications and summary views or fall back views. Only applies to channel chat messages, not chat messages in a chat. |
| PolicyViolation | String | Chat Message Policy Violation. |
| Etag | String | Version number of the chat message. |
| FromApplication | String | The From Application. |
| FromDevice | String | The From Device. |
| WebUrl | String | Link to the message in Microsoft Teams. |
| EventDetail | String | The Event Message Detail. |