Relationship data from lookup table to be used in AJO

[Nick_2024]

Hi, 

is it possible to retrieve the information from a relationship established with a lookup schema into a journey? 

In the specific i have an id on a profile schema, this id is related to a lookup entity with further details, such es color, price etc. Can i retrieve the details of the lookup into a journey using for example the data in a custom action? 

Then how is it possible to check that the relationship worked good? 

Thanks!

[dugganab · Accepted solution]

Hi,

Kindly refer to this documentation

https://experienceleague.adobe.com/docs/journey-optimizer/using/configuration/configure-journeys/eve...

[Nick_2024]

Thanks! however i have tried with a lookup related to a profile schema and this doesn't seem to appear in my custom action definition

[SatheeskannaK]

@dugganab You won't be able to use the lookup schema in the custom action when you have read the audience/segment qualification based journey. If you're having a journey that uses event you should be able to see the lookup schema by switching to advanced mode .

[dugganab]

right, the documentation link I pointed to, was referring to a schema of type XDM ExperienceEvent class indeed. 

[geravishal]

We have a similar use case where we have an attribute on our profile which has relationship with another dataset, how can we fetch the attribute of other dataset? 

Example Our profile has a store number and we need to fetch storename from another Store dataset 

{{profile._client.enroll_store_number}}