GoalProperties
Retrieves all available goal property fields associated with companies in HubSpot.
View Specific Information
SELECT
When selecting GoalProperties, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =, IN.
SELECT * FROM GoalProperties; SELECT * FROM GoalProperties WHERE Name = 'hs_assignee_type' ;
Columns
| Name | Type | References | Filterable | Description |
| Name [KEY] | String | True | The internal name of the goal property. It must begin with a lowercase alphabetical character and can include only lowercase letters and numbers. | |
| Label | String | False | The human-readable label of the property as it appears in the HubSpot user interface. | |
| FieldType | String | False | Specifies the type of input field that will be used to display the property in the UI, such as text, dropdown, or checkbox. | |
| Type | String | False | The underlying data type used for storing the property value, such as string, number, or boolean. | |
| GroupName | String | False | The name of the property group to which this goal property belongs. | |
| Description | String | False | A short explanation of the purpose or usage of this property within the goal context. | |
| DisplayOrder | Int | False | Indicates the display order of the property relative to others in the same group. Lower numbers are shown first. | |
| ExternalOptions | Bool | False | Indicates whether the property's options are populated externally, typically used for dropdowns or radio buttons. | |
| IsFormField | Bool | False | Specifies whether this property is used as a field in forms. | |
| IsCalculated | Bool | False | True if the value of the property is derived or computed rather than manually entered. | |
| IsHidden | Bool | False | If true, the property is hidden from the user interface. | |
| IsHubspotDefined | Bool | False | True if the property is defined by HubSpot as a default system property. | |
| Archivable | Bool | False | Specifies whether this property can be archived and excluded from views or forms. | |
| ReadOnlyDefinition | Bool | False | Indicates whether the property's definition (such as label or type) is read-only and cannot be modified. | |
| ReadOnlyValue | Bool | False | If true, the value of the property is locked and cannot be changed manually. | |
| OptionsAggregate | String | False | A combined list of available options for this property, applicable to field types such as radio, checkbox, or boolean checkbox. | |
| HasUniqueValue | Bool | False | Boolean indicating whether the value of the property is unique. |