topic Re: crm_associations HubL function not working; CRM API works in APIs & Integrations

crm_associations HubL function not working; CRM API works

SPatterson8 — Wed, 23 Aug 2023 00:13:41 GMT

I have a quote template which is using the crm_associations function to return a list of contacts for the current deal by an association label. I can list the associations between records via the rest api but not via the HubL function.

Here is a simplified example (

deal.hs_object_id = 10544008363
contact.hs_object_id = 52486601

) :

{% set deal =template_data.quote.associated_objects.deal %}
{% set associations = crm_associations(deal.hs_object_id, "USER_DEFINED", 35) %}
{{associations|pprint }} %}

OUTPUT:

(CrmObjectList: {hasMore=false, offset=0, results=[], total=0})

CRM data via the rest api shows the association is there.

Association type id 35 is defined for deals to contacts.

https://api.hubapi.com/crm/v4/associations/deal/contacts/labels
{
"results": [{
"category": "USER_DEFINED",
"typeId": 40,
"label": "myLabel1"
}, {
"category": "USER_DEFINED",
"typeId": 41,
"label": "myLabel2"
}, {
"category": "HUBSPOT_DEFINED",
"typeId": 3,
"label": null
}, {
"category": "USER_DEFINED",
"typeId": 35,
"label": "myLabel3"
}, {
"category": "USER_DEFINED",
"typeId": 33,
"label": "myLabel4"
}]
}

There is a specific association between the two record ids I queried in the crm_associations function.

https://api.hubapi.com/crm/v4/objects/deal/10544008363/associations/contact
{
"results": [{
"toObjectId": 52486601,
"associationTypes": [{
"category": "USER_DEFINED",
"typeId": 41,
"label": "myLabel2"
}, {
"category": "HUBSPOT_DEFINED",
"typeId": 3,
"label": null
}, {
"category": "USER_DEFINED",
"typeId": 35,
"label": "myLabel3"
}, {
"category": "USER_DEFINED",
"typeId": 33,
"label": "myLabel4"
}, {
"category": "USER_DEFINED",
"typeId": 40,
"label": "myLabel1"
}]
}]
}

Same results when I tried a different association type. Present in the rest api but not in the HubL function.

{% set deal_ass = crm_associations(DEAL.hs_object_id, "HUBSPOT_DEFINED", 3) %}

OUTPUT:

(CrmObjectList: {hasMore=false, offset=0, results=[], total=0})

Any help troubleshooting would be greatly appreciated.

Re: crm_associations HubL function not working; CRM API works

GRajput — Wed, 23 Aug 2023 10:20:58 GMT

Hi @SPatterson8

Please follow the following instructions.

1. Firstly go to deal and in right side bar you can see contact detail.

2. In contact details, Click more link shown in screenshot below:

3. Now click on edit association and select label shown in screenshot below,

Now your hubl code will return required output.

Hope this will helps you out. Please mark it as Solution Accepted & Upvote to help other Community member.
Thanks!

Re: crm_associations HubL function not working; CRM API works

SPatterson8 — Wed, 23 Aug 2023 12:27:53 GMT

That step was already completed. I edited the association labels of the contacts and added 4 associations labels. Those are the 4 associations which are returned via the rest api when a GET objects/deal/<id>/associations/contact. The issue I'm seeing is those associations are not returned by the HubL function.

Re: crm_associations HubL function not working; CRM API works

edytajordan — Thu, 26 Sep 2024 05:17:33 GMT

Hello OP,

For security purposes, of the HubSpot standard object types only the product, and marketing_event objects can be retrieved on a publicly accessible page. Any other standard object type must be hosted on a page which is either password protected or requires a CMS Membership login. Custom objects do not have this same restriction.