What is pulse-id? How to avoid this error message?

monday Apps & Developers
, , , ,
1

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”
}
}

2

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

1 Like
3

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.

4

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

1 Like
5

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 ?

6

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
    }
  }
}
1 Like
8

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.