Find an item ID based on a value in a specific column

monday Apps & Developers
,
1

I’m trying to find an item ID based on the value of a column on my Board. Here is what I have but I keep getting an error:

query { items_by_column_values (board_id: 123456789, column_id:“text5”, column_value: “Sam Smith”) {
id
name
}
}

Any help for a newbie would be greatly appreciated.

2

hi @dgreensp

Welcome to the community. API call items_by_column_values is depreciated since version 2024-10. Instead you can use items_page_by_column_values (see Items page by column values) or use the query params for items_page. Something like this:

query {
  boards (ids: 123456789) {
    items_page (query_params: {rules: [{column_id: "text5", compare_value: ["Sam Smith"], operator:any_of}]}) {
      items {
        id
        name
      }
    }
  }
}
1 Like
3

Hi @basdebruin
Thank you from a Monday.com newbie!!! This works perfectly.

4

Thank you for the help here @basdebruin !!