Wix bulkInsert not inserting 0 or false values into Google Cloud SQL (Postgres)

Ask the community
, ,
1

I’m using wixData.bulkInsert to insert records into a Google Cloud SQL (Postgres) database. The issue is that numeric 0 and false values are not being saved, even though they are present in the final object sent to the bulkInsert method.

Here’s an example object:

{
  "product_id": "442667902",
  "delivery_rate": 0,
  "is_black_listed": false
}

In the database, delivery_rate and is_black_listed become NULL. Why does this happen, and how can I ensure 0 and false are inserted correctly?

Is this due to Wix or SQL, and how can I fix it?