Skip to main content

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

  • May 22, 2020
  • 3 replies
  • 1884 views

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?

This topic has been closed for replies.

3 replies

dipro
Forum|alt.badge.img
  • Leader
  • May 22, 2020

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.


  • Author
  • Participating Frequently
  • May 26, 2020

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


dipro
Forum|alt.badge.img
  • Leader
  • May 28, 2020

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