Error on import csv to database

Hello,

I am getting this error on CSV import

Hi @Mia_Mathews ,

It seems like you are trying to insert an empty string for a column with type boolean -- can you double check what payload you are providing to the request?

Hey @Mia_Mathews

This error occurs in PostgreSQL because an empty string ("") is being used where a boolean (TRUE or FALSE) is expected.

Check if your CSV import includes text or an empty string for a field that is expected to be boolean. You might be passing a string instead of TRUE or FALSE.

1 Like