TeamMembers
Retrieves the list of users who are members of a specific Microsoft Teams 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 | Unique identifier for the team member in Microsoft Teams. |
| TeamId | String | Identifier of the team to which the member belongs. |
| DisplayName | String | Full display name of the team member. |
| String | Email address of the team member. | |
| Roles | String | Roles assigned to the team member, such as owner or member. |
| TenantId | String | Identifier of the Microsoft 365 tenant associated with the team member. |
| UserId | String | Unique user identifier for the team member. |
| StartDateTime | Datetime | Timestamp indicating when the membership history for the team started. |