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.
Workaround:
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