Chats
Provides a list of chat threads within Microsoft Teams, including group and one-on-one 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 | Unique identifier for the chat in Microsoft Teams. |
| ChatType | String | Specifies the type of chat, such as one-on-one, group, or meeting chat. |
| UserId | String | Identifier of the user associated with the chat. |
| CreatedDateTime | Datetime | Timestamp indicating when the chat was created. |
| LastUpdatedDateTime | Datetime | Timestamp indicating when the chat was last updated. |
| Topic | String | Subject or topic of the chat, if specified. |
| IsHiddenForAllMembers | Bool | Indicates whether the chat is hidden for all members. |