CData Python Connector for HubSpot

Build 25.0.9454

Tickets

Lists all tickets 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, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 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} 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 True True

Unique identifier of the ticket object.

Archived Bool True False

Indicates whether the ticket has been archived.

CreatedAt Datetime True False

Timestamp when the ticket was originally created.

UpdatedAt Datetime True False

Timestamp when the ticket was last modified.

ItemURL String True False

URL linking directly to the HubSpot record for the ticket.

Close date Datetime False True

The date the ticket was marked as closed.

Created by Decimal False True

VID of the contact who created the ticket.

Create date Datetime False True

The creation date of the ticket, as captured in the record.

First agent email response date Datetime True True

Timestamp of the first email response sent by an agent after ticket creation.

Business units String False True

Business units assigned to the ticket record.

Assignment Method String False True

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

AutoGenerated from thread id Decimal True True

ID of the thread for which this ticket was auto-created using ticket rules.

Originating Conversations Message Id String False True

Message ID from Conversations that originated the ticket.

Conversations originating thread id Decimal False True

Thread ID from Conversations that originally created the ticket.

Created by user ID Decimal True True

ID of the HubSpot user who created the ticket. Automatically populated.

HubSpot create date Datetime True True

Internal property showing the HubSpot system creation date for the ticket.

Custom inbox ID Decimal False True

ID of the custom inbox linked to this ticket.

Date entered New (Support Pipeline) Datetime True True

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

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

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

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

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

Date entered Closed (Support Pipeline) Datetime True True

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

Date exited New (Support Pipeline) Datetime True True

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

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

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

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

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

Date exited Closed (Support Pipeline) Datetime True True

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

External object ids String False True

Unique identifiers for linked tickets from external systems.

Last CES survey comment String True True

Latest customer comment received via CES survey for this ticket.

Last CES survey rating String True True

Most recent CES survey rating provided by the customer for this ticket.

Last CES survey date Datetime True True

Timestamp when the most recent CES survey response was submitted for the ticket.

File upload String False True

Files attached to a ticket via the support form submission.

First agent response date Datetime True True

Timestamp when the first agent responded across all associated conversations.

In Help Desk Bool False True

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

Inbox ID Decimal True True

Inbox ID where this ticket resides.

Last email activity String True True

Type of the last email interaction related to the ticket's associated contact.

Last email date Datetime True True

Timestamp of the last email interaction with the ticket's associated contact.

Last message received date Datetime True True

Timestamp of the last customer reply message related to the ticket.

Last response date Datetime True True

Timestamp of the most recent agent or bot response on the ticket.

Last activity date Datetime True True

Timestamp of the most recent logged activity on the ticket, such as a note, call, email, meeting, or task.

Last contacted date Datetime True True

Timestamp of the last sales or service interaction logged against the ticket.

Last modified date Datetime True True

Most recent timestamp of any property update for the ticket, including internal HubSpot changes.

Latest message seen by agent ids String True True

IDs of agents who have seen the newest message across all conversations associated with the ticket.

Merged ticket ids String True True

IDs of all tickets merged into this ticket record.

Microsoft Teams message ID for this ticket. String True True

The Microsoft Teams message ID associated with this ticket.

Next activity date Datetime True True

Date of the next planned activity related to this ticket, such as a call or meeting.

Number of Associated Companies Decimal True True

Total number of companies associated with the ticket.

Number of times contacted Decimal True True

Total number of logged contacts, including calls, emails, or meetings related to the ticket.

Record ID Decimal True True

The unique record ID for this ticket, automatically generated by HubSpot.

Originating channel account String True True

The first channel account used when the originating conversation was started.

Originating email engagement id Decimal True True

Engagement ID of the email that originated the ticket.

Originating channel type String True True

Type of communication channel that originated the ticket, such as email, chat, or form.

Pinned Engagement ID Decimal True True

ID of the engagement currently pinned to this ticket record.

Pipeline String False True

The name of the pipeline that contains this ticket.

Ticket status String False True

The current pipeline stage assigned to this ticket.

Read Only Object Bool True True

Indicates whether the ticket is read-only.

Resolution String False True

