Are referenced fields available in AJO journey | Community
Skip to main content
Level 3
January 7, 2025
Solved

Are referenced fields available in AJO journey

  • January 7, 2025
  • 1 reply
  • 553 views

Hello Team,

 

I would like to understand, is it possible to get the reference field from lookup dataset in AJO journey?

we have one individual profile schema with abandon cart data and one product catalog schema with custom class.

 

We have created a relationship between fields prod_id of both schema. 
will I be able to see fields from product catalog schema in AJO Journey.

 

Best answer by Mohan_Dugganab

You can leverage datasetLookup helper which is currently in Beta https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalization/lookup-aep-data for your case

1 reply

Mohan_Dugganab
Adobe Employee
Mohan_DugganabAdobe EmployeeAccepted solution
Adobe Employee
January 7, 2025

You can leverage datasetLookup helper which is currently in Beta https://experienceleague.adobe.com/en/docs/journey-optimizer/using/content-management/personalization/lookup-aep-data for your case

ShivaniMAuthor
Level 3
January 8, 2025

Thank you so much, it helped me.

I have one more question, prod_id field (from individual profile schema) is in an array and lookup field prod_code is normal field.

I have tried some ways, like xyz.object.0.prod_id and xyz.object.prod_id.0 but unable to get the value in email, it is reflecting as blank.

What is the correct way for this syntax.

{{datasetLookup datasetId="123456789121212" id=profile.xyz.AbandonCart.XYZ.PROD_ID result="store" required=false}}

{{store.xyz.ProductCatalog.coffeeName}}

here, prod_id is part of array field XYZ.
Do you have any idea around it.