Tables
The driver models the data in HubSpot into a list of tables that can be queried using standard SQL statements.
Generally, querying HubSpot tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for HubSpot Tables
| Name | Description |
| Companies | Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| CompanyAssociations | Retrieve the IDs of all the objects associated to specific Companies objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| ContactAssociations | Retrieve the IDs of all the objects associated to specific Contacts objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| Contacts | Retrieve the available Contacts in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| ContactsToDealsAssociations | Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| CustomObjectAssociations | Retrieve and manage associations between Custom object types in HubSpot. |
| DealAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| DealPipelines | Pipelines of deals in HubSpot. |
| DealPipelineStages | Pipeline stages of deals in HubSpot. |
| Deals | Retrieve the available Deals in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| EngagementsCalls | Retrieve the available Calls in HubSpot. |
| EngagementsEmails | Retrieve the available Emails in HubSpot. |
| EngagementsMeetings | Retrieve the available Meetings in HubSpot. |
| EngagementsNotes | Retrieve the available Notes in HubSpot. |
| EngagementsTasks | Retrieve the available Tasks in HubSpot. |
| FeedbackSubmissionAssociations | Retrieve the IDs of all the objects associated to specific Feedbacksubmissions objects in HubSpot. |
| Feedbacksubmissions | Retrieve the available Feedbacksubmissions in HubSpot. |
| Forms | Retrieve HubSpot forms used to collect lead information about your visitors and contacts. |
| LineitemAssociations | Retrieve the IDs of all the objects associated to specific Lineitems objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| Lineitems | Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| Products | Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| QuoteAssociations | Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot. table supports only PrivateAppToken authentication. |
| Quotes | Retrieve the available Quotes in HubSpot. This table supports only PrivateAppToken authentication. |
| Threads | Retrieve the available Threads in a Conversation in HubSpot. |
| TicketAssociations | Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| TicketPipelines | Discover pipelines that a ticket goes through in HubSpot. |
| TicketPipelineStages | Pipeline stages of tickets in HubSpot. |
| Tickets | Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |