Pulling Custom Object data using Velocity Script not working

[Elsa_Man3]

We have data stored in a SFDC custom object that is 2 levels down to the Contact record (Contact --> Purchaser Profile --> Ticket) and according to Marketo, that SHOULD pull through in Velocity Scripting (it's only 3 levels down that's a no-go). But we aren't able to for some reason. 

But if we go try to pull 2 levels down through a different route (Contact --> Order --> Order Line Item) we are successful. 

The only difference I can see from pulling data from Ticket vs Order Line Item, is that the Ticket is a Look-up relationship to Purchaser Profile, whereas Order Line Item is a Master-Detail relationship to Order. Does anyone know if that makes a difference? 

Thanks in advance!

[SanfordWhiteman]

That's exactly what makes the difference.

[Elsa_Man3]

thanks Sanford! I should note that the Contact --> Order is a Lookup relationship too, but we are able to successfully pull in fields from the Order object. Does the anti-lookup rule not apply here because it's directly tied to the Contact?

[SanfordWhiteman · Accepted solution]

Yep!

[Elsa_Man3]

thank you (again!) 😊