Chats
Get Chats.
Table Specific Information
Select
The connector use the Microsoft Teams API to process WHERE clause conditions built with the following column and operator:
- Id supports '=' operator.
The rest of the filter is executed client side within the connector.
The following is an example query:
SELECT * FROM Chats WHERE Id = '19:32caef50-395c-425a-a994-e3fa4569b23b_92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe@unq.gbl.spaces'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Chat Id. |
| ChatType | String | The type of Chat. |
| UserId | String | The User Id. |
| CreatedDateTime | Datetime | Timestamp of when the message was created. |
| LastUpdatedDateTime | Datetime | The timestamp on which this message was last updated. |
| Topic | String | The Topic. |