Ingesting null email value in AEP using out of box field(personalEmail.address)

[Shaini_Gupta]

Is it possible to ingest null email value in AEP using out of box field(personalEmail.address).If not , how can we handle this.

[narendragandhi]

Hi @Shaini_Gupta 

You can not ingest null values in AEP. To ignore those records while ingesting you can enable partial ingestion and set an error threshold which allows you to set a percentage of allowed errors.

Please refer this document for more details - https://experienceleague.adobe.com/docs/experience-platform/ingestion/batch/partial.html?lang=en 

Thanks

Narendra

[Shaini_Gupta]

Hi @narendragandhi,

Thanks for reverting back.Actually we tried ingesting null email id on internal sandbox there it got ingested however when we are trying to replicate same on client environment we are not able to ingest null email id data even though its not primary identity or required field. Also its not that we have null email ids for all records its just for few records its null.Any possible reason which you could think might be causing it.

Thanks

Shaini 

[arpan-garg]

Hi @Shaini_Gupta - As far as i know, Its not a mandatory field, instead of ingesting null, you can do changes in your source system to not send this value if the value is null.

Thanks,

Arpan

[Shaini_Gupta]

Hi @arpan-garg ,

Thanks for reverting back.Actually we tried ingesting null email id on internal sandbox there it got ingested however when we are trying to replicate same on client environment we are not able to ingest null email id data even though its not primary identity or required field. Also its not that we have null email ids for all records its just for few records its null.Any possible reason which you could think might be causing it.

Thanks

Shaini 

[abinash-abns · Accepted solution]

Hello @Shaini_Gupta , in past I had faced the same issue while using OOTB field and the reason is email format. As you can refer, "personalEmail.address" requires value in email format. (Refer to description in the below SS for more details)

As a workaround, if you can put some Dummy data (EmailUnavailable@email.com), then you will be able to ingest without any failure. To do so, you can use the below calculated field while ingesting data:

iif(matches_regex(personalEmail.address,"[^null$]" ),personalEmail.address,"EmailUnavailable@email.com")

 Let me know for further discussion.

Thanks,

Abinash

[NimashaJain]

@Shaini_Gupta 

Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.