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 CalculatedCapability | The column's capability settings. | calculated_type ColumnType function CalculatedFunction! |
CalculatedCapability
An object containing the column's calculated capability settings.
Field | Description | Enum Values |
---|---|---|
calculated_type ColumnType | The type of calculated value. | |
function CalculatedFunction! | The function to calculate the parent values. | COUNT_KEYS MAX MIN MIN_MAX NONE SUM |
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 CalculatedFunction! | The function to count the values. If not provided, the default column type function will apply. | COUNT_KEYS (label count)MAX (maximum value)MIN (minimum value)MIN_MAX (both minimum and maximum values)NONE SUM (sum of all values) |
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 |