owner info vs ID

mzebib68 — Fri, 24 Mar 2023 13:34:51 GMT

I'm trying to create a custom field concatenating the deal owner value bu it doesn't work.

using CONCAT([Deal owner], " test") -> it returns the owner ID instead of the name (ie. joe smith)

using LABEL([Deal owner]) -> even if the formula seems ok my dataset is empty....

any idea on how to get the owner value instead of the ID?

thanks

Re: owner info vs ID

Syeda_Fatima — Sat, 25 Mar 2023 09:02:21 GMT

Hey @mzebib68

I would suggest, use the HubSpot API to query the owner information based on the owner ID.
The endpoints for the Contacts, Companies, and Deals APIs can be used to make this request.

Let's suppose if you have the ID of the deal owner, you will have to make a GET request to the Deals API endpoint with the filter parameter to get the information about the deal owner.

Like, the following request will return the information about the deal owner with the ID of 12345:

GET https://api.hubapi.com/deals/v1/deal/12345?hapikey=YOUR_HAPI_KEY&properties=dealownerid

You should receive a response with the owner information, such as the owner name, email, and other details.

You can then use this information to create the custom HubSpot field that you need.

Hope this helps.

topic Re: owner info vs ID in Data Hub

owner info vs ID

Re: owner info vs ID