Retrieves the list of teams subscribed to a specific workspace.

Table-Specific Information

SELECT

The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.

• WorkspaceId supports the '=' comparison operator.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM WorkspaceTeams WHERE Kind = 'owner'
SELECT * FROM WorkspaceTeams WorkspaceId = '3820334'

INSERT

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

The following inputs can be used in INSERT statements:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','subscriber')
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','owner')

DELETE

You can delete entries by specifying the Id and WorkspaceId.

DELETE FROM WorkspaceTeams WHERE Id = '961021' AND WorkspaceId = '3820334'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the team, used to distinguish each team within the system. This ID is referenced in other tables or operations to identify the specific team.
WorkspaceId [KEY]	String	False		The unique identifier for the workspace to which the team belongs. It is used to associate the team with a specific workspace for collaboration or access control purposes.
Kind	String	False		Defines the team’s role within the workspace. The role can be 'subscriber' or 'owner', where owners have additional permissions compared to subscribers. This column is useful for filtering and managing access levels. The allowed values are owner, subscriber.