Channels

Channels table for MSTeams data provider.

Table Specific Information

Select

Query the Channels table by retrieving all channels in all teams or by specifying TeamId. The component 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 component

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'

SELECT * FROM Channels WHERE webUrl LIKE '%teams.microsoft.com/l/channel/%'

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 channel's unique identifier.
TeamId	String	False	The Team Id.
CreatedDateTime	Datetime	False	Timestamp at which the channel was created.
Description	String	False	Optional textual description for the channel.
DisplayName	String	False	Channel name as it will appear to the user in Microsoft Teams.
Email	String	False	The email address for sending messages to the channel. Read-only.
IsFavoriteByDefault	Bool	False	Indicates whether the channel should automatically be marked 'favorite' for all members of the team. Can only be set programmatically with Create team. Default: false.
MembershipType	String	False	The type of the channel. Can be set during creation and cannot be changed. Default: standard.
WebUrl	String	False	A hyperlink that will go to the channel in Microsoft Teams. This is the URL that you get when you right-click a channel in Microsoft Teams and select Get link to channel. This URL should be treated as an opaque blob, and not parsed.
FilesFolder_id	String	True	The FilesFolder Id.

SSIS Components for Microsoft Teams

Channels

Table Specific Information

Select

Insert

Columns