Tracks Microsoft Teams channel instances, capturing names, privacy settings, types (standard, private), and team associations.

Table Specific Information

Select

Query the Channels table by retrieving all channels in all teams or by specifying TeamId. The connector uses the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators:

• TeamId supports the '=' and IN operators. The rest of the columns support the '=', '!=', IN, LIKE, IS, IS NOT operator.

The rest of the filter is executed client side within the connector

For example, the following queries are processed server side:

SELECT * FROM Channels WHERE TeamId IN ('da838338-4e77-4c05-82a6-79d9f0274511', 'da838338-4e77-4c05-82a6-79d9f0274555')

SELECT * FROM Channels WHERE TeamId = 'da838338-4e77-4c05-82a6-79d9f0274511' AND Id = '19:[email protected]'

SELECT * FROM Channels WHERE description != 'desc'

Note: the summary columns are only populated when the table is filtered with the Id column. Additionally, there is no filtering allowed with the summary columns for this table.

Insert

At least TeamId and DisplayName are required to insert a new channel to a team. You can specify any other field as well.

INSERT INTO Channels (displayName, description, TeamId) VALUES ('a new channel', 'top tasks channel', 'da838338-4e77-4c05-82a6-79d9f0274511')

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier assigned to the channel by Microsoft Teams.
TeamId	String	False	The identifier of the Team to which this channel belongs, used to associate the channel with its parent Team.
CreatedDateTime	Datetime	False	The date and time when the channel was initially created, in UTC format.
Description	String	False	An optional user-defined description that provides context or purpose for the channel.
DisplayName	String	False	The name of the channel as shown in the Microsoft Teams interface to users.
Email	String	False	The email address assigned to the channel for message forwarding, available in channels with email integration. Read-only.
IsArchived	Bool	False	Indicates whether the channel is currently in a read-only, archived state.
IsFavoriteByDefault	Bool	False	Specifies whether the channel is automatically pinned as a favorite for all team members upon creation. Only configurable via API during team creation.
MembershipType	String	False	Defines the access type of the channel, such as standard, private, or shared. Set at creation time and cannot be changed later.
WebUrl	String	False	The deep link URL to access the channel in Microsoft Teams. This link is generated via the 'Get link to channel' option and should be treated as an opaque identifier.