Monday API items_page_by_column_values filter items by URL

monday Apps & Developers Feature Requests - API and Apps Framework
,
1

Is there any way to filter the item by URL of the item, using this verb: [items_page_by_column_values], i tried this query see:
{
“query”: “query { items_page_by_column_values (limit: 1, board_id: some_board_id, columns: [{column_id: "link7", column_values: ["https://www.google.com"]}]) { cursor items { id name group { id title } column_values { id type text value … on StatusValue { index text type label value label_style { border color } } } } } }”
}

But it is not returning anything?

2

hi @qadeerdev

Not sure about items_page_by_column_values as I always use the query_params in the items_page. Below code is working fine but keep in mind the note on Link column reference, showing:

*Please note that you can use either the URL or display text when using the any_of, not_any_of, contains_text, or not_contains_text operators, but it must match whatever is in the UI. For example, if the item just has a URL without display text, you can search by the URL. If display text is present, you must search by that and not the URL.

{
  boards(ids: [123456789]) {
    items_page(
      query_params: {rules: [{column_id: "link_mkmpghbf", compare_value: ["https://www.google.com/"], operator: contains_text}]}
    ) {
      items {
        id
        name
        group {
          id
          title
        }
        column_values {
          id
          type
          text
          value
          ... on StatusValue {
            index
            text
            type
            label
            value
            label_style {
              border
              color
            }
          }
        }
      }
    }
  }
}
3

Thank you so much, I appreciate your valuable feedback,