HubSpot User field not returning any properties

Developer Support APIs & Integrations
1

Hi everyone,

My team has a custom integration built through the HubSpot API and we are running into some trouble with getting HubSpot User fields to sync their values on our end.

For example, in HubSpot, we have a HubSpot User field named “CustomUserLookupProp”, and when querying this field with your API we are not able to see any of the users/options that are available in HubSpot.

Below is our call and response:

curl --location --request GET 'https://api.hubapi.com/properties/v1/contacts/properties/named/CustomUserLookupProp' \
--header 'Authorization: Bearer XXXXXX' \
--data-raw ''

{
 "name": "customuserlookupprop",
 "label": "CustomUserLookupProp",
 "description": "CustomUserLookupProp",
 "groupName": "contact_activity",
 "type": "enumeration",
 "fieldType": "select",
 "fieldLevelPermission": null,
 "hidden": false,
 "deleted": false,
 "updatedAt": 1657905443281,
 "createdAt": 1657905443281,
 "readOnlyDefinition": false,
 "formField": false,
 "displayOrder": -1,
 "readOnlyValue": false,
 "mutableDefinitionNotDeletable": false,
 "favorited": false,
 "favoritedOrder": -1,
 "calculated": false,
 "externalOptions": true,
 "displayMode": "current_value",
 "showCurrencySymbol": false,
 "hubspotDefined": null,
 "referencedObjectType": "OWNER",
 "numberDisplayHint": "formatted",
 "createdUserId": 44058922,
 "searchableInGlobalSearch": false,
 "hasUniqueValue": false,
 "externalOptionsReferenceType": "OWNER",
 "textDisplayHint": null,
 "optionsAreMutable": null,
 "searchTextAnalysisMode": null,
 "optionSortStrategy": null,
 "currencyPropertyName": null,
 "options": [],
 "isCustomizedDefault": false,
 "updatedUserId": 44058922
}

From the above response, we are seeing that the “options” field is coming back as empty, and are not entirely sure why or how to get around this. Is there another way that we are supposed to query this information on our side?

Thank you in advance for any help!

2

Hi @ARios14,

The options for a hubspot user field, is what are called “owners”. You can query a list of all owners via the Get a page of owners /crm/v3/owners/ endpoint. This will return something like the following:

{
 "results": [
 {
 "id": "6166860",
 "email": "jsmith@example.com",
 "firstName": "John",
 "lastName": "Smith",
 "userId": 1296619,
 "createdAt": "2019-10-30T03:30:17.883Z",
 "updatedAt": "2019-12-07T16:50:06.678Z",
 "archived": false,
 "teams": [
 {
 "id": "178588",
 "name": "West Coast Sales",
 "primary": true
 },
 {
 "id": "178590",
 "name": "California Sales",
 "primary": false
 }
 ]
 }
 ],
 "paging": {
 "next": {
 "after": "string",
 "link": "string"
 }
 }
}

The options for a hubspot owner property would be the “id” property of the owners in this response.

Best,