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 | Manages company records in HubSpot, allowing creation, updating, and deletion of company data similar to contact management. |
| CompanyProperties | Provides access to standard and custom fields associated with companies in HubSpot, aiding in data enrichment. |
| CompanyPropertyGroups | Organizes company properties into logical groups to streamline property management and categorization in HubSpot. |
| ContactProperties | Accesses both standard and custom properties assigned to contacts, critical for personalized marketing and sales strategies. |
| ContactPropertyGroups | Categorizes contact properties into groups to simplify property organization and data management. |
| Contacts | Handles HubSpot contact records, enabling full create, read, update, delete (CRUD) operations on contact data. |
| CrmAssociations | Queries CRM object associations within HubSpot, essential for understanding relationships between CRM entities. |
| DealAssociations | Manages relationships between deals and associated CRM objects, supporting insertion and deletion of associations. |
| DealProperties | Provides access to deal property fields, both standard and custom, supporting deal tracking and analysis. |
| DealPropertyGroups | Organizes deal properties into property groups to facilitate easier navigation and logical structuring. |
| Deals | Manages HubSpot deals used for recording sales opportunities, with capabilities for retrieval and modification. |
| EmailSubscriptions | Lists subscription types linked to a specific email address, allowing management of subscription preferences. |
| Engagements | Represents various types of interactions in HubSpot, including calls, emails, and tasks, useful for tracking customer engagement activities. |
| Forms | Enables creation, management, and retrieval of HubSpot forms used for lead capture and contact data collection. |
| LineItemProperties | Lists all properties and property definitions for line items, providing structure for product/service line entries. |
| LineItems | Retrieves all line items in HubSpot, commonly used in association with deals and transactions. |
| MarketingEmails | Enables creation, management, and retrieval of marketing emails in HubSpot for email campaign management. |
| ProductProperties | Provides all properties for product records, supporting product data management and enrichment. |
| Products | Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management. |
| SocialMediaMessages | Enables creation and management of social media messages directly from HubSpot's platform. |
| TicketProperties | Lists all properties related to tickets, both default and custom, used for managing customer support cases. |
| TicketPropertyGroups | Returns property groups associated with ticket records, helping organize ticket properties logically. |
| Tickets | Retrieves all ticket records from a HubSpot portal, used for customer support and issue tracking. |
| Workflows | Manages and retrieves workflows configured in HubSpot to automate marketing, sales, and service processes. |