ODBC Driver for HubSpot

Build 23.0.8839


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.


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)


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839