Skip to main content

Clearing a people column through the API

  • March 17, 2022
  • 3 replies
  • 1992 views

basdebruin

Clearing a column is as easy as sending a “” to it, don’t forget to JSON.stringify it.

Except for long-text and people column where you need to send {} 🙁

That was until recently. Somewhere beginning of March the people column can’t be cleared in this way. You need to do a column mutation:

mutation {
  change_column_value(
    board_id: 1111111111, 
    item_id: 1122334455, 
    column_id: "person", 
    value: "{\\"removed_person_or_team\\":{\\"id\\":12345678,\\"kind\\":\\"person\\"},\\"persons_and_teams\\":[{\\"id\\":12345678,\\"kind\\":\\"person\\"}]}"
 ) {
    id
  }
}

EDIT: luckily there is another (undocumented) way to clear completely:

mutation {
change_column_value(
  board_id: 1234567, 
  item_id: 112233445566, 
  column_id: "people", 
  value: "{\\"clear_all\\": true}"
) {
  id
}
}

3 replies

onurbolaca
  • Participating Frequently
  • February 9, 2023

What does this mean? What is column mutation?

I use make.com to migrate data. And it doesnt accept empty values


basdebruin
  • Author
  • Community Expert
  • February 9, 2023

To clear a people column, you have to send "{\\"clear_all\\": true}" to the column.


JCorrell
Forum|alt.badge.img
  • Community Expert
  • February 9, 2023

@onurbolaca

When using Make, some of the edge cases are best handled by calling the API directly by using the Make monday module “Execute a GraphQL Query”. This is the case here. You can use the basic syntax that Bas gave you to construct the GraphQL call.


Jim - The Monday Man
We Create Custom Apps, Integrations & Automations for monday
What is Make & How can it help you with monday?