Query on mirror columns no longer works

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

I have this piece of GQL that used to work since the introduction of 2023-10 however it stopped working a week ago. I noticed that the this way did not change on 2024-11.
{query:
boards(ids: xxxxx) {
name
items_page(
limit: 10
query_params: {rules: [{column_id: “mirror5”, compare_value: [0], operator: greater_than}], operator: and}
) {
cursor
items {…

the error I am getting is:
{
“error_message”: “This column type is not supported yet in the API”,
“error_code”: “InvalidColumnTypeException”,
“error_data”: {
“column_id”: null,
“actual_type”: “lookup”
},
“status_code”: 200,
“account_id”: xxxx
}

similar erro happens if I use 2024-10
{
“errors”: [
{
“message”: “This column type is not supported yet in the API”,
“locations”: [
{
“line”: 1,
“column”: 38
}
],
“path”: [
“query”,
0,
“items_page”
],
“extensions”: {
“code”: “InvalidColumnTypeException”,
“status_code”: 200,
“error_data”: {
“column_id”: null,
“actual_type”: “lookup”
}
}
}
],
“status_code”: 200,
“error_data”: {
“column_id”: null,
“actual_type”: “lookup”
},
“error_code”: “InvalidColumnTypeException”,
“error_message”: “This column type is not supported yet in the API”,
“account_id”: 6275190
}

any ideeas?

3

Hello there @alexmatei and welcome to the community!

I hope you like it here :muscle:

Our API documentation states that filters on mirror + formula columns are not supported. However, this restriction was not previously enforced, allowing some customers to utilize this functionality. On November 6, we implemented a change to enforce this restriction, but we recognize that this was done without prior communication. We did promptly roll this back and release planned communication to accounts we saw had a dependence on this feature (more than 50 api calls per week).

Now this enforcement has been re-released to all accounts who had usage under this limit and will be released to all other accounts in the coming few days. As a note, we do not recommend using any undocumented features or capabilities within the API as these are not guaranteed or supported by the monday.com team.

Cheers,
Matias

4

Thank you Matias for this info. I have since seen the documentation where it stated that mirror or formula were not supported. I have pivot to a new query that is supported, albeit there is now an extra manual process.

5

Thank you for the confirmation and the flexibility @alexmatei !