Teams

Maintains records of Microsoft Teams instances, including team names, visibility settings, and associated group metadata.

テーブル固有の情報

Select

チームからすべてを取得するか、GroupId を'=' とIN 演算子で指定することでTeams テーブルをクエリします。デフォルトでは、自身がメンバーであるグループのチームのみ返されます。組織の全グループのチームを取得するには、IncludeAllGroups プロパティをtrue に設定してください。本製品は Microsoft Teams API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品内部で処理されます。

GroupId は、'=' およびIN 演算子をサポートします。

例えば、次のクエリはサーバーサイドで処理されます。

SELECT * FROM Teams WHERE GroupId IN ('4729c5e5-f923-4435-8a41-44423d42ea79', 'acabe397-8370-4c31-aeb7-2d7ae6b8cda1')

SELECT * FROM Teams WHERE GroupId = '4729c5e5-f923-4435-8a41-44423d42ea79'

Insert

最低でもGroupId およびDisplayName は、グループに新しいチームを追加するために必須です。他のフィールドもすべて指定できます。

INSERT INTO Teams (DisplayName, GroupId, funSettings_allowGiphy) VALUES ('Cool team', 'acabe397-8370-4c31-aeb7-2d7ae6b8cda1', false)

Update

チームのレコードを更新するには、WHERE 句にId を指定してください。アーカイブされていないチームのみ更新できます。

UPDATE Teams SET DisplayName = 'My Team', funSettings_allowGiphy = false, funSettings_allowGiphy = true, funSettings_allowStickersAndMemes = true, funSettings_allowCustomMemes = false, guestSettings_allowCreateUpdateChannels = true, guestSettings_allowDeleteChannels = false, memberSettings_allowCreateUpdateChannels = false, memberSettings_allowDeleteChannels = true, Description = 'some desc' WHERE Id = '4729c5e5-f923-4435-8a41-44423d42ea79'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for the Microsoft Team.
GroupId	String	False	The unique identifier for the Microsoft 365 Group backing the Team.
DisplayName	String	False	The user-friendly name of the Team as shown in Microsoft Teams.
Description	String	False	An optional description providing context or purpose for the Team.
Classification	String	False	An optional label that describes the data or business sensitivity level of the Team, based on predefined classifications in the organization's directory.
CreatedDateTime	Datetime	False	The date and time when the Team was created.
FunSettings_allowCustomMemes	Bool	False	Indicates whether users are allowed to upload and use custom memes in the Team chat.
FunSettings_allowGiphy	Bool	False	Indicates whether users are allowed to search and share Giphy images within the Team.
FunSettings_allowStickersAndMemes	Bool	False	Indicates whether users can use pre-built stickers and memes in the Team.
FunSettings_giphyContentRating	String	False	Specifies the Giphy content rating for the Team. Acceptable values include moderate and strict.
GuestSettings_allowCreateUpdateChannels	Bool	False	Indicates whether guest users are allowed to create and update channels within the Team.
GuestSettings_allowDeleteChannels	Bool	False	Indicates whether guest users are allowed to delete channels within the Team.
InternalId	String	False	A system-level internal identifier used for auditing and integrations such as Office 365 Management Activity API.
IsArchived	Bool	False	Indicates whether the Team is archived, meaning it is in read-only mode and no changes can be made.
MemberSettings_allowAddRemoveApps	Bool	False	If true, Team members are allowed to install or remove apps within the Team.
MemberSettings_allowCreatePrivateChannels	Bool	False	If true, Team members can create and manage private channels.
MemberSettings_allowCreateUpdateChannels	Bool	False	If true, Team members are permitted to create new channels or update existing ones.
MemberSettings_allowCreateUpdateRemoveConnectors	Bool	False	If true, Team members can configure connectors, including creating, updating, or removing them.
MemberSettings_allowCreateUpdateRemoveTabs	Bool	False	If true, Team members can add, update, or remove tabs in Team channels.
MemberSettings_allowDeleteChannels	Bool	False	If true, Team members have permission to delete channels.
MessagingSettings_allowChannelMentions	Bool	False	If true, allows users to use @channel mentions to notify all members of a channel.
MessagingSettings_allowOwnerDeleteMessages	Bool	False	If true, allows Team owners to delete any message posted in the Team.
MessagingSettings_allowTeamMentions	Bool	False	If true, allows users to use @team mentions to notify all members of the Team.
MessagingSettings_allowUserDeleteMessages	Bool	False	If true, allows users to delete their own messages.
MessagingSettings_allowUserEditMessages	Bool	False	If true, allows users to edit their own messages after sending.
Specialization	String	False	Indicates whether the Team is configured for a special use case (such as education or healthcare), which affects available features.
Visibility	String	False	Specifies whether the Team is public or private. Public teams can be discovered and joined by anyone in the organization.
WebUrl	String	False	A deep link to open the Team directly in the Microsoft Teams client. This link should not be parsed or altered.
summary_guestsCount	Integer	True	The number of guest users who are part of the Team.
summary_membersCount	Integer	True	The number of members in the Team, excluding guests and owners.
summary_ownersCount	Integer	True	The number of users who have owner-level permissions in the Team.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.

Build 25.0.9434