CData Python Connector for HubSpot

Build 25.0.9454

Tickets

Lists all ticket records in HubSpot, supporting both OAuth and private-app token authentication methods.

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, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =. 

SELECT * FROM Tickets WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM Tickets WHERE Archived = TRUE;

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 for the ticket record.

Archived Bool True True

Indicates whether the ticket is archived in HubSpot.

CreatedAt Datetime True False

The timestamp when the ticket was first created.

UpdatedAt Datetime True False

The timestamp of the most recent update to the ticket.

ItemURL String True False

Direct URL to access the ticket within the HubSpot UI.

Close date Datetime False False

Date when the ticket was closed.

Created by Decimal False False

Contact ID (VID) of the person who created the ticket.

Create date Datetime False False

The user-defined date when the ticket was created.

First agent email response date Datetime True False

Timestamp of the first email reply sent by an agent for this ticket.

Business units String False False

Specifies which business units this ticket is associated with.

Assignment Method String False False

Indicates the method used to assign the ticket to an owner.

AutoGenerated from thread id Decimal True False

Thread ID used to automatically generate this ticket based on predefined rules.

Originating Conversations Message Id String False False

ID of the conversation message that initially created the ticket.

Conversations originating thread id Decimal False False

Conversation thread ID from which the ticket originated.

Created by user ID Decimal True False

The ID of the user who created the ticket. Automatically set by HubSpot.

HubSpot create date Datetime True False

System-generated timestamp when the ticket was added to HubSpot.

Custom inbox ID Decimal False False

Custom inbox ID that the ticket is linked to.

Date entered New (Support Pipeline) Datetime True False

Timestamp when the ticket entered the 'New' stage of the 'Support Pipeline'.

Date entered Waiting on contact (Support Pipeline) Datetime True False

Timestamp when the ticket entered the 'Waiting on contact' stage of the 'Support Pipeline'.

Date entered Waiting on us (Support Pipeline) Datetime True False

Timestamp when the ticket entered the 'Waiting on us' stage of the 'Support Pipeline'.

Date entered Closed (Support Pipeline) Datetime True False

Timestamp when the ticket entered the 'Closed' stage of the 'Support Pipeline'.

Date exited New (Support Pipeline) Datetime True False

Timestamp when the ticket exited the 'New' stage of the 'Support Pipeline'.

Date exited Waiting on contact (Support Pipeline) Datetime True False

Timestamp when the ticket exited the 'Waiting on contact' stage of the 'Support Pipeline'.

Date exited Waiting on us (Support Pipeline) Datetime True False

Timestamp when the ticket exited the 'Waiting on us' stage of the 'Support Pipeline'.

Date exited Closed (Support Pipeline) Datetime True False

Timestamp when the ticket exited the 'Closed' stage of the 'Support Pipeline'.

External object ids String False False

IDs linking this ticket to equivalent records in external systems.

Last CES survey comment String True False

Most recent Customer Effort Score (CES) survey comment received for this ticket.

Last CES survey rating String True False

Most recent CES survey rating submitted for this ticket.

Last CES survey date Datetime True False

Timestamp of the most recent CES survey submission linked to this ticket.

File upload String False False

Files uploaded by the contact through a support form.

First agent response date Datetime True False

Date of the first response from an agent in any format (such as email or chat).

In Help Desk Bool False False

Indicates whether the ticket is displayed in the Help Desk view.

Inbox ID Decimal True False

ID of the inbox where the ticket resides.

Last email activity String True False

The type of the most recent email activity related to the ticket.

Last email date Datetime True False

Date of the most recent email sent or received regarding the ticket.

Last message received date Datetime True False

Date of the last message received from the customer.

Last response date Datetime True False

Date of the last response from an agent or automation.

Last activity date Datetime True False

Date of the most recent logged activity (such as a note, call, or task) for the ticket.

Last contacted date Datetime True False

Timestamp of the most recent logged interaction (call, email, chat) with the contact on the ticket.

Last modified date Datetime True False

Timestamp of the most recent property update for the ticket, including internal changes.

Latest message seen by agent ids String True False

List of agent IDs who have seen the latest message in the conversation threads linked to this ticket.

Merged ticket ids String True False

List of ticket IDs that have been merged into this ticket.

Microsoft Teams message ID for this ticket. String True False

ID of the Microsoft Teams message associated with this ticket, if applicable.

Next activity date Datetime True False

Date of the next scheduled activity related to this ticket.

Number of Associated Companies Decimal True False

Count of companies associated with the ticket.

Number of times contacted Decimal True False

Number of calls, emails, or meetings logged for this ticket.

Record ID Decimal True False

Unique identifier for the ticket record. Automatically assigned by HubSpot.

Originating channel account String True False

Channel account used to initiate the conversation that created the ticket.

Originating email engagement id Decimal True False

Engagement ID of the email that originated this ticket.

Originating channel type String True False

Type of channel (such as chat, email, or form) used to submit the ticket.

Pinned Engagement ID Decimal True False

ID of the engagement pinned to this ticket for visibility.

Pipeline String False False

Pipeline that includes this ticket.

Ticket status String False False

Current stage of the ticket within its pipeline.

Read Only Object Bool True False

Indicates if the ticket is in read-only mode.

Resolution String False False

Description of how the ticket was resolved.

Thread IDs To Restore String False False

IDs of threads that can be restored for this ticket after a soft delete.

Category String False False

Primary category or reason for the customer's inquiry.

Ticket ID Decimal True False

System-generated unique ID for the ticket.

Priority String False False

Priority level assigned to the ticket, such as High, Medium, or Low.

Time in New (Support Pipeline) Decimal True False

Total time (in seconds) the ticket spent in the 'New' stage of the 'Support Pipeline'.

Time in Waiting on contact (Support Pipeline) Decimal True False

Total time (in seconds) the ticket spent in the 'Waiting on contact' stage.

Time in Waiting on us (Support Pipeline) Decimal True False

Total time (in seconds) the ticket spent in the 'Waiting on us' stage.

Time in Closed (Support Pipeline) Decimal True False

Total time (in seconds) the ticket spent in the 'Closed' stage.

Time to Close SLA Due Date Datetime True False

Deadline by which the ticket must be closed to meet the Service Level Agreement (SLA).

Time to Close SLA Ticket Status String True False

Current SLA status regarding the ticket's time to closure.

Time to First Response SLA Due Date Datetime True False

Deadline by which an agent must send the first response.

Time to First Response SLA Status String True False

Current SLA status for time to first response.

Unique creation key String True False

Key used to ensure idempotency when creating the ticket via integrations or API.

Updated by user ID Decimal True False

ID of the user who last updated the ticket. Automatically assigned by HubSpot.

User IDs of all notification followers String True False

Users who have opted to receive notifications about changes to the ticket.

User IDs of all notification unfollowers String True False

Users who have opted out of receiving notifications about the ticket.

User IDs of all owners String True False

IDs of all users assigned as owners of the ticket.

Owner assigned date Datetime True False

Timestamp of when ownership of the ticket was assigned.

Date of last engagement Datetime True False

Timestamp of the most recent reply or interaction linked to the ticket.

Last customer reply date Datetime True False

Timestamp of the customer's most recent response.

NPS follow up String False False

Customer's response to the Net Promoter Score (NPS) follow-up question.

NPS follow up question Decimal False False

Identifier for the specific version of the NPS follow-up question asked.

Conversation NPS score String False False

NPS given by the customer after resolution.

Reference to email thread String False False

ID of the email thread linked to the ticket.

Time to close Decimal True False

Total time elapsed between ticket creation and closure.

Time to first agent email reply Decimal True False

Elapsed time between ticket creation and first email reply from an agent.

Ticket name String False False

Brief subject line or title summarizing the ticket.

Ticket description String False False

Detailed description of the issue or request reported in the ticket.

Source String False False

Origin channel where the ticket was initially submitted, such as email or chat.

Reference to sourceSpecific object String False False

ID of the object representing the source of the ticket (such as conversation or workflow).

Tags String False False

Labels or keywords manually or automatically assigned to the ticket for classification.

Recent Sales Email Replied Date Datetime True False

Date of the most recent reply to a tracked sales email related to this ticket.

Ticket owner String False False

User currently assigned to own and manage the ticket.

Last Contacted _Ticket Note_ Datetime True False

Last recorded interaction date from calls, emails, or meetings related to this ticket.

Last Activity Date _Ticket Note_ Datetime True False

Most recent note, call, meeting, or task logged for the ticket.

Next Activity Date _Ticket Note_ Datetime True False

Next upcoming scheduled activity related to the ticket.

Number of times contacted _Ticket Note_ Decimal True False

Count of logged interactions for this ticket.

Number of Sales Activities Decimal True False

Total number of sales-related actions linked to the ticket.

HubSpot team String True False

Team assigned to the ticket owner, automatically set by HubSpot.

All owner ids String True False

All owner-related IDs, including custom and default ownership.

All team ids String True False

Team IDs linked to all ownership properties, including hierarchy.

All accessible team ids String True False

Team IDs, including inherited teams, with access to the ticket record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454