{
items(ids: [123456789]) {
id
name
column_values(ids: [“date”, “label”, “formula”]) {
id
text
column {
title
}
… on FormulaValue{
display_value
}
}
}
}
But once I send it via the API I get an error about the display_value.
Body being sent:
{“query”: “{ items(ids: [123456789]) { id name column_values(ids: ["date", "label", "formula"]) { id text column { title } … on FormulaValue { display_value } } } }” }
Error Received:
{“errors”:[{“message”:“Cannot query field \“display_value\” on type \“FormulaValue\”.”,“locations”:[{“line”:1,“column”:144}]}]}
Anyone have any idea what’s going on here and how to fix it? To my knowledge, the FormulaValue display_value option is the only way to get the result of a formula out of Monday.com.
No, I’m not specifying a version in my API call, so it’s using the current one.
One more clarification, the item with the formula is a subitem and that subitem DOES have the “formula__1” column. I could see this error occurring if no Formula column was present. I can confirm in this case, there is a Formula column.
My work around was to recreate the formula in a Zapier Code block, since I had all the information to do that already. However, this is bad practice, because now that formula is in multiple locations that have to both be updated if it needs to change.
I have confirmed that this problem does NOT happen in version 2025-01.