Why monday has unsupported columns like ITEM ID for searching using automation platforms like make.com?

The item ID is the item ID. If you want the item for an item ID by API… you don’t need to search by item ID. The item ID column just shows the user the item ID in the browser easily. For purposes of automations or make, just use the item using the ID. Why use the find by column value when its an expensive (complexity wise) operation, when just getting the item directly by ID works?

{
  items(ids: "12312312312"){
    name
  }
}

I am getting Item by search on Board B where it is mirrored. As only item ID is unique.

There is no limitation here, this works. mirror_1 column is a mirror of an item ID column on another board in the query below. items_by_column_value is deprecated so you should not be trying to use it since it will cease to function at all on January 15, 2024. Using items_page works just fine. I suspect items_page_by_column_value will as well but didn’t test it. Don’t forget to set your API Version to 2023-10 of course to use items_page and items_page_by_column_value.

{
  boards(ids: 123123123123) {
    items_page(
      query_params: {rules: [{column_id: "mirror_1", compare_value: ["324234234"], operator: any_of}]}
    ) {
      items {
        id
        name
      }
    }
  }
}

the response i get is below, and that is the item i would expect to find.

{
  "data": {
    "boards": [
      {
        "items_page": {
          "items": [
            {
              "id": "244234234",
              "name": "Test Item"
            }
          ]
        }
      }
    ]
  },
  "account_id": 123123
}

Is this Items api supported with the new api or do I need to use items_page?

you can use a root query of items without items_page, but if you want to get the items from a board or group, items_page is required within the board or group part of the query, then items within items page. Items page controls pagination. Items page

The queries with items_page require the new API version.

Here is a items root query example, if you didn’t specify ids you’d get 100 randomish items (probably the 100 oldest items). Not very useful. So an items root query like this is really only useful if you’re specifying item IDs - since there is no reason to go through the complexity of querying the board and items_page since you know what items to get already. (often just one item)

{
   items(ids:123123123){id, name}
}