The numbers column holds number values (either floats or ints).

Check out our help center to learn more about the numbers column.

Reading a numbers column

You can return the data in a numbers column in two different formats. The text field will return the data as a simple string, and the value field will return the data as a JSON string.

Here is an example payload showing both fields:

{
   "text": "1000",
   "value": "\"1000\""
}

Updating a numbers column

You can update a numbers column with both a simple string or a JSON string.

Simple strings

To update the numbers column, send a string containing a float or int.

For example: "3"

JSON

To update the numbers column send a string containing a float or int.

For example: \"3\"

Code example

mutation {
  change_multiple_column_values(item_id:11111, board_id:22222, column_values: "{\"numbers28\" : \"3\"}") {
    id
  }
}
fetch ("https://api.monday.com/v2", {
  method: 'post',
  headers: {
    'Content-Type': 'application/json',
    'Authorization' : 'YOUR_API_KEY'
  },
  body: JSON.stringify({
    query : "mutation ($myBoardId:Int!, $myItemId:Int!, $myColumnValues:JSON!) { change_multiple_column_values(item_id:$myItemId, board_id:$myBoardId, column_values: $myColumnValues) { id }}",
    variables : JSON.stringify({
      myBoardId: YOUR_BOARD_ID,
      myItemId: YOUR_ITEM_ID,
      myColumnValues: "{\"numbers28\" : \"3\"}"
    })
  })
})
curl "https://api.monday.com/v2" \
-X POST \
-H "Content-Type:application/json" \
-H "Authorization:MY_API_KEY" \
-d '{"query":"mutation{change_multiple_column_values(item_id:162169283, board_id:162169280, column_values:\"{\\\"numbers28\\\" : \\\"3\\\"){id}}\"}'

📘

Do you have questions?

Join our developer community! You can share your questions and learn from fellow users and monday.com product experts.

Don’t forget to search before opening a new topic!


Did this page help you?