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.