Skip to main content
Shaini_Gupta
Level 2
February 21, 2024
Solved

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

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

    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

    View in thread

    6 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

    Translate
      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 

      Translate
      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

      Translate
      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 

      Translate
      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

      Translate
        NimashaJain
        Community Manager
        NimashaJainCommunity Manager
        Community Manager
        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.

        Translate
        Terms & ConditionsAccessibility statement

        Loading footer...