ChannelMessages
Get Channel messages
Table Specific Information
Select
The adapter uses the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:
- TeamId supports '=' operator.
- ChannelId supports '=' operator.
The rest of the filter is executed client-side within the adapter.
The following is an example query:
select * from ChannelMessages where TeamId='4729c5e5-f923-4435-8a41-44423d42ea79' and ChannelId='19:de0aadf89578408aaecdb6fdf47ee83d@thread.skype'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Channel Messsages Id. |
| BodyContent | String | Content of the Body. |
| BodyContentType | String | Type of BodyContent. |
| ChannelId | String | The Channel Id. |
| TeamId | String | The Team Id. |
| Mentions | String | List of entities mentioned in the channel message. Supported entities are: user, bot, team, and channel. |
| Reactions | String | Reactions for the channel messages (for example, Like). |
| Attachments | String | References to attached objects like files, tabs, meetings etc. |
| Importance | String | Importance of the messages. |
| CreatedDateTime | Datetime | Timestamp of when the channel 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 channel messages was deleted, or null if not deleted. |
| MessageType | String | Type of Channel message. |
| ChatId | String | The Chat Id. |
| Etag | String | Version number of the channel message. |
| FromUserDisplayName | String | From User Display Name. |
| FromUserId | String | From User Id. |
| FromUserUserIdentityType | String | From User UserIdentityType. |
| FromApplication | String | The From Application. |
| FromDevice | String | The From Device. |
| Locale | String | Locale of the channel message set by the client. Always set to en-us. |
| PolicyViolation | String | Channel Message Policy Violation. |
| ReplyToId | String | ID of the parent chat message or root chat message of the thread. |
| Subject | String | The subject of the channel message, in plaintext. |
| Summary | String | Summary text of the channel 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. |
| WebUrl | String | Link to the message in Microsoft Teams. |
| EventDetail | String | The Event Message Detail. |