Enable to fetch or retreive Record Custom Object from contact

[thibauls]

Hello, I would like to know if it is currently possible to display in an email for a contact the list of all records associated with a custom Object.

I give you an example: Let's imagine that I have a list of contacts. These contacts have an association with a Custom Object named CARS. Each contact can then be associated with one or more cars.

In an email, I would like to display the list of all vehicles for this contact.

Normally, in programming in any language, I would simply do what is called a FETCH on the CARS Custom object and make sure to display only the CARS for a contact from the contactID.

Example : Select * FROM CARS where contactID = 1234

I have searched the hubspot documentation and I can't find anything that allows me to do this in API or HUBL or CRM.

Could you please confirm that this is not possible or give me the necessary documentation to do a FETCH or RETREIVE of a Custom Object for a single contactID.

[LMeert · Accepted solution]

Hi @thibauls,

You will have to use HubL to get the associated records for a contact, and more precisely the CRM associations method.

Getting associated records should be easy enough for you once you have access to the correct method/syntax !

Hope this helps !
If it does, please consider marking this answer as a solution 🙂

Best,

Ludwig

[Jaycee_Lewis]

Hi, @thibauls 👋 Thanks for reaching out. Let's see if we can get the conversation started. Hey, @Anton @LMeert @BarryGrennan, have you tackled anything similar?

Thank you for taking a look! — Jaycee