We recently introduced a hotfix to 2023-10 that returns "" instead of null for most empty column values when querying the text field through column_values V2. This hotfix aligns the 2023-10 behavior to what was returned in 2023-07.
Each column does NOT have the same expected behavior. It is essential to check out the column types reference to verify the expected result for each column.
The list below summarizes the expected behavior:
- Most columns will return
""if the column is empty; otherwise, they’ll return the column value as text - Mirror, connect boards, and dependency columns will always return
null - monday doc columns will always return
"" - Color picker, status, and dropdown columns will return
nullif the column is empty; otherwise, they’ll return the column value as text - Some other columns (e.g., vote) will return a default value if the column is empty