Tickets
Get all tickets from a portal.
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 internal ID for this ticket. | |
| PortalId | Long | False |
The Portal or Hub ID that this object belongs to. | |
| Version | Long | False |
Version of the ticket. | |
| IsDeleted | Boolean | False |
Whether or not the ticket is deleted. Deleted records will not be included unless you specifically request that deleted records be included. |