TicketProperties
Retrieves all property fields associated with tickets, supporting ticket data management.
Table-Specific Information
Ticket properties are a number of custom properties that are available to store data about the tickets in your HubSpot Hub. Some of these properties are added by HubSpot and cannot be deleted. They will be automatically added to the Tickets on a new connection.
SELECT
Ticket properties can only be filtered by the unique ticket property name. For example:SELECT * FROM TicketProperties WHERE Name = 'property_name'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Name [KEY] | String | False | True |
Internal name of the ticket property. Must start with a lowercase letter and include only lowercase letters and numbers. | |
| Label | String | False | False |
User-friendly label displayed for the ticket property in the HubSpot UI. | |
| FieldType | String | False | False |
Visual input type shown to users, such as text field, dropdown, or checkbox. | |
| Type | String | False | False |
Underlying machine data type used to store the property value, such as string or number. | |
| GroupName | String | False | False |
Property group this ticket field belongs to, used for organizing fields in the UI. | |
| Description | String | False | False |
Text explaining the purpose or usage of this property in the ticket object. | |
| DisplayOrder | Int | False | False |
Numerical order determining where the property appears within its group. | |
| ExternalOptions | Bool | False | False |
Indicates whether the property's selectable options come from an external source. | |
| IsFormField | Bool | False | False |
Specifies if the property can be included in forms for user input. | |
| IsCalculated | Bool | False | False |
Indicates whether the property's value is computed based on other values. | |
| IsHidden | Bool | False | False |
Indicates whether the property is hidden from the standard UI view. | |
| IsHubspotDefined | Bool | False | False |
True if the property was created by HubSpot as part of its default schema. | |
| Archivable | Bool | False | False |
Indicates whether the property can be archived and hidden from future use. | |
| ReadOnlyDefinition | Bool | False | False |
Specifies if the field definition (such as type or label) is locked from editing. | |
| ReadOnlyValue | Bool | False | False |
Specifies if the property value cannot be manually updated. | |
| OptionsAggregate | String | False | False |
List of predefined selectable values for this property, if applicable to its field type. | |
| HasUniqueValue | Bool | False | False |
Indicates whether the property must contain a unique value across records. |