Get a collection of workspaces.

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

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

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

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). 使用できる値は次のとおりです。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.
IsDefaultWorkspace	String	False		Returns true if it is the default workspace of the product or account.
ItemURL	String	False		The workspace's URL.