CData Python Connector for Monday

Build 23.0.8839


Get the teams subscribed to the workspace.

View-Specific Information


The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

  • 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 statements are mapped to the 'add_teams_to_workspace' GraphQL mutation.

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 statements are mapped to the 'delete_teams_from_workspace' GraphQL mutation.

You can delete entries by specifying the Id and WorkspaceId.

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


Name Type ReadOnly References Description
Id [KEY] String False

The team's unique identifier.

WorkspaceId [KEY] String False

The workspace's unique identifier.

Kind String False

The team's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839