Learn more about the other types used when reading, creating, updating, and deleting columns via the API
The monday.com columns API lets you query a board's column configuration, appearance, and settings.
Each of the object types described below represents a specific aspect of a column. They can be queried as subfields on the columns query or provide column metadata in mutations.
ColumnCapabilities
An object containing the column's capability settings.
Field | Description | Supported Subfields |
|---|---|---|
calculated | The column’s capability settings. | calculated_type |
CalculatedCapability
An object containing the column's calculated capability settings.
Field | Description | Enum Values |
|---|---|---|
calculated_type | The type of calculated value. | |
function | The function to calculate the parent values. |
|
ColumnCapabilitiesInput
An object containing the column capabilities configuration.
| Field | Description | Supported fields |
|---|---|---|
calculated CalculatedCapabilityInput | The input for configuring a column's calculated capability settings. | function CalculatedFunction! |
CalculatedCapabilityInput
An object containing the column's calculated capabilities settings. Enables calculated functionality for the column.
| Field | Description | Supported fields |
|---|---|---|
calculated CalculatedCapabilityInput | The input for configuring a column's calculated capability settings. | function CalculatedFunction! |
Calculated function
An object that defines the function used to calculate column values within column capabilities
Field | Description | Enum Values |
|---|---|---|
function | The function to count the values. If not provided, the default column type function will apply. |
|
ColumnMappingInput
An object that defines the column mapping between the target and source boards.
| Field | Description |
|---|---|
source ID! | The source column's unique identifier. |
target ID | The target column's unique identifier. |
ColumnType
ColumnType accepts enum values to specify which column type to filter, read, or update in your query or mutation.
auto_number | board_relation | button |
checkbox | color_picker | country |
creation_log | date | dependency |
doc | dropdown | email |
file | formula | hour |
item_assignees | item_id | last_updated |
link | location | long_text |
mirror | name | numbers |
people | phone | progress |
rating | status | subtasks |
tags | team | text |
timeline | time_tracking | vote |
week | world_clock | unsupported |
CreateDropdownColumnSettingsInput
An object containing the new dropdown column's settings.
| Field | Description | Supported Fields |
|---|---|---|
label_limit_count Int | The maximum number of labels that can be selected. Must be used with the limit_select field. | |
labels [CreateDropdownLabelInput!]! | An array containing the dropdown column's labels. | label String! |
limit_select Boolean | Whether to limit the number of labels that can be selected. Must be used with the label_limit_count field. |
CreateDropdownLabelInput
An array containing the dropdown column's labels.
| Field | Description |
|---|---|
label String | The new dropdown column's labels. |
CreateStatusColumnSettingsInput
An object containing the new status column's settings.
Field | Description | Supported Fields |
|---|---|---|
labels | An array containing the status column’s labels. | color |
CreateStatusLabelInput
An object containing the new status column's labels.
| Field | Description | Enum Values |
|---|---|---|
color StatusColumnColors! | The label's color. | working_orange, done_green, stuck_red, dark_blue, purple, explosive, grass_green, bright_blue, saladish, egg_yolk, blackish, dark_red, sofia_pink, lipstick, dark_purple, bright_green, chili_blue, american_gray, brown, dark_orange, sunset, bubble, peach, berry, winter, river, navy, aquamarine, indigo, dark_indigo, pecan, lavender, royal, steel, orchid, lilac, tan, sky, coffee, teal |
description String | The label's description. | |
index Int! | The label's place in the list of supported labels. Lower numbers indicate a higher placement in the list. | |
is_done Boolean | Whether the label's status is done. | |
label String! | The label's text value. |
StatusColumnCapabilitiesInput
An object containing the status column capabilities configuration.
| Field | Description | Supported Fields |
|---|---|---|
calculated StatusCalculatedCapabilityInput | The status column's capability settings. | function StatusCalculatedFunction! |
StatusCalculatedFunction
An object containing the status column's calculated capability settings.
| Field | Description | Enum Values |
|---|---|---|
functionStatusCalculatedFunction! | The function to calculate the values. | COUNT_KEYS (label count) |
UpdateDropdownColumnSettingsInput
An object containing the dropdown column's updated settings.
| Field | Description | Supported Fields |
|---|---|---|
label_limit_count Int | The maximum number of labels that can be selected. Must be used with the limit_select field. | |
labels [UpdateDropdownLabelInput!]! | An array containing the dropdown column's labels. | label String! |
limit_select Boolean | Whether to limit the number of labels that can be selected. Must be used with the label_limit_count field. |
UpdateDropdownLabelInput
An array containing the dropdown column's labels.
| Field | Description |
|---|---|
id Int | The unique identifier of the label to update. |
is_deactivated Boolean | Whether the label is deactivated. |
label String | The new dropdown column's labels. |
UpdateStatusColumnSettingsInput
An object containing the status column's updated configuration settings
Field | Description | Supported Fields |
|---|---|---|
labels | An array containing the status column’s updated labels. | color |
UpdateStatusLabelInput
An object containing the status column's updated labels.
| Field | Description | Enum Values |
|---|---|---|
color StatusColumnColors! | The label's color. | working_orange, done_green, stuck_red, dark_blue, purple, explosive, grass_green, bright_blue, saladish, egg_yolk, blackish, dark_red, sofia_pink, lipstick, dark_purple, bright_green, chili_blue, american_gray, brown, dark_orange, sunset, bubble, peach, berry, winter, river, navy, aquamarine, indigo, dark_indigo, pecan, lavender, royal, steel, orchid, lilac, tan, sky, coffee, teal |
description String | The label's description. | |
id Int | The unique identifier of the label to update. | |
index Int! | The label's place in the list of supported labels. Lower numbers indicate a higher placement in the list. | |
is_deactivated Boolean | Whether the label is deactivated. | |
is_done Boolean | Whether the label's status is done. | |
label String! | The label's text value. |
