Columns
Retrieves the visible columns for a specific board, providing structural information.
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.
- Id supports the '=','IN' comparison operators.
- BoardId supports the '=','IN' comparison operator.
- Type supports the '=','IN' comparison operator.
SELECT * FROM Columns WHERE Id = 'name'
SELECT * FROM Columns WHERE Id IN ('name', 'status')
INSERT
The following inputs can be used in INSERT statements:
Id, BoardId, Settings, Title, Description, Type, AfterColumnId
INSERT INTO Columns (BoardId,Id,Type) VALUES ('3820334','custom_column_id_123','status')
UPDATE
The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):
Title, Description
UPDATE Columns SET Title='AnotherName' WHERE Id='name' AND BoardId='3820334'
DELETE
You can delete entries by specifying the Id and BoardId.
DELETE FROM Boards WHERE Id='test' AND BoardId='3820334'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the column within its associated board. Ensures each column can be referenced individually. | |
| BoardId [KEY] | String | False |
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 | False |
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'). The allowed values are auto_number, board_relation, button, checkbox, color_picker, country, creation_log, date, dependency, doc, dropdown, email, file, formula, group, hour, integration, item_assignees, item_id, last_updated, link, location, long_text, mirror, name, numbers, people, person, phone, progress, rating, status, subtasks, tags, team, text, time_tracking, timeline, unsupported, vote, week, world_clock. | |
| Width | Int | False |
Defines the width of the column in terms of pixels or a similar unit. Determines how much screen space the column occupies. |
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. |