Does the monday API support updating records based on a value in column?

Let’s say we create a board called Random-Name inside Monday. In this table we would have a column called Random-Name-ID. If we want to update these records we must be able to do something like (pseudo code)

UPDATE Random-Name SET status = "Done" WHERE Random-Name-ID = 1234;

Does the Monday API support updating records based on a value in a column?

Hey @SerhiiDiukarev – try the items_by_column_values query! It will return a list of items with a given column value (exact match). You can then use the column IDs to update them.

Check out the docs here.

1 Like

can I then use the column IDs to update all those items in one operation? if yes, how?

Our API doesn’t support batch actions or updating multiple items in one query. You will need to iterate through them for now.