Parameter types must be provided for null values via the 'types' field in query options

Queries and Resources
, , , ,
21

I hear you! I let the engineer in charge know.

Thank you everyone for the feedback, +1s and context shared; this truly would not have been prioritized without all of it.

I may have good news to share soon :eyes:

22

I'm also waiting for a good news on that issue. :slight_smile:

23

+1 on this getting resolved. New user for Retool and this is a real bummer

24

Hello everyone! I have exciting news. We've updated the error message to include the correct syntax. :tada: :eyes: :tada:

{{ {RT$BQ_TYPE: 'STRING', value: null} }}

Error:

26

This one is a super cumbersome workaround which results in gray hairs. There's no reason why NULL's should not be supported (that's just weird). Hope you guys can fix the issue natively.

27

Definitely valid. Noted internally!

28

How to insert empty array into a field when using bulk insert?

TL;DR

I'm getting the same error when trying to insert empty array values to a field. I've tried everything: [], {RT$BQ_TYPE: 'ARRAY', value: null}, {RT$BQ_TYPE: 'ARRAY', value: []}, {RT$BQ_TYPE: 'STRING', value: null} - nothing works. I've tried in SQL mode as well as GUI mode. What to do?

29

Hey @merualbert! Would you mind sharing a screenshot of your current query? :slight_smile:

31

@merualbert Can you try this, where you can replace 'STRING' with the type of the element in the array

{RT$BQ_TYPE: ['STRING'], value: []}