When Creating a Data Service with an attribute of type Boolean.

On appcenter side upload a file and map the data .

[Acceptable Boolean values are 1,0, true and false]

Error message:

Conflicts and Errors: Invalid Record

bool validation failed: Cast to Boolean failed for value "TRUE" at path "bool"

Cause of error/problem:

Boolean values are given as TRUE/FALSE(uppercase). This creates error as the boolean validation fails.


Setting Boolean values as 1,0 in excel file and not as true/false as in excel it changes it to uppercase TRUE/FALSE

Affected versions:

All versions of Omni Data Platform 3.x