topic V3 API to List Contacts with Associated Company Name in APIs & Integrations

V3 API to List Contacts with Associated Company Name

KChan — Wed, 08 Sep 2021 08:18:10 GMT

I am looking for a way to list all contacts with the associated company's name.

I can find the "Associated Company" column in HubSpot dashboard contact list table below.

However, I couldn't find a property like this for the API.

In V3 official guide https://developers.hubspot.com/docs/api/crm/contacts there are contact association-related APIs. But those can only query the association of 1 contact at a time. I need to list all contacts with their associated company.

Thanks.

Re: V3 API to List Contacts with Associated Company Name

dennisedson — Wed, 08 Sep 2021 18:27:08 GMT

@KChan

Add a query param to your request associations=companies

https://api.hubapi.com/crm/v3/objects/contacts/?associations=companies

This should return an array of company ids

Re: V3 API to List Contacts with Associated Company Name

KChan — Thu, 09 Sep 2021 03:19:07 GMT

Thanks. It works!

Last question, is it possible to get the company name, instead of the id?

Thanks.

Re: V3 API to List Contacts with Associated Company Name

webdew — Thu, 09 Sep 2021 12:46:50 GMT

Hi @KChan ,

You can use this api for get contacts of list.
Link :
https://legacydocs.hubspot.com/docs/methods/lists/get_list_contacts_recent

Screen shot :
https://prnt.sc/1rll2qk

For the contact association use this :
Link :
https://legacydocs.hubspot.com/docs/methods/crm-associations/get-associations
Screen shot :
https://prnt.sc/1rll5uz

Table of association defination ids.
https://legacydocs.hubspot.com/docs/methods/crm-associations/crm-associations-overview
https://prnt.sc/1rll7jc

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: V3 API to List Contacts with Associated Company Name

dennisedson — Thu, 09 Sep 2021 17:32:27 GMT

@KChan , you will need to fire a new request to get the names using the batch read endpoint:

/crm/v3/objects/companies/batch/read

Re: V3 API to List Contacts with Associated Company Name

HBaghdasaryan — Thu, 08 Aug 2024 20:36:20 GMT

@dennisedson This is helpful. But is there a way to make the object search API respect the "associations" param?
Or if it may result in performance issues the API could allow fetching specific related fields that are highly relevant (e.g. company name) which can somehow be colocated and indexed on database level.