ChannelMembers
Get members from 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.
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 | Member Id. |
| TeamId | String | Team Id. |
| DisplayName | String | Display name. |
| String | Email of member. | |
| Roles | String | Role of member. |
| TenantId | String | Tenant Id. |
| UserId | String | User Id. |
| StartDateTime | Datetime | History start date time. |
| ChannelId | String | The Channel Id. |