Teams

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

Table Specific Information

Select

Query the Teams table by retrieving everything from teams or by specifying GroupId with = and IN operators. By default only the teams of the groups you are a member of will be returned. To retreive teams for all groups in your organization, set IncludeAllGroups property to true. The connector will use the Microsoft Teams API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

GroupId supports the '=' and IN operator.

For example, the following query is processed server side:

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

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

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

Update

To update a team record you need to specify the Id in WHERE clause. Only unarchived teams can be updated.

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.9454