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 |
| AppointmentAssociations | Retrieve the IDs of all the objects associated to specific Appointments objects in HubSpot. |
| Appointments | Retrieve the available Appointments in HubSpot. |
| Companies | Lists all company records in HubSpot, supporting both OAuth and private-app token authentication methods. |
| CompanyAssociations | Returns object IDs associated with specific companies, useful for managing associations to deals and other CRM objects. |
| ContactAssociations | Returns object IDs associated with specific contacts, enabling management of contact relationships to deals and other objects. |
| Contacts | Lists all contacts in HubSpot, supporting both OAuth and private-app token authentication methods. |
| ContactsToDealsAssociations | Returns deal IDs associated with specific contacts, useful for tracking contact-to-deal relationships. |
| CourseAssociations | Retrieve the IDs of all the objects associated to specific Courses objects in HubSpot. |
| Courses | Retrieve the available Courses in HubSpot. |
| DealAssociations | Lists object IDs associated with specific deals, supporting deal-to-object relationships management. |
| Deals | Lists all deal records in HubSpot, supporting both OAuth and private-app token authentication methods. |
| EngagementsCalls | Retrieves all call engagement records in HubSpot, used for tracking customer communication. |
| EngagementsEmails | Retrieves all email engagement records in HubSpot for analyzing customer email interactions. |
| EngagementsMeetings | Lists all meeting engagement records in HubSpot, useful for scheduling and meeting tracking. |
| EngagementsNotes | Retrieves note engagement records in HubSpot, used for logging internal or customer notes. |
| EngagementsTasks | Lists all task engagement records in HubSpot for managing CRM-related tasks. |
| FeedbackSubmissionAssociations | Returns object IDs associated with specific feedback submissions, useful for feedback association tracking. |
| InvoiceAssociations | Retrieve the IDs of all the objects associated to specific Invoices objects in HubSpot. |
| Invoices | Retrieve the available Invoices in HubSpot. |
| LeadAssociations | Returns object IDs associated with specific leads, enabling management of lead associations. |
| Leads | Lists all lead records available in HubSpot, supporting lead management workflows. |
| LineitemAssociations | Returns object IDs associated with specific line items in HubSpot, supporting deal line item relationships. |
| Lineitems | Lists all line item records in HubSpot, supporting both OAuth and private-app token authentications. |
| ListingAssociations | Retrieve the IDs of all the objects associated to specific Listings objects in HubSpot. |
| Listings | Retrieve the available Listings in HubSpot. |
| OrderAssociations | Returns object IDs associated with specific order records, enabling order association tracking. |
| Orders | Lists all order records in HubSpot for managing order workflows. |
| Products | Lists all product records configured in HubSpot, supporting both OAuth and private-app token authentications. |
| QuoteAssociations | Returns object IDs associated with specific quotes in HubSpot for managing quote associations. |
| Quotes | Lists all quote records in HubSpot, useful for sales proposal management. |
| ServiceAssociations | Retrieve the IDs of all the objects associated to specific Services objects in HubSpot. |
| Services | Retrieve the available Services in HubSpot. |
| TicketAssociations | Returns object IDs associated with specific tickets, supporting customer support case associations. |
| Tickets | Lists all ticket records in HubSpot, supporting both OAuth and private-app token authentication methods. |