Deal Owner

Developer Support APIs & Integrations
1

When trying to push deal information NetSuite to Hubspot, we receive an error message that Rep Name (in this test case me)

Janelle deRocquigny was not a valid hubspot_owner_id as it contains whitespace(s).

It seems as though the hubspot_owner_id is looking for the internal value to be pushed and doesn’t seem to accept the Label name which matches NetSuite. we were able to have this work with our previous integration.

2

Using Boomi to integrate Netsuite and Hubspot. the deals are a 1 way push from NetSuite to Hubspot. When trying to push over the Contact owner information, we get the following error. "

Janelle deRocquigny was not a valid hubspot_owner_id as it contains whitespace(s).

If we use the internal ID for the API, how would that work as NetSuite’s Sales Rep ID won’t be the same as HubSpot’s Contact owner internal value ID. We had it working before with a different integration tool and can’t seem to figure out why we can’t get it tow rok here. It’s my understanding that we did not have a translation table set up previously either.

3

Hey @JdeRocquigny,

HubSpot requires you to pass through the internal ID of the owner. These can be obtained by calling GET
/crm/v3/owners/ which is available under the Owners API. It’ll return something similar to the below containined the “id” which you can then pass as a value for the “hubspot_owner_id” in your request to create/update a record.

{
 "results": [
 {
 "id": "421550280",
 "email": "brucebanner@marvel.com",
 "firstName": "Bruce",
 "lastName": "Banner",
 "userId": 25373625,
 "createdAt": "2022-08-03T13:27:20.694Z",
 "updatedAt": "2022-08-18T14:37:50.928Z",
 "archived": false
 },
 {
 "id": "430134717",
 "email": "spiderman@marvel.com",
 "firstName": "Peter",
 "lastName": "Parker",
 "userId": 13454826,
 "createdAt": "2022-08-11T09:02:27.782Z",
 "updatedAt": "2022-08-11T09:02:27.782Z",
 "archived": false
 }
 ]
}

My understanding is that this has been designed this way to account for the rare (but not impossible scenario) whereby there may be users in the portal sharing the same name.

4

Thanks, @coldrickjack :raising_hands:

5

Hey, @JdeRocquigny :waving_hand: Thanks for reaching out. I can help out a bit and get us started — you are correct about needing to use the internal value.

Can you confirm what integration you are using? Is it from our Marketplace? NetSuite
Sync contact, lead, and company data between HubSpot and NetSuite.

When you say previous integration, was it a 3rd party tool? The tool may have done some conversion handling on its backend when making the needed API calls, from Label to Internal Value, for example. That is 100% speculation on my part and without knowing the current and previous integrations I cannot say with any confidence.

Thanks for the additional info, it helps the community to better help you :blush:

Best,

Jaycee

6

Hi, @JdeRocquigny, I merged this post and your other one as they were duplicates. Looking at your other post, I see you mentioned using a 3rd party tool called Boomi. In this case, you’ll need to reach out to their support to ask how their tool accounts for label vs internal value for this property.

Hey, @LMeert, do you have any experience with Boomi?

Thank you! — Jaycee