Get members from channel.

Table Specific Information

SELECT

The connector 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 connector

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