Ingesting null email value in AEP using out of box field(personalEmail.address) | Community
Skip to main content
S
Shaini_Gupta
Level 2
February 21, 2024
Solved

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

  • February 21, 2024
  • 4 replies
  • 2044 views

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

    Best answer by abinash-abns

    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

    4 replies

    narendragandhi
    Community Advisor
    narendragandhiCommunity Advisor
    Community Advisor
    February 22, 2024

    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

      S
      Shaini_GuptaAuthor
      Level 2
      February 22, 2024

      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
      Community Advisor
      arpan-gargCommunity Advisor
      Community Advisor
      February 22, 2024

      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

      S
      Shaini_GuptaAuthor
      Level 2
      February 22, 2024

      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 

      A
      abinash-abnsAccepted solution
      Level 2
      February 27, 2024

      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
        Adobe Employee
        NimashaJainAdobe Employee
        Adobe Employee
        March 15, 2024

        @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.

        Terms & ConditionsAccessibility statement

        Loading footer...