JDBC Driver for HubSpot

Build 22.0.8462

TicketProperties

Get all of the properties for the ticket object type, along with the property definitions.

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

The name of the ticket property. The name must contain only lowercase alphabetical characters and numbers and must start with a lowercase alphabetical character.

Label String False

The human readable label for the ticket property that will display in the HubSpot UI.

FieldType String False

The type of field that will display on the screen for the company property.

The allowed values are textarea, select, text, date, file, number, radio, checkbox.

Type String False

The stored machine type for the company property.

The allowed values are string, number, bool, datetime, enumeration.

GroupName String False

The group the company property is a part of.

Description String False

A description of what the property is for.

DisplayMode String False

How the property will be displayed.

DisplayOrder Integer False

The order in which the property should be displayed in relation to other properties in the same group.

ExternalOptions Boolean False

Boolean indicating if there are external options associate with the company property.

IsFormField Boolean False

Boolean indicating if the property is a field that is part of a form.

IsCalculated Boolean False

Boolean indicating if the property is calculated.

IsHidden Boolean False

Boolean indicating if the property is hidden.

IsFavorited Boolean False

Boolean indicating if the property is favorited.

FavoritedOrder Integer False

The favorited order for this property.

MutableDefinitionNotDeletable Boolean False

Boolean indicating if the property can be modified but not deleted.

ReadOnlyDefinition Boolean False

Boolean indicating if the definition for the property is read only.

ReadOnlyValue Boolean False

Boolean indicating if the value of the property is read only.

OptionsAggregate String False

An aggregate of additional options for the property. Will have a value if the FieldType is radio, checkbox, or booleancheckbox.

ExtraUrlParameters String True

An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462