Numbers
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!
Updated 3 days ago