JDBC Driver for HubSpot

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462