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?
Hello there @alexmatei and welcome to the community!
I hope you like it here 
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
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.
Thank you for the confirmation and the flexibility @alexmatei !
@alexmatei can you confirm to me that you also now had to extract all the results without mirror and formula filters and then apply filters at the level of your code? or did you find another way to do the filtered API call?
thanks a lot