TicketProperties
Lists all properties related to tickets, both default and custom, used for managing customer support cases.
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 | Description |
| Name [KEY] | String | False |
Unique identifier for the ticket property. Must consist of lowercase letters and numbers, beginning with a letter. | |
| Label | String | False |
The display name of the ticket property as shown in the HubSpot interface. | |
| FieldType | String | False |
Specifies the input field type (such as text, dropdown, or checkbox) used for this ticket property in forms or UI. The allowed values are textarea, select, text, date, file, number, radio, checkbox. | |
| Type | String | False |
Defines the backend data type used to store the ticket property (such as string, number, or boolean). The allowed values are string, number, bool, datetime, enumeration. | |
| GroupName | String | False |
The property group this ticket property belongs to, used for categorization. | |
| Description | String | False |
A detailed explanation of the purpose and usage of the ticket property. | |
| DisplayMode | String | False |
Defines how the ticket property appears in the user interface, such as editable or read-only. | |
| DisplayOrder | Integer | False |
Specifies the order in which this property is displayed relative to other properties within the same group. | |
| ExternalOptions | Boolean | False |
Boolean indicating whether the property uses externally managed selectable options (such as dropdown values linked externally). | |
| IsFormField | Boolean | False |
Boolean indicating whether the ticket property is available as an input field in forms. | |
| IsCalculated | Boolean | False |
Indicates whether the property is calculated based on other data points. | |
| IsHidden | Boolean | False |
Boolean specifying whether the ticket property is hidden from view in the HubSpot UI. | |
| IsFavorited | Boolean | False |
Marks whether the property is marked as a favorite, giving it priority display in the UI. | |
| FavoritedOrder | Integer | False |
Order in which favorited properties appear when multiple properties are favorited. | |
| MutableDefinitionNotDeletable | Boolean | False |
Boolean specifying whether the property can be modified but cannot be deleted. | |
| ReadOnlyDefinition | Boolean | False |
Boolean indicating whether the property's definition (its structure) is locked and cannot be edited. | |
| ReadOnlyValue | Boolean | False |
Boolean specifying whether the value of the property is read-only and cannot be updated. | |
| OptionsAggregate | String | False |
Comma-separated list of selectable options available for properties like radio buttons or checkboxes. | |
| ExtraUrlParameters | String | True |
Optional input-only parameter for adding extra query parameters when retrieving data. Format parameters as name=value pairs separated by commas (for example: 'param1=value1, param2=value2, param3=value3'.) |