Automatic mapping failure on boolean fields during data ingestion
This article addresses the Adobe Experience Platform issue where during a CRM data ingestion, automatic mapping fails on boolean fields, and therefore, requires the use of mapper functions to resolve it.
Description description
Environment
Adobe Experience Platform
Issue/Symptoms
In this example, a CRM data ingestion includes a data flow with your customers’ master record. This record includes boolean flags about your customers’ privacy consents.
- The ingestion process is based on a batch import from an S3 bucket.
- On the CRM side, such fields can arrive as integers (0,1) or as strings (0, 1).
- When ingesting the data, all the boolean type fields have been imported in the target dataset as FALSE, irrespective of the original fields containing integer value 1 or string value 1.
Expected behaviour:
The schema-based import from an S3 bucket should properly map integer 1 and string 1 to a TRUE boolean value.
Resolution resolution
Boolean 0 or 1 is not supported. You need to use the mapper functions to convert this into boolean values.
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f