Marketo Custom Object: Lead <- Parent <- Child relationship | Community
Skip to main content
Cristian_Nanan
New Participant
September 24, 2021
Solved

Marketo Custom Object: Lead <- Parent <- Child relationship

  • September 24, 2021
  • 1 reply
  • 2756 views

The Email Scripting documentation has the following hint:
"For Marketo custom objects, you can reference second level custom objects with Parent-Child relationship.  e.g. Lead <- Parent <- Child"

https://developers.marketo.com/email-scripting/

 

How do I go about actually creating such a custom object relationship?
If I link the Parent object to the Lead, I am unable to create a link between the Child object and the Parent (does not show up as a linkable object).

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

It does let me create a junction object between the leaf and Lead but that isn't the correct relationship.

I think the confusion is you’re trying to build a relationship that (not your fault) is impossible.

 

Despite the docs mentioning a Grandparent (Lead or Company) → Child (Master) → Grandchild (Detail) schema, this isn’t implemented.

1 reply

SanfordWhiteman
New Participant
September 24, 2021
Create leaf object (child object) first. Then create the branch/junction object (parent). (I don’t like the terms parent-child as they don’t represent all many-to-one models.)
Cristian_Nanan
New Participant
September 25, 2021

Hi @sanfordwhiteman 

 

If I create the leaf object first I can't link it to its parent.

It does let me create a junction object between the leaf and Lead but that isn't the correct relationship.

 

The end relationship I need is Lead <- Invoice <- Invoice Line Item. If I create the Invoice object and link it to the Lead, I can't link the Invoice Line Item object to the Invoice. If I create the Invoice object without linking it to the Lead, I can link the Invoice Line Item to the Invoice but can't add a new link field to the Invoice after publishing. If I create the Invoice Item First I can't link it to the Invoice.

 

Overall I'm not sure how to create the "Lead <- Parent <- Child" relationship that is mentioned in the documentation.

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
September 25, 2021

It does let me create a junction object between the leaf and Lead but that isn't the correct relationship.

I think the confusion is you’re trying to build a relationship that (not your fault) is impossible.

 

Despite the docs mentioning a Grandparent (Lead or Company) → Child (Master) → Grandchild (Detail) schema, this isn’t implemented.