Learn how to read the color picker column on monday boards using the platform API
The color picker column allows design teams to assign specific colors to items. After selecting a color, the column will display the relevant color code in the format of your choice. You can read the color picker column via the API, but you currently cannot filter, update, or clear it.
Read the color picker column
You can query the color picker column using the column_values
object that enables you to return column-specific subfields by sending a fragment in your query. Values for the color picker column are of the ColorPickerValue
type.
query {
items (ids:[1234567890, 9876543210]) {
column_values {
... on ColorPickerValue {
color
updated_at
}
}
}
}
import { ApiClient } from "@mondaydotcomorg/api";
const mondayApiClient = new ApiClient({ token: myToken });
const query = `query($itemIds: [ID!]) { items (ids:$itemIds) { column_values { value ... on ColorPickerValue { color updated_at } } } }`;
const variables = {
itemIds: [9571351485, 9572374902],
};
const response = await mondayApiClient.request(query, variables);
Fields
Field | Description |
---|---|
color String | The column's HEX color value. |
column Column! | The column the value belongs to. |
id ID! | The column's unique identifier. |
text String | The column's value as text. This field will return null if the column has an empty value. |
type ColumnType! | The column's type. |
updated_at Date | The column's last updated date. |
value JSON | The column's JSON-formatted raw value. |
Join our developer community!
We've created a community specifically for our devs where you can search through previous topics to find solutions, ask new questions, hear about new features and updates, and learn tips and tricks from other devs. Come join in on the fun! 😎