CData Python Connector for Monday

Build 23.0.8839


Get a collection of workspaces.

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.

  • Id supports the '=','IN' comparison operators.
  • Kind supports the '=' comparison operator.
  • State supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM Workspaces WHERE Id='3578971'
SELECT * FROM Workspaces WHERE Kind='open'
SELECT * FROM Workspaces WHERE State='active'


INSERT statements are mapped to the 'create_workspace' GraphQL mutation.

The following inputs can be used in INSERT statements:

Description, Kind, Name

INSERT INTO Workspaces (Name,Kind,Description) VALUES ('New Workspace','open','This is my new workspace.')


UPDATE statements are mapped to the 'update_workspace' GraphQL mutation.

The following inputs can be used in INSERT statements:

Id, Description, Name, Kind

UPDATE Workspaces Set Description='testDescription', Name='testName', Kind='open' WHERE Id='3819431'


DELETE statements are mapped to the 'delete_workspace' GraphQL mutation.

You can delete entries by specifying the Id.

DELETE FROM Workspaces WHERE Id='3819431'


Name Type ReadOnly References Description
Id [KEY] String False

The workspace's unique identifier.

Description String False

The workspace's description.

Kind String False

The workspace's kind (open / closed).

Name String False

The workspace's name.

State String False

The workspace's state (all / active / archived / deleted).

CreatedAt Datetime False

The workspace's creation date.

AccountProductId String False

The account product id.

AccountProductKind String False

The account product kind (core / marketing / crm / software / projectManagement / project_management / forms / whiteboard).

SettingsIconColor String False

The icon color in hex value. Used as a background for the image.

SettingsIconImage String False

The public image URL, which is temporary in the case of a file that was uploaded by the user, so you'll need to pull a new version at least once an hour. In case it is null, you can use the first letter of the workspace name.

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