I am trying to programmatically query via items_by_column_values for fields with blank values (passing “” as the value). I have tried to query for blank on the following field types: Person, Timeline, Number, and they all return no results although there are many responses:
Thanks for the response! Unfortunately this is not really a viable option for us. The board in question contains thousands of items and getting all that information back from the Monday API takes quite a long time.
For an example of scale, we’re talking something like 10 blank fields per 2000 items, and running this check periodically. It would be greatly advantageous for this and other scenarios to be able to request only items with column X is “”. Is there any intention to support this in future?
I was faced with the same issue and found a workaround :
I added a new label column named “is empty”, which is by default set to “Yes”, and an automation that sets the value to “No” when the column i’m interested in is changed. I can now filter for the “No” value on my status column.
It’s rather heavy, but at least it allows me to work around the issue.
PS: I tried first with a formula column to avoid the automation, but dynamic formula values don’t seem to be available in the API.