How to reconcile data from an event with data from a customer profile from CDP

[user77095]

We have a Journey in AJO that is an event based audience. In our full data model, customers can have multiple accounts. Within the event, it tells us which account the customer is using to trigger the event.

However before sending the e-mail we need to execute an account eligibility check (i.e. check our account level suppressions) by reconciling that account with the account data in the customer real time CDP / AEP.

What type of syntax or how can we pull the account from the event then use that account to compare against the customers CDP/AEP profile?

[Mayank_Gandhi]

@user77095  In AJO you can reference both the fields that arrived in the triggering event and the arrays that live on the real-time profile inside the same Condition node. Considering that the profile must store the accounts as an array field (object or string) so the Condition node can reach them.  If the accounts only live in a separate dataset you will need to bring them onto the Profile or send them in the event. Then you can try following approach.
1.  read the account identifier that sits in the event payload, and
2.  look through the profile-level array of accounts to see whether that same account is flagged as ineligible / suppressed.A pattern looks like this:

/* event object contains a single accountId */
var thisAccountId      = event.account.accountId;

/* profile array: accounts[ ] each has id + suppression flag */
exists(
        filter(profile.accounts,
               a -> a.accountId == thisAccountId && a.suppressed == true)
      )

[user77095]

@Mayank_Gandhi 

We will try this. Is this using the advanced mode in the condition?

Is it possible to do if the even also has multiple accounts? Some customer may receive the event for say 2 out of their 3 accounts because the first two accounts are active while the 3rd account is closed.

The event is also an array

[user77095]

We tried inputting the code and got errors. Does it look like we are implementing it right?

[Umamaheswari_Yakkala]

This syntax wont work. Please refer to this page https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalizatio... for the AJO helper functions

Thank You

[Sukrity_Wadhwa]

Hi @user77095,

Was the given solution by @Umamaheswari_Yakkala helpful to resolve your query or do you still need more help here? Do let us know. In case the given solution was helpful, then kindly choose it as the 'Correct Reply'.

Thanks!