Hubspot database - contact owners


#1

03

Hi. I am trying to link the contacts to their owners in the database. Using the available tables ( attached) this is not possible since there is no information about owners. However it's possible for deals, since deals have a hubspot_owner_id field.

How can I link contacts to their owners?

Ideally I would want another table which links the contacts to their owners, and would prefer not to go through the API route.


#2

@Isaac_Takushi any ideas? I've been stuck on this for a while and no one at Hubspot seems to know the answer.


#4

Hi @alexhubble,

How are you accessing those tables? Have you created your own database by fetching the relevant information through the various APIs?

The only way I know to link contacts to their owners is by first pulling the owners through this endpoint and passing the desired ownerId values for the hubspot_owner_id contact property in through this endpoint (or individually).


#5

Hi @Isaac_Takushi. I am now trying to do this using the APIs. I've got the list of owners through the owners API, but can't see a hubspot_owner_id field anywhere in the contacts API. How do I extract the owner ID from the contacts API ?


#6

Hi @alexhubble,

You can pull the values for the Contact owner property through the Contacts API by including property=hubspot_owner_id in the request URL.

For example, if you are using the Get all contacts endpoint, you would use:

https://api.hubapi.com/contacts/v1/lists/all/contacts/all?hapikey=demo&property=hubspot_owner_id

If you are using the Get a contact by its vid endpoint, you would use:

https://api.hubapi.com/contacts/v1/contact/vid/{vid}/profile?hapikey=demo&property=hubspot_owner_id

Any contact property can be pulled with the property parameter.