Channels
Tracks Microsoft Teams channel instances, capturing names, privacy settings, types (standard, private), and team associations.
テーブル固有の情報
Select
すべてのチーム内のすべてのチャネルを取得するかTeamId を指定することで、Channels テーブルをクエリします。 connector は Microsoft Teams API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。
- TeamId は、'=' およびIN 演算子をサポートします。 他のカラムは、'='、'!='、IN、LIKE、IS、IS NOT 演算子をサポートします。
その他のフィルタはクライアントサイドでconnector 内部で処理されます。
例えば、次のクエリはサーバーサイドで処理されます。
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：テーブルがId カラムでフィルタリングされた場合にのみ、summary カラムに値が入力されます。また、このテーブルのsummary カラムではフィルタリングはできません。
Insert
最低でもTeamId およびDisplayName は、チームに新しいチャネルを追加するために必須です。他のフィールドもすべて指定できます。
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. |
| 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. |