Tickets
Retrieves all ticket records from a HubSpot portal, used for customer support and issue tracking.
Table Specific Information
Tickets, along with contacts, companies and deals, are a foundational object in HubSpot CRM. A ticket represents a customer request for help, support, service, or a response, and the responses generated in reply to this request. Tickets are similar to companies: They both have a number of custom properties that will be dynamically determined and added to the table from your HubSpot Hub.
SELECT
When selecting Tickets, they can only be filtered by the Id. The accepted filters are illustrated below:
SELECT * FROM Contacts WHERE Id = 123456789 SELECT * FROM Contacts WHERE Id IN (123, 456)
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | False |
The unique internal ID assigned to the ticket in HubSpot. | |
| PortalId | Long | False |
The HubSpot Portal ID (Hub ID) associated with the ticket, indicating which account the ticket belongs to. | |
| Version | Long | False |
The version number of the ticket record. This increments each time the ticket is updated, allowing for version tracking. | |
| IsDeleted | Boolean | False |
Boolean indicating whether the ticket has been marked as deleted. Deleted tickets are excluded from query results unless explicitly requested. |