Tickets

Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentication.

Table Specific Information

In HubSpot, a ticket represents a customer request for help or support. The tickets endpoints allow you to manage this data and sync it between HubSpot and other systems.

SELECT

When selecting tickets, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 AND operators inside of them. For example:

SELECT * FROM Tickets WHERE [Number of times contacted] > 5 AND [Ticket status] < 4
SELECT * FROM Tickets WHERE [Source] = 'EMAIL' OR [Source] = 'PHONE'

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Tickets WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Tickets WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Tickets WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Tickets WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})

INSERT

INSERT INTO Tickets ([Ticket name]) VALUES ('ticket')

UPDATE

UPDATE Tickets SET [Ticket name] = 'new ticket' WHERE ID = '50962544'

DELETE

DELETE FROM Tickets WHERE ID = '50962544'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False		True	Unique identifier of the object.
Archived	Bool	True		False	Whether the object is archived or not.
CreatedAt	Datetime	True		False	When the object was created.
UpdatedAt	Datetime	True		False	When the object was last updated.
ItemURL	String	True		False	Url that points directly to the HubSpot item.
Close date	Datetime	False		True	The date the ticket was closed.
Created by	Decimal	False		True	VID of contact that created the ticket.
Create date	Datetime	False		True	The date the ticket was created.
First agent email response date	Datetime	True		True	The date of the first email response from an agent after a ticket was created.
Business units	String	False		True	The business units this record is assigned to.
Assignment Method	String	False		True	defines how the Object Assignment is done.
AutoGenerated from thread id	Decimal	True		True	Thread that this ticket was automatically created for using ticket rules.
Originating Conversations Message Id	String	False		True	Conversations Message Id of the message that originated this ticket.
Conversations originating thread id	Decimal	False		True	Thread that this ticket was originally created for.
Created by user ID	Decimal	True		True	The user that created this object. This value is automatically set by HubSpot and may not be modified.
HubSpot create date	Datetime	True		True	Internal read_only property representing the date the ticket was created in HubSpot.
Custom inbox ID	Decimal	False		True	ID of the custom inbox the ticket is associated with.
Date entered 'New _Support Pipeline_'	Datetime	True		True	The date and time when the ticket entered the 'New' stage_ 'Support Pipeline' pipeline.
Date entered 'Waiting on contact _Support Pipeline_'	Datetime	True		True	The date and time when the ticket entered the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Date entered 'Waiting on us _Support Pipeline_'	Datetime	True		True	The date and time when the ticket entered the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Date entered 'Closed _Support Pipeline_'	Datetime	True		True	The date and time when the ticket entered the 'Closed' stage_ 'Support Pipeline' pipeline.
Date exited 'New _Support Pipeline_'	Datetime	True		True	The date and time when the ticket exited the 'New' stage_ 'Support Pipeline' pipeline.
Date exited 'Waiting on contact _Support Pipeline_'	Datetime	True		True	The date and time when the ticket exited the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Date exited 'Waiting on us _Support Pipeline_'	Datetime	True		True	The date and time when the ticket exited the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Date exited 'Closed _Support Pipeline_'	Datetime	True		True	The date and time when the ticket exited the 'Closed' stage_ 'Support Pipeline' pipeline.
External object ids	String	False		True	Unique ids corresponding to tickets in a system outside of HubSpot.
Last CES survey comment	String	True		True	Last CES survey comment that this contact gave for this ticket.
Last CES survey rating	String	True		True	Last CES survey rating that this contact gave for this ticket.
Last CES survey date	Datetime	True		True	The time that this contact last submitted a CES survey response. This is automatically set by HubSpot.
File upload	String	False		True	Files attached to a support form by a contact.
First agent response date	Datetime	True		True	The date of the first response from an agent out of all associated conversations.
In Help Desk	Bool	False		True	Is this Ticket rendered in the Help Desk.
Inbox ID	Decimal	True		True	Inbox the ticket is in.
Last email activity	String	True		True	The type of the last email activity with the contact associated with the ticket.
Last email date	Datetime	True		True	The date of the last email activity with the contact associated with the ticket.
Last message received date	Datetime	True		True	The date of the last response from the visitor.
Last response date	Datetime	True		True	The date of the last response from an agent or bot.
Last activity date	Datetime	True		True	The last time a note_ call_ email_ meeting_ or task was logged for a ticket. This is updated automatically by HubSpot.
Last contacted date	Datetime	True		True	The last time a call_ chat conversation_ LinkedIn message_ postal mail_ meeting_ sales email_ SMS_ or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
Last modified date	Datetime	True		True	Most recent timestamp of any property update for this ticket. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Latest message seen by agent ids	String	True		True	Agents who have seen the newest message across all conversations associated to the ticket.
Merged ticket ids	String	True		True	All ticket ids for this ticket.
Microsoft Teams message ID for this ticket.	String	True		True	Microsoft Teams message ID for this ticket.
Next activity date	Datetime	True		True	The date of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call_ email_ or meeting using the Log feature_ as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
Number of Associated Companies	Decimal	True		True	Number of companies associated with this ticket.
Number of times contacted	Decimal	True		True	The number of times a call_ email_ or meeting was logged on the ticket.
Record ID	Decimal	True		True	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Originating channel account	String	True		True	First channel account used when conversation was started.
Originating email engagement id	Decimal	True		True	Engagement id of the email originating this ticket.
Originating channel type	String	True		True	The channel the conversation is in.
Pinned Engagement ID	Decimal	True		True	The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Pipeline	String	False		True	The pipeline that contains this ticket.
Ticket status	String	False		True	The pipeline stage that contains this ticket.
Read Only Object	Bool	True		True	Is the object read only.
Resolution	String	False		True	The action taken to resolve the ticket.
Thread IDs To Restore	String	False		True	Thread IDs _from cv_threads_ used to implement custom cascading delete_restore.
Category	String	False		True	Main reason customer reached out for help.
Ticket ID	Decimal	True		True	The unique id for this ticket. This unique id is automatically populated by HubSpot.
Priority	String	False		True	The level of attention needed on the ticket.
Time in 'New _Support Pipeline_'	Decimal	True		True	The total time in seconds spent by the ticket in the 'New' stage_ 'Support Pipeline' pipeline.
Time in 'Waiting on contact _Support Pipeline_'	Decimal	True		True	The total time in seconds spent by the ticket in the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Time in 'Waiting on us _Support Pipeline_'	Decimal	True		True	The total time in seconds spent by the ticket in the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Time in 'Closed _Support Pipeline_'	Decimal	True		True	The total time in seconds spent by the ticket in the 'Closed' stage_ 'Support Pipeline' pipeline.
Time to Close SLA Due Date	Datetime	True		True	When the ticket falls out of Time to Close SLA.
Time to Close SLA Ticket Status	String	True		True	Current Time to Close SLA status of ticket.
Time to First Response SLA Due Date	Datetime	True		True	When the ticket falls out of the Time to First Response SLA.
Time to First Response SLA Status	String	True		True	Current Time to First Response SLA status.
Unique creation key	String	True		True	Unique property used for idempotent creates.
Updated by user ID	Decimal	True		True	The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers	String	True		True	The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers	String	True		True	The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners	String	True		True	The user IDs of all owners of this object.
Owner assigned date	Datetime	True		True	The date an owner was assigned to the ticket.
Date of last engagement	Datetime	True		True	The date of the last reply or note.
Last customer reply date	Datetime	True		True	The date of the last customer response.
NPS follow up	String	False		True	Answer to NPS follow up question.
NPS follow up question	Decimal	False		True	Specific version of NPS follow up question that was asked.
Conversation NPS score	String	False		True	NPS score received after ticket resolution.
Reference to email thread	String	False		True	The id of an email thread with ticket conversation.
Time to close	Decimal	True		True	The time between when the ticket was created and closed.
Time to first agent email reply	Decimal	True		True	The time from the ticket create date to the first agent email reply.
Ticket name	String	False		True	Short summary of ticket.
Ticket description	String	False		True	Description of the ticket.
Source	String	False		True	Channel where ticket was originally submitted.
Reference to sourceSpecific object	String	False		True	The id of a connected source object.
Tags	String	False		True	Tags associated with your tickets.
Recent Sales Email Replied Date	Datetime	True		True	The last time a tracked sales email was replied to for this ticket.
Ticket owner	String	False		True	User the ticket is assigned to. Assign additional users to a ticket record by creating a custom user property.
Last Contacted _Ticket Note_	Datetime	True		True	The last timestamp when a call_ email or meeting was logged for this ticket.
Last Activity Date _Ticket Note_	Datetime	True		True	The last time a note_ call_ email_ meeting_ or task was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
Next Activity Date _Ticket Note_	Datetime	True		True	The date of the next upcoming activity for this ticket.
Number of times contacted _Ticket Note_	Decimal	True		True	The number of times a call_ email or meeting was logged for this ticket.
Number of Sales Activities	Decimal	True		True	Number of sales activities for this ticket.
HubSpot team	String	True		True	Primary team of the ticket owner. This property is set automatically by HubSpot.
All owner ids	String	True		True	The value of all owner referencing properties for this object_ both default and custom.
All team ids	String	True		True	The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids	String	True		True	The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.