Skip to main content

If I use an ID column in the following query then it gives me an error. All other columns are fine. I do not have any other unique feature in the board to search by, only ID. How do I fix the error?

{

items_page_by_column_values(

board_id: XXX

columns: [{column_id: “item_id”, column_values: “YYY”}]

) {

cursor

items {

name

column_values(ids: “status”) {

value

text

}

}

}

}


This is the error that I get:

{

“error_code”: “UnsupportedItemsByColumnValueQuery”,

“status_code”: 200,

“error_message”: “Column of type pulse-id is not yet supported as a filter”,

“error_data”: {

“column_id”: “item_id”,

“column_type”: “pulse-id”

}

}

hi @np6np6


Welcome to the community! The column type for the “Item ID” column is “pulse_id”, that is because monday was previously called DaPulse and items were called pulses.


As the error shows, this column_type does not support filter arguments. Many people create their own id in a text column to overcome this. Check out this app monday.com: Apps Marketplace

This was not an issue before.

I was able to use id column. My queries worked for any column type.


Now, why do I need to have a duplicate column for IDs in text-version? I do not see any automation that will populate that column with an ID value upon creation.

The column type pulse_id (or item_id as it is called now) never supported filter arguments. See Item ID

I had to update my working queries with your last update.


Now I just need to have a solution. I am reluctant to create a text-copy of IDcolumn.


I do not care what the query I use, but I need to be able to retrieve a row by its ID and the boards ID.


How do I do it now ?

Not sure what you refer to as “my last update”. If you jyst need the column values and you know the itemId the most basic query is:


{

  items(ids: 123456789) {

    column_values {

      id

      value

      text

    }

  }

}

I have the same error using API v2. I didn’t have an issue with API v1. I can’t even create a formula column off of the ID because formula columns aren’t supported as a filter, either.

Reply


Terms & ConditionsCookie settings