HubSpot Data Model
The CData Python Connector for HubSpot models HubSpot data as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your HubSpot account.
Common tables include:
| Table | Description |
| Contacts | Handles HubSpot contact records, enabling full create, read, update, delete (CRUD) operations on contact data. |
| Companies | Manages company records in HubSpot, allowing creation, updating, and deletion of company data similar to contact management. |
| Deals | Manages HubSpot deals used for recording sales opportunities, with capabilities for retrieval and modification. |
| Tickets | Retrieves all ticket records from a HubSpot portal, used for customer support and issue tracking. |
| Engagements | Represents various types of interactions in HubSpot, including calls, emails, and tasks, useful for tracking customer engagement activities. |
| ContactProperties | Accesses both standard and custom properties assigned to contacts, critical for personalized marketing and sales strategies. |
| CompanyProperties | Provides access to standard and custom fields associated with companies in HubSpot, aiding in data enrichment. |
| DealProperties | Provides access to deal property fields, both standard and custom, supporting deal tracking and analysis. |
| TicketProperties | Lists all properties related to tickets, both default and custom, used for managing customer support cases. |
| LineItems | Retrieves all line items in HubSpot, commonly used in association with deals and transactions. |
| Products | Retrieves product records configured in HubSpot, useful for inventory, pricing, and catalog management. |
| Workflows | Manages and retrieves workflows configured in HubSpot to automate marketing, sales, and service processes. |
| CrmAssociations | Queries customer relationship management (CRM) object associations within HubSpot, essential for understanding relationships between CRM entities. |
| ContactFormSubmissions | Lists form submissions made by contacts, useful for analyzing contact engagement through forms. |
| Forms | Enables creation, management, and retrieval of HubSpot forms used for lead capture and contact data collection. |
| MarketingEmails | Enables creation, management, and retrieval of marketing emails in HubSpot for email campaign management. |
| EmailSubscriptions | Lists subscription types linked to a specific email address, allowing management of subscription preferences. |
| AnalyticsSessions | Breaks down analytics data by user sessions, providing visibility into visitor behavior across sessions. |
| AnalyticsViews | Lists configured analytics views within the HubSpot portal, providing information on available analytics perspectives. |
The connector uses the HubSpot API to process supported filters. The connector processes other filters client-side within the connector.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including creating schemas and managing OAuth tokens.