Clearing a people column through the API

monday Apps & Developers
, ,
1

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 {} :slightly_frowning_face:

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
}
}
1 Like
2

What does this mean? What is column mutation?

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

3

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

1 Like
4

@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?

1 Like