Is there a junction between Tasks and Calls/Activities to key off of?

AMoyse — Wed, 10 May 2023 18:50:01 GMT

Hello! I am currently working on ingesting CRM data and I am struggling to find a way to link a task to any activity that isn't a task.

When querying tasks I am pulling -

'hs_object_id', 
'hs_createdate', 
'hubspot_owner_id', 
'hs_task_status', 
'hs_task_subject',
'hs_task_type', 
'hs_task_completion_date',
'hs_num_associated_deals', 
'hs_engagement_source', 
'hs_engagement_source_id'

The object id of the task isn't linked to the activity that it spawned. Meaning if task id 123456789 triggered a call, the call id will not be 123456789. Then looking at the call / email / other activity endpoints, there isn't a way to link back either. In fact, the engagement source and engagement source id is different between the task and the call.

Tasks show the engagement source being "sequence" and calls show it being "api" (which I assume is Hubspot's internal API linking the sequence to an action).

I then went to look at the contact to try and grab something that would allow me to query back and forth, but I can't find a comprehensive list of engagement ids that link the tables.

Re: Is there a junction between Tasks and Calls/Activities to key off of?

Jaycee_Lewis — Thu, 11 May 2023 18:06:35 GMT

Hi, @AMoyse 👋 Thanks for reaching out.

The issue you're encountering is because in HubSpot's data model, engagements like tasks, calls, or emails are not directly associated with each other. They're linked to CRM objects like contacts, companies, etc., but not between themselves.

You can retrieve the type ID between objects and engagements by making requests to this endpoint — Retrieve association types GET /crm/v4/associations/{fromObjectType}/{toObjectType}/labels

Please note, engagement types are unidirectional, so you'll need to make separate calls to get the IDs for Notes > Contacts vs Contacts > Notes

Best,

Jaycee

topic Is there a junction between Tasks and Calls/Activities to key off of? in APIs & Integrations

Is there a junction between Tasks and Calls/Activities to key off of?

Re: Is there a junction between Tasks and Calls/Activities to key off of?