ContactProperties
Retrieves all available contact property fields in HubSpot, including both standard and custom properties.
Table Specific Information
Contact properties are a number of custom properties that are available to store data about the contacts in your HubSpot Hub. Some of these properties are added by HubSpot and cannot be deleted. They will be automatically added to the Contacts on a new connection.
SELECT
Contact properties can only be filtered by the unique contact property name or group name. For example:
SELECT * FROM ContactProperties WHERE Name = 'property_name' SELECT * FROM ContactProperties WHERE GroupName = 'group_name'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Name [KEY] | String | False | True |
Internal name of the contact property, consisting of lowercase letters and numbers, starting with a letter. Serves as the unique identifier. | |
| Label | String | False | False |
User-friendly label displayed in the HubSpot UI to represent the contact property. | |
| FieldType | String | False | False |
Defines the input field type (such as text, dropdown, or checkbox) for this property as displayed in the UI. | |
| Type | String | False | False |
Underlying machine data type (such as string, number, or date) used to store the property's value. | |
| GroupName | String | False | False |
Identifies the property group this contact property belongs to for organizational display. | |
| Description | String | False | False |
Detailed explanation of the property's purpose and how it is used in contact records. | |
| DisplayOrder | Int | False | False |
Numeric value determining the order this property appears relative to others within its group. | |
| ExternalOptions | Bool | False | False |
Indicates whether the property's selectable options are sourced externally. | |
| IsFormField | Bool | False | False |
Specifies whether this property appears as an editable field within HubSpot forms. | |
| IsCalculated | Bool | False | False |
Indicates whether the property's value is automatically calculated based on other properties or data. | |
| IsHidden | Bool | False | False |
Determines whether the property is hidden from standard views in the HubSpot interface. | |
| IsHubspotDefined | Bool | False | False |
True if the property is predefined by HubSpot, false if it was custom-created. | |
| Archivable | Bool | False | False |
Indicates whether this property can be archived and removed from active use. | |
| ReadOnlyDefinition | Bool | False | False |
Specifies whether the property's definition (such as type or label) is locked and cannot be modified. | |
| ReadOnlyValue | Bool | False | False |
Specifies whether the property's value is read-only and not editable by users. | |
| OptionsAggregate | String | False | False |
Serialized list of selectable options for the property, relevant when FieldType supports multiple-choice fields (such as radio buttons, checkboxes, or boolean checkboxes). | |
| HasUniqueValue | Bool | False | False |
Indicates whether each contact's value for this property must be unique across all records. |