Other Types

Learn more about the other types used when reading, creating, updating, and deleting columns via the API


/tThe 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 a 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 input configuration for a column's capabilities.

FieldDescriptionSupported Fields
calculated CalculatedCapabilityInputThe input for configuring a column's calculated capability settings.function CalculatedFunction!

CalculatedCapabilityInput

An object containing the input settings for a column's calculated capabilities.

FieldDescriptionSupported Fields
calculated CalculatedCapabilityInputThe input for configuring a column's calculated capability settings.function CalculatedFunction!

CalculatedFunction

An enum containing the functions 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 containing the mapping between source and target columns across boards.

FieldDescription
source ID!The source column's unique identifier.
target IDThe target column's unique identifier.

ColumnType

An enum containing the available column types that can be filtered, read, or updated in queries and mutations.

auto_numberboard_relationbutton
checkboxcolor_pickercountry
creation_logdatedependency
docdropdownemail
fileformulahour
item_assigneesitem_idlast_updated
linklocationlong_text
mirrornamenumbers
peoplephoneprogress
ratingstatussubtasks
tagsteamtext
timelinetime_trackingvote
weekworld_clockunsupported

CreateDropdownColumnSettingsInput

An object containing the settings for a new dropdown column.

FieldDescriptionSupported Fields
label_limit_count IntThe 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 BooleanWhether to limit the number of labels that can be selected. Must be used with the label_limit_count field.

CreateDropdownLabelInput

An object containing the properties of a label in a new dropdown column.

FieldDescription
label StringThe new dropdown column's labels.

CreateStatusColumnSettingsInput

An object containing the settings for a new status column.

Field

Description

Supported Fields

labels [CreateStatusLabelInput!]!

An array containing the status column’s labels.

color StatusColumnColors!
description String
index Int!
is_done Boolean
label String!

CreateStatusLabelInput

An object containing the properties of a label in a new status column.

FieldDescriptionEnum 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 StringThe 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 BooleanWhether the label's status is done.
label String!The label's text value.

FileValueItem

An object containing the possible file representations for a files column's value.

Possible Types
FileAssetValue
FileDocValue
FileLinkValue

FileAssetValue

An object containing the metadata for an uploaded asset file in a files column.

FieldsDescription
asset Asset!The asset associated with the file.
asset_id ID!The asset's unique identifier.
created_at Date!The file's creation date.
creator UserThe file's creator.
creator_id IDThe unique identifier of the file's creator.
is_image Boolean!Whether the asset is an image.
name String!The asset's name.

FileDocValue

An object containing the metadata for a monday document returned in a files column.

FieldDescription
created_at Date!The file's creation date.
creator UserThe file's creator.
creator_id IDThe unique identifier of the file's creator.
doc Document!The document associated with the file.
file_id ID!The file's unique identifier.
object_id ID!The unique identifier of the associated board or object.
url StringThe file's URL.

FileLinkValue

An object containing the metadata for an externally linked file in a files column.

Field

Description

Enum Values

created_at Date!

The file's creation date.

creator User

The file's creator.

creator_id ID

The unique identifier of the file's creator.

file_id ID!

The file's unique identifier.

kind FileLinkValueKind!

The file's kind.

box
dropbox
google_drive
link
onedrive

name String!

The file's name.

url String

The file's URL.


MirroredItem

An object containing details about a mirrored item returned by the MirrorValue implementation.

FieldsDescriptionPossible Types
linked_board Board!The linked board.
linked_board_id ID!The linked board's unique identifier.
linked_item Item!The linked item.
mirrored_value MirroredValueThe mirrored values.Board, BoardRelationValue, ButtonValue, CheckboxValue, ColorPickerValue, CountryValue, CreationLogValue, DateValue, DependencyValue, DocValue, DropdownValue, EmailValue, FileValue, FormulaValue, Group, HourValue, ItemIdValue, LastUpdatedValue, LinkValue, LocationValue, LongTextValue, MirrorValue, NumbersValue, PeopleValue, PhoneValue, ProgressValue, RatingValue, StatusValue, SubtasksValue, TagsValue, TeamValue, TextValue, TimeTrackingValue, TimelineValue, UnsupportedValue, VoteValue, WeekValue, WorldClockValue

NumberValueUnitDirection

An enum containing the possible positions for a number value’s unit symbol within a NumbersValue field.

Enum valuesDescription
leftThe symbol is placed to the left of the number.
rightThe symbol is placed to the right of the number.

PeopleEntity

An object containing the people or team information represented in a PeopleValue field.

Field

Description

Enum Values

id ID!

The unique identifier of the person or team.

kind Kind

The type of entity.

person
team


StatusColumnCapabilitiesInput

An object containing the input configuration for a status column's capabilities.

FieldDescriptionSupported Fields
calculated StatusCalculatedCapabilityInputThe status column's capability settings.function StatusCalculatedFunction!

StatusCalculatedFunction

An enum containing the functions used to calculate values in a status column.

FieldDescriptionEnum Values
functionStatusCalculatedFunction!The function to calculate the values.COUNT_KEYS (label count)

StatusLabelStyle

An object containing the style properties for a status label returned by the StatusValue implementation.

FieldDescription
border String!The label's border Hex color code.
color String!The label's Hex color code.

TimeTrackingHistoryItem

An object containing the details of an individual time-tracking session returned by the TimeTrackingValue implementation.

FieldDescription
created_at Date!The date the session was added to the item.
ended_at DateThe date the session ended.
ended_user_id IDThe unique identifier of the user that ended the time tracking.
id ID!The unique session identifier.
manually_entered_end_date Boolean!Whether the session end date was entered manually.
manually_entered_end_time Boolean!Whether the session end time was entered manually.
manually_entered_start_date Boolean!Whether the session start date was entered manually.
manually_entered_start_time Boolean!Whether the session start time was entered manually.
started_at DateThe date the session was started. Only applicable if the session was started by pressing the play button or through an automation.
started_user_id IDThe unique identifier of the user that started the time tracking.
status String!The session's status.
updated_at DateThe date the session was updated.

UpdateDropdownColumnSettingsInput

An object containing the updated settings for a dropdown column.

FieldDescriptionSupported Fields
label_limit_count IntThe 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 BooleanWhether to limit the number of labels that can be selected. Must be used with the label_limit_count field.

UpdateDropdownLabelInput

An object containing the properties of a dropdown label to update.

FieldDescription
id IntThe unique identifier of the label to update.
is_deactivated BooleanWhether the label is deactivated.
label StringThe new dropdown column's labels.

UpdateStatusColumnSettingsInput

An object containing the updated configuration settings for a status column.

Field

Description

Supported Fields

labels [UpdateStatusLabelInput!]!

An array containing the status column’s updated labels.

color StatusColumnColors!
description String
id Int
index Int!
is_deactivated Boolean
is_done Boolean
label String!

UpdateStatusLabelInput

An object containing the properties of a status label to update.

FieldDescriptionEnum 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 StringThe label's description.
id IntThe 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 BooleanWhether the label is deactivated.
is_done BooleanWhether the label's status is "Done".
label String!The label's text value.