Get all associations (contact to company) in API

Developer Support APIs & Integrations
,
1

Hi, I need to retrieve lot of data from associations tables (between contacts and companies).

I’ve been told it was now easier with the V4 of the API here : Accounts Dashboard | HubSpot.

However I can just search the associations of one precise contact by giving its ID in the API call.

Is there a way to query the full table and get all these contact - companies associations while not making 10k API calls ?

By the way I’m usually working with Hevo and I’d like to put this table in Bigquery if that helps

Thank you for your answer !

2

Hello @LMillot, thank you for posting in our Community!

I want to share this developer document about associations here and invite our top experts to this conversation to share their ideas@Chriso-mwx @weiliang_lee

Do you have any recommendations for the @LMillot matter?

Thank you,

Pam

3

Hi, I am having the same issue. Is there a way to just add the primary company association as a property to the ` v3/objects/contacts/search?` call?

Edit: for anyone else who stumbles upon this thread from Google, you can add the property “associatedcompanyid” to your Search query and get the primary Company ID associated to a contact. Helpful if you don’t care about the whole list and just need the primary association.