Retrieves details of participants in Microsoft Teams chat conversations.

Table Specific Information

SELECT

The add-in 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 add-in.

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