CompanyProperties
Retrieves all available company property fields in HubSpot, supporting company data enrichment.
Table Specific Information
Company properties are a number of custom properties that are available to store data about the companies in your HubSpot Hub. Some of these properties are added by HubSpot and cannot be deleted. They will be automatically added to the Companies on a new connection.
SELECT
Company properties can only be filtered by the unique company property name. For example:
SELECT * FROM CompanyProperties WHERE Name = 'property_name'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Name [KEY] | String | False | True |
Internal name of the company 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 HubSpot's UI to represent the company property. | |
| FieldType | String | False | False |
Defines the input field type (such as text, dropdown, 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 company property belongs to for organizational display. | |
| Description | String | False | False |
Detailed explanation of the property's purpose and how it is used in company 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 from an external system. | |
| 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 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 company's value for this property must be unique across all records. |