The numbers column holds number values (either floats or ints). Our API supports this column, so you can read and update the numbers column via the API.

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.

{
   "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\"

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\"}"
    })
  })
})

You can find the Postman request to change the numbers column here.

Clearing the numbers column

You can clear the numbers column using a change_multiple_column_values mutation.

mutation {
  change_multiple_column_values(item_id:2973227073, board_id:2973227049, column_values: "{\"numbers\" : \"\"}") {
    id
  }
}

You can also find the Postman request to clear the numbers column here.

📘

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!