link Marketo custom object - many to many | Community
Skip to main content
Maria_Zonk
New Participant
June 24, 2020
Question

link Marketo custom object - many to many

  • June 24, 2020
  • 2 replies
  • 3772 views

Hi, 

we have a Marketo custom object that has the top 10 product preferences for each lead. 

Fields

lead number

Prod id 1 - 

prod id 2 - 

prod id 3

etc. 

 

I would like to create email tokens using the product Id on the product preferences and adding product description, image source, and price form webshop. 

 

If I create a Product Description custom object with the following fields (Prods id, description, price and image source) 

1. Is it possible to link the two COs together? using prod ids? How do you link it?

2. Would I be able to use the product description fields in email tokens?

 

I have searched extensively on the community and cannot find examples on how to link it, 

 

Thanks  in advance, 

Maria

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

2 replies

SanfordWhiteman
New Participant
June 25, 2020

Before we get into the linking, let me say you won't be able to access the 2nd-level object from Velocity. So if that's a requirement, you don't want to go down this route.

Maria_Zonk
New Participant
June 25, 2020

Hi Stanford, 

I was afraid of not being able to use it on the tokens.

I found this discussion where you suggest to replicate all the records in the auxiliary table (your Library items) into their own Velocity token as a HashMap. 

Do you have more information on this? any reference articles to investigate? 

thanks

Maria_Zonk
New Participant
June 25, 2020
New Participant
June 25, 2020

Hi Maria

 

I'm struggling with a similar thing myself....

 

Mine is slightly different, but it might be a similar concept. What I think you would need to do is this: https://docs.marketo.com/display/public/DOCS/Add+Marketo+Custom+Object+Link+Fields#AddMarketoCustomObjectLinkFields-CreateaLinkFieldforaMany-to-ManyStructure

 

So you need an intermediary object with two fields:

 

* Person ID

* Product ID

 

Then you need the other custom object with the product ID (link field) and all the other relevant info.

 

(I think). I need to work out my own one and see how I go! Will update here if I learn any more.