Workspaces

Get a collection of workspaces.

View-Specific Information

SELECT

The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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

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

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

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

You can delete entries by specifying the Id.

DELETE FROM Workspaces WHERE Id='3819431'

Columns


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.