ChannelMembers
Retrieves a list of members belonging to a specific Microsoft Teams channel.
Table Specific Information
SELECT
The provider uses the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators:
- ChannelId supports the '=' operator.
- TeamId supports the '=,IN' operators.
Note: ChannelId and TeamId must be included in the WHERE clause to retrieve any data from the ChannelMembers view. These filters are required by the API and are evaluated server-side.
The rest of the filter is executed client-side within the provider.
For example, the following queries are processed server-side:
SELECT * FROM ChannelMembers WHERE ChannelId = '19:[email protected]' AND TeamId = 'f7985bee-7fb4-404d-a954-5ba68ae7c8db' SELECT * FROM ChannelMembers WHERE ChannelId = '19:[email protected]' AND TeamId IN ('f7985bee-7fb4-404d-a954-5ba68ae7c8db', 'da838338-4e77-4c05-82a6-79d9f0274511')
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the channel member in Microsoft Teams. |
| TeamId | String | Identifier of the team to which the channel belongs. |
| DisplayName | String | Full display name of the channel member. |
| String | Email address of the channel member. | |
| Roles | String | Roles assigned to the channel member, such as owner or member. |
| TenantId | String | Identifier of the Microsoft 365 tenant associated with the member. |
| UserId | String | Unique user identifier for the channel member. |
| StartDateTime | Datetime | Timestamp indicating when the membership history for the channel started. |
| ChannelId | String | Identifier of the Microsoft Teams channel where the member is assigned. |