Hi Retool Community,
I've been struggling all day to resolve an issue related to handling empty arrays in a BigQuery query within Retool, and I'm hoping to get some guidance from the community.
No matter what approach I take, I keep encountering the following error: "Parameter type must be provided for empty array values."
I've tried various workarounds, including conditional logic, using UNNEST
, and even attempting to bypass the filter when the array is empty, but nothing seems to work.
Here’s a bit more context:
- I’m working with multiselect dropdowns, and I need to filter a dataset based on the selected values. However, when the selection is empty, BigQuery throws the error mentioned above.
- I’ve tried transforming the arrays and using JavaScript to conditionally build the query, but the error persists.
- I understand that BigQuery requires a type for empty arrays, but I’m not sure how to handle this within the Retool environment.
Has anyone else encountered this issue? How did you manage to resolve it? Any tips, suggestions, or solutions would be greatly appreciated!
Thanks in advance for your help!