Retrieves details of participants in Microsoft Teams chat conversations.

Table Specific Information

SELECT

The provider use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators:

• UserId supports the '=' operator.
• ChatId supports the '=,IN' operators.

Note: UserId and ChatId must be included in the WHERE clause to retrieve any data from the ChatMembers 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 ChatMembers WHERE UserId = 'e4ea490e-b30c-4b1e-92b0-337117920315' AND ChatId = '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_90a27c51-5c74-453b-944a-134ba86da790@unq.gbl.spaces'

SELECT * FROM ChatMembers WHERE UserId = 'e4ea490e-b30c-4b1e-92b0-337117920315' AND ChatId IN ('19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_90a27c51-5c74-453b-944a-134ba86da790@unq.gbl.spaces', '19:92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe_b62067c0-8314-42f8-9d02-d1c2051dfcdc@unq.gbl.spaces')

Columns