Get a collection of folders. Note that this won't return folders from closed workspaces to which you are not subscribed.

Table-Specific Information

SELECT

The adapter uses the Monday API to process some of the filters. The adapter processes other filters client-side within the adapter. 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.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Folders WHERE Id = '12622355'
SELECT * FROM Folders WHERE WorkspaceId = '3578971'

INSERT

The following inputs can be used in INSERT statements:

ParentId, WorkspaceId, Color, Name

INSERT INTO Folders (WorkspaceId,Name,Color) VALUES ('3578971','TestFolder','BRIGHT_BLUE')

UPDATE

The following inputs can be used in UPDATE statements:

ParentId, Color, Name

UPDATE Folders SET Color='SUNSET',Name='UpdatedName' WHERE Id='12678064'

DELETE

You can delete entries by specifying the Id.

DELETE FROM Folders WHERE Id='12678064'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The folder's unique identifier.
OwnerId	String	False	Users.Id	The folder's user owner unique identifier.
ParentId	String	False		The unique identifiers of the folder's parent folder.
SubFolderIds	String	False		The unique identifiers of the sub-folders inside the folder.
WorkspaceId	String	False	Workspaces.Id	The workspace's unique identifier.
Color	String	False		The folder's color. The allowed values are DONE_GREEN, BRIGHT_GREEN, WORKING_ORANGE, DARK_ORANGE, SUNSET, STUCK_RED, DARK_RED, SOFIA_PINK, LIPSTICK, PURPLE, DARK_PURPLE, INDIGO, BRIGHT_BLUE, AQUAMARINE, CHILI_BLUE, NULL.
Name	String	False		The folder's name.
CreatedAt	Datetime	False		The folder's creation date.