Hello there @haseeb1431 and welcome to the community!
I hope you like it here 💪
Our team is aware of this issue and working on a fix that should be deployed this week 😀
Would you be able to please try this starting on Wednesday (15.01.2025)? It should be resolved by then. If you see this not working then, please mention me here!
Cheers,
Matias
Thanks for fixing it and taking care of it. Now I am getting the following response.
is there a limit to get the number of column with formula because otherwise query is working fine? We have around 100 columns
{
"data": {
"boards": [
null
]
},
"errors": [
{
"message": "Too many formula columns have been requested. Please reduce the number of columns.",
"path": [
"boards",
0,
"items_page",
"items",
0,
"column_values",
12,
"display_value"
],
"extensions": {
"status_code": 400,
"code": "TOO_MANY_FORMULA_COLUMNS_REQUESTED"
}
}
],
"extensions": {
"valueCompletion": [
{
"message": "Cannot return null for non-nullable field FormulaValue.display_value",
"path": [
"boards",
0,
"items_page",
"items",
0,
"column_values",
12
]
},
{
"message": "Cannot return null for non-nullable array element of type ColumnValue at index 12",
"path": [
"boards",
0,
"items_page",
"items",
0,
"column_values",
12
]
},
{
"message": "Cannot return null for non-nullable field Item.column_values",
"path": [
"boards",
0,
"items_page",
"items",
0,
"column_values"
]
},
{
"message": "Cannot return null for non-nullable array element of type Item at index 0",
"path": [
"boards",
0,
"items_page",
"items",
0
]
},
{
"message": "Cannot return null for non-nullable field ItemsResponse.items",
"path": [
"boards",
0,
"items_page",
"items"
]
},
{
"message": "Cannot return null for non-nullable field Board.items_page",
"path": [
"boards",
0,
"items_page"
]
}
]
}
}
Also, may be I am not aware, but I am not sure if there is a way to filter columnValues and say give me first 50 columns and then give me rest of them.
display_value is not returning values for formulas using API “2025-04”
Hi @richard.ekstrand,
Can you send your query please? I ran the query below, and it successfully returned the formula in the display_value field.
{
items(ids: 123456) {
column_values {
... on FormulaValue {
display_value
}
}
}
}
Best,
Rachel
@rachelatmonday
Not working still for me today. For example, this query:
query {
items (ids: [9105478229]) {
name
column_values {
id
column {
title
}
value
}
}
}
should return a value of “5” but instead is null for the column with id “formula_mkqs51dt” and title “Length in Mins”. (It’s a column calculating number of minutes between two date/time cols)
@jk193 try adding this bit?