Description of the actions taken to resolve the ticket.

Thread IDs To Restore String False True

Thread IDs from conversations used to support custom delete and restore operations.

Category String False True

Primary reason or category describing why the customer opened the ticket.

Ticket ID Decimal True True

Internal HubSpot-generated unique ID for this ticket.

Priority String False True

Priority level assigned to the ticket to determine urgency and service level.

Time in New (Support Pipeline) Decimal True True

Total time in seconds spent in the 'New' stage of the 'Support Pipeline' pipeline.

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

Total time in seconds spent in the 'Waiting on contact' stage of the 'Support Pipeline' pipeline.

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

Total time in seconds spent in the 'Waiting on us' stage of the 'Support Pipeline' pipeline.

Time in Closed (Support Pipeline) Decimal True True

Total time in seconds spent in the 'Closed' stage of the 'Support Pipeline' pipeline.

Time to Close SLA Due Date Datetime True True

Deadline for meeting the Time to Close SLA on the ticket.

Time to Close SLA Ticket Status String True True

Current status of the ticket with respect to the Time to Close SLA.

Time to First Response SLA Due Date Datetime True True

Deadline for the first response according to the Time to First Response SLA.

Time to First Response SLA Status String True True

Current SLA status for the time to first response on the ticket.

Unique creation key String True True

Unique value used to ensure idempotent creation of ticket records.

Updated by user ID Decimal True True

ID of the user who last updated the ticket, automatically set by HubSpot.

User IDs of all notification followers String True True

IDs of users who are following the ticket for notification updates.

User IDs of all notification unfollowers String True True

IDs of owners who have unfollowed the ticket notifications.

User IDs of all owners String True True

IDs of all users who own or co-own the ticket.

Owner assigned date Datetime True True

Timestamp when an owner was most recently assigned to the ticket.

Date of last engagement Datetime True True

Timestamp of the most recent reply or internal note added to the ticket.

Last customer reply date Datetime True True

Timestamp of the most recent customer response on the ticket.

NPS follow up String False True

Response provided to the follow-up question in the NPS survey linked to the ticket.

NPS follow up question Decimal False True

ID representing the specific version of the NPS follow-up question asked.

Conversation NPS score String False True

Net Promoter Score (NPS) rating submitted after ticket resolution.

Reference to email thread String False True

The ID of the email thread that includes the conversation linked to the ticket.

Time to close Decimal True True

Elapsed time between ticket creation and ticket closure, measured in seconds.

Time to first agent email reply Decimal True True

Elapsed time from ticket creation to the first agent email reply, measured in seconds.

Ticket name String False True

Short descriptive title assigned to the ticket.

Ticket description String False True

Detailed description of the issue or request associated with the ticket.

Source String False True

The original channel where the ticket was submitted, such as chat, form, or email.

Reference to sourceSpecific object String False True

ID of the source-specific object that is connected to the ticket, if any.

Tags String False True

Custom tags assigned to the ticket for categorization or segmentation.

Recent Sales Email Replied Date Datetime True True

The last time a tracked sales email associated with this ticket received a reply.

Ticket owner String False True

Owner assigned to manage the ticket. Additional owners can be assigned through custom properties.

Last Contacted _Ticket Note_ Datetime True True

Timestamp of the most recent logged call, email, or meeting associated with the ticket.

Last Activity Date _Ticket Note_ Datetime True True

Timestamp of the most recent note, call, email, meeting, or task logged for the ticket.

Next Activity Date _Ticket Note_ Datetime True True

Planned date for the next activity or follow-up related to the ticket.

Number of times contacted _Ticket Note_ Decimal True True

Total number of logged sales or service contacts recorded for the ticket.

Number of Sales Activities Decimal True True

Total number of sales activities logged against the ticket.

HubSpot team String True True

Primary HubSpot team associated with the ticket owner.

All owner ids String True True

Comma-separated IDs of all owners associated with the ticket.

All team ids String True True

Comma-separated IDs of all direct teams associated with the ticket owner.

All accessible team ids String True True

Comma-separated IDs of all accessible teams, including those up the team hierarchy, for this ticket.

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