Tables
The driver models the data in HubSpot as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for HubSpot Tables
| Name | Description |
| Companies | Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| CompanyAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| ContactAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| Contacts | Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| ContactsToDealsAssociations | Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| DealAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| Deals | Retrieve the available Deals in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| 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 feedback submissions objects in HubSpot. |
| Feedbacksubmissions | Retrieve the available feedback submissions in HubSpot. |
| LeadAssociations | Retrieve the IDs of all the objects associated to specific Leads objects in HubSpot. |
| Leads | Retrieve the available Leads in HubSpot. |
| LineitemAssociations | Retrieve the IDs of all the objects associated to specific line items objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| Lineitems | Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| OrderAssociations | Retrieve the IDs of all the objects associated to specific Orders objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| Orders | Retrieve the available Orders in HubSpot. |
| Products | Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| QuoteAssociations | Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot. This table supports only PrivateAppToken authentication. |
| Quotes | Retrieve the available Quotes in HubSpot. This table supports only PrivateAppToken authentication. |
| TicketAssociations | Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
| Tickets | Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |