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. |