Returns messages and replies exchanged within a Microsoft Teams channel.

View-Specific Information

SELECT

The connector uses the Microsoft Teams API to process WHERE clause conditions built with the columns and operator shown below. The rest of the filter is executed client-side within the connector.

• TeamId supports the = operator.
• ChannelId supports the = operator.
• Id supports the = operator.

Note: For best performance, specify both TeamId and ChannelId in the WHERE clause.

Example Queries

To retrieve all channel messages:

SELECT * FROM ChannelMessages

To retrieve all messages from a specific team:

SELECT * FROM ChannelMessages WHERE TeamId = '4729c5e5-f923-4435-8a41-44423d42ea79'

To retrieve messages from a specific channel within a team:

SELECT * FROM ChannelMessages WHERE TeamId = '4729c5e5-f923-4435-8a41-44423d42ea79' AND ChannelId = '19:[email protected]'

To retrieve a specific message:

SELECT * FROM ChannelMessages WHERE TeamId = '4729c5e5-f923-4435-8a41-44423d42ea79' AND ChannelId = '19:[email protected]' AND Id = '1688061957561'

Keyword Search

The Microsoft Teams API does not support filtering channel messages by body content in a WHERE clause. To search for messages containing a keyword, use the SearchMessages stored procedure, which routes the request through the Microsoft Teams Search API and returns results across both ChannelMessages and ChatMessages.

The following example searches for all messages containing the keyword "Asteria":

EXEC SearchMessages Keyword = 'Asteria'

Each result includes a TableName column indicating whether the full message record can be retrieved from ChannelMessages or ChatMessages, along with the Id, TeamId, and ChannelId values needed to perform that lookup.

Columns