Dataset lookup in AJO not working

[arpan-garg]

Hi Team,

Recently a new feature was introduced in AJO which allow you to lookup aep data while targeting customers via email. https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalizatio...

I created a profile schema and a lookup schema address both enabled for profile plus also created datasets for both(also enabled for profile). Profile is linked to address lookup via a address id. In audience creation, i see that profile is linked to address properly (i can see all fields of address lookup when i select profile attribute which means the relationship is set properly).

However in AJO when i send an email to the customer and fetch his address details via the address id , i always get empty address.

Did anyone tried this already?

Just for information: I have already enabled dataset for lookup as mentioned on the document 

Thanks,

Arpan

[Ivan_Mironchuk]

HI @arpan-garg -

Couple of questions. 

1) Does your schema have "addressID" set as the primary identity? 

2) Do you have unique "addressID" for each row in the dataset? 

3) When you used the API call to enable your dataset for lookup did you get a Success 200 message returned? 

4) When using the function in personalization editor did you get any validation errors? 

5) Did you make sure to use the full path from the schema when referencing the fields of data you wish to bring in? 

6) You can set the dataset look expression to be required="true" which should result in an exclusion if a match is not found.

7) Did you try putting in a static key into the expression to see if you can just get a match to work? 

Make sure that if you are using a dynamic attribute for the ID that you remove the quotes. i.e. id=profile.customer.addressID. if you have id="profile.customer.addressID" it will look for this static value and find no results. 

[arpan-garg]

@Ivan_Mironchuk ! Your last suggestion, to avoid surrounding the id with quotes, helped me resolve the issue—I was making the same mistake. However, I would greatly appreciate it if Adobe could address this inconsistency in their documentation. In this guide, it is still mentioned to use quotes.

Regarding your second point about ensuring only unique entry exists for each address ID, I encountered a scenario where a customer's address changed from Texas to Arizona. However, the lookup always returns the old address (Texas). How can this situation be managed? Lookup functionality will only be truly useful if it fetches the latest data from the dataset, rather than the first record.

What do you suggest?

[Ivan_Mironchuk]

Can you DM me with further details on how you are replacing the data in the dataset? 

[arpan-garg]

Sent

[arpan-garg]

@Ivan_Mironchuk  - One more question, does the functionality of data set lookup actually require a relationship to be set between the profile and address. Or will this work without even establishing a relationship?

[Ivan_Mironchuk]

No relationship required. Dataset does not need to be enabled for profile.