BigQuery Resource wrapping single quotes around all parameters

Queries and Resources
1

Hello,
When querying a BigQuery resource, Retool is converting all values into strings with single quotes. However, I am passing in boolean values. Is there a way to escape this conversion?

image

Thanks!

2

Hi @teamrappid, I have similar issues with setting the field to null as well. Try putting it inside {{}}.
~not sure if it works~. Otherwise, use the SQL mode for this one. Let me know if that helps.

EDIT:
Putting it in {{}} works on my end. I just tested it. I got an error here since my comment column is a string field.
retool_boolean_bq

1 Like