Bulk Update with Null Field

Queries and Resources
,
1

Trying to use a table edit to trigger a bulk update. Getting an error around not being able to set a null field when deleting a value from a table to trigger a bulk update action because it reads it as an empty string. Error below. What is the way to get around this?

  • message:"update "id" = $1, "first_name" = $2, "last_name" = $3, "email" = $4 where "id" = $5 - invalid input syntax for type uuid: """
2

Hi @nhu

Thanks for reaching out! What resource type is it (mysql, postgres, etc)?

Does it work if you .map() over the .recordUpdates array and change all of the empty strings to null?