TeamMembers
Get members from team.
Table Specific Information
Select
The connector will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- TeamId supports the '=,IN' operators.
For example, the following query is processed server side:
SELECT * FROM TeamMembers WHERE TeamId = 'f7985bee-7fb4-404d-a954-5ba68ae7c8db' SELECT * FROM TeamMembers WHERE 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. |