Hello,
I’d like to know what are the possible options to update an existing item in MDC. From API documentation I found one way to do it:
mutation {
change_simple_column_value (board_id: 20178755, item_id: 200819371, column_id: "status", value: "1") {
id
}
}
Several questions:
-
Are there other API options to make an update?
-
In the above mutation why should we provide both item_id and borad_id? (board_id can be inferred from item_id…) In our system, we want to store just item_ids in the database. So to update an item we need first to query for item’s board_id, and then call the above mutation. This is two web requests per update.
-
Is there an option to make a single or bulk update based on custom column value? For example,
mutation {
update_items(board_id: 20178755, column_id_to_look: "col1", column_value_to_look: "hello", column_id_to_update: “col2” column_value_to_update: "world") {
id
}
}
Which will update “col2” with value “world” for all items where “col1” has the value “hello”, in the mentioned board_id.
In our system, we already store custom ids to link between MDC items and DB items, so update by custom column is helpful here. And we also need to update several items in MDC per one item in our DB - would like to do it in one web request.
Thanks,
Marat