Your accounts managed columns.

Table-Specific Information

SELECT

The provider uses the Monday API to process some of the filters. The provider processes other filters client-side within the provider.

• Id supports the '=','IN' comparison operators.
• State supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM ManagedColumns WHERE Id = '124423723'
  SELECT * FROM ManagedColumns WHERE State = 'active'

INSERT

The following columns can be used to create a new record:

Title, Description

The following pseudo-column can be used to create a new record:

Settings (references ColumnSettings)

ColumnSettings Temporary Table Columns

Column Name	Type	Description
Index	105nt	The updated index of the new managed status column's label.
Color	115tring	The updated color of the managed status column's label.
Description	115tring	The status label's description.
IsDone	98ool	Whether the label is marked as 'Done'
Label	115tring	The updated text on the new managed status column's label.

UPDATE

The following columns can be updated:

Title, Description, State, Revision

The following pseudo-column can be used to update a record:

Settings (references ColumnSettings)

ColumnSettings Temporary Table Columns

Column Name	Type	Description
Id	105nt	The unique identifier of the existing label to update.
Index	105nt	The updated index of the new managed status column's label.
Color	115tring	The updated color of the managed status column's label.
Description	115tring	The status label's description.
IsDone	98ool	Whether the label is marked as 'Done'
IsDeactivated	98ool	Whether the status label is deactivated.
Label	115tring	The updated text on the new managed status column's label.

DELETE

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier of the managed column.
Title	String	False		The managed column's title.
Description	String	False		The column's description.
State	String	False		The managed column's state. The allowed values are active, inactive, deleted.
SettingsJSON	String	True		The managed column's settings in JSON.
Revision	Int	False		The current version of the managed column.
CreatedAt	Datetime	True		The managed column's creation date.
CreatedBy	String	True		The unique identifier of the user who created the managed column.
UpdatedAt	Datetime	True		The managed column's last updated date.
UpdatedBy	String	True		The unique identifier of the user who last updated the managed column.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Type	String	The managed column's type.
Settings	String	The managed column's settings.