Retrieves the visible columns for a specific board, providing structural information.

Table-Specific Information

SELECT

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

• Id supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operators.
• Type supports the '=','IN' comparison operators.

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

  SELECT * FROM Columns WHERE Id = 'name'
  SELECT * FROM Columns WHERE Id IN ('name', 'status')
  SELECT * FROM Columns WHERE BoardId = '128443935'
  SELECT * FROM Columns WHERE Type = 'board-relation'

INSERT

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

Id, BoardId, Settings, Title, Description, Type, CapabilitiesFunction

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

AfterColumnId, SettingsLabels (references ColumnSettings), SettingsDropdownLimitCount, SettingsDropdownLimitSelect

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:

Settings, Title, Description, Type, Revision, CapabilitiesFunction

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

SettingsLabels (references ColumnSettings), SettingsDropdownLimitCount, SettingsDropdownLimitSelect

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 columns:

Id, BoardId

DELETE FROM Boards WHERE Id='test' AND BoardId='3820334'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the column within its associated board. Ensures each column can be referenced individually.
BoardId [KEY]	String	True	Boards.Id	The unique identifier of the board to which the column belongs. Used to establish a relationship between the column and its parent board.
Archived	Bool	True		Indicates whether the column is archived. A value of 'true' means the column is no longer actively used but remains stored for reference.
Settings	String	False		Contains the column's settings stored in a serialized string format. These settings define the column's configuration and behavior.
Title	String	False		The display name or title of the column, used to identify its purpose or content visually.
Description	String	False		A detailed description of the column's purpose or content. Provides additional context for users.
Type	String	False		Specifies the type of the column, indicating its role or the kind of data it contains (for example, 'text', 'number', 'date').
Width	Int	True		Defines the width of the column in terms of pixels or a similar unit. Determines how much screen space the column occupies.
Revision	String	False		The column’s current revision.
CapabilitiesCalculatedType	String	True		The type of calculated value.
CapabilitiesFunction	String	False		The function to calculate the parent values.

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
AfterColumnId	String	The unique identifier of the column after which the current column will be inserted. Used to specify the placement of a new column relative to existing ones.
SettingsLabels	String	An array containing the dropdown column's labels
SettingsDropdownLimitCount	Int	The maximum number of labels that can be selected.
SettingsDropdownLimitSelect	Bool	Whether to limit the number of labels that can be selected.