Hubspot database - contact owners

[alexhubble]

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.

[IsaacTakushi · Accepted solution]

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.

[SAhmed01]

I want to get all contacts which I am getting with 

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

but now I want to have its owner too, can you answer it ? Thanks

[SAhmed01]

Hi,

But if I request at 

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

What is "hubspot_owner_id" here , ? it is undefined , from where can I pass its value to request ?

Thanks

[EHuebia]

Hi, I am also interested in this topic. Is there an updated solution?

What I would like to do create a site where our admin can add owners by just manually adding the Owner ID. Once envoked, a list of all contacts will be displayed. 

[dennisedson]

Hey @EHuebia ,

Could you add a bit more detail to what you are trying to accomplish 😄

Is the admin  using the API or working within the user interface?

[EHuebia]

Hi, we have an external site. We would like to capture are a few things:

1. See a listing of all the Contact Owners and display in a tabular format.   I don't need all the properties, related to the Contact Owner. I'd like to pick and choose the fields I want in the listing.

2. When I click on one of the Contact Owners, a listing of all the Contacts for the Contact Owners will appear. Again, I only want certain fields in the table.

3. When I click on one of the Contacts, the information about the contacts will appear with only the fields I want to display.

Sorry, not a developer, just a layman. 🙂

Thank you!

[IsaacTakushi]

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).

[alexhubble]

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 ?

[alexhubble]

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