When the HubSpot Deal Owner property is mapped to a text field in Responsive, the field may display a numerical ID, such as 8374601, instead of the owner’s name.
HubSpot User properties do not store user names as text values at the API level. Instead, they store unique system-generated IDs. HubSpot displays the corresponding user names in its interface, but external integrations receive the underlying numerical values.
Changing the field type in Responsive does not resolve the issue because the value originates from the HubSpot API.
Create a custom text property and workflow in HubSpot to copy the Deal Owner’s name into a text field. You can then map this custom property to Responsive.
To create a custom property in HubSpot:
Go to Settings.
Create a custom property under the Deal object.
Select Single-line text as the field type.
Enter Deal Owner Name as the property name.
Save the property.
To create a HubSpot workflow
Create a workflow that runs when:
A Deal record is created.
The value of the Deal Owner property changes.
Add the Copy Property Value action.
Use the appropriate personalization token to retrieve the Deal Owner’s user name.
Copy the user name to the Deal Owner Name property.
Review and activate the workflow.
The workflow populates the custom text property whenever a Deal is created or its owner changes.
In Responsive, open the HubSpot field layout configuration.
Locate the project field currently mapped to the standard Deal Owner property.
Change the mapping to the custom Deal Owner Name property.
Save the configuration.
Responsive will display the Deal Owner’s name from the custom text property instead of the HubSpot internal ID.