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 | Companies may be kept track of in HubSpot just like contacts. They can be added to, updated, and removed from this table. |
| CompanyProperties | Company properties are the standard and custom pieces of field data that appear in HubSpot. |
| CompanyPropertyGroups | Company property groups in HubSpot offer a way of organizing individual types of properties for companies. Each company property must belong to a property group. |
| ContactLists | Contact lists in HubSpot can be used to group together contacts with similar characteristics. |
| ContactProperties | Contact properties are the standard and custom pieces of field data that appear in HubSpot. |
| ContactPropertyGroups | Contact property groups in HubSpot offer a way of organizing individual types of properties for contacts. Each contact property must belong to a property group. |
| Contacts | Your contacts in HubSpot may be used for marketing campaigns and can be retrieved, inserted, updated, and deleted from this table. |
| ContactsInList | Retrieves the contacts in a given list in HubSpot. New contacts may be added to the list or removed from it. A ListId must be specified to retrieve the current contacts in the list. |
| CrmAssociations | Query the available CRM Associations in HubSpot. |
| DealAssociations | Deal associations can be used to insert or delete individual associations with Deals. |
| DealProperties | Deal properties are the standard and custom pieces of field data that appear in HubSpot. |
| DealPropertyGroups | Contact property groups in HubSpot offer a way of organizing individual types of properties for contacts. Each contact property must belong to a property group. |
| Deals | Your deals in HubSpot which may be used for making offers to potential customers. |
| EmailSubscriptions | The subscription types a given email is subscribed to. An email must be specified to return results. Subscriptions may be removed by deleting them. |
| Engagements | Engagements represent any of a number of different types of engagements you have in HubSpot. |
| Forms | Create and manage HubSpot Forms. |
| LineItemProperties | Get all of the properties for the line item object type, along with the property definitions. |
| LineItems | Query the available line items in HubSpot. |
| MarketingEmails | Create and manage HubSpot Marketing Emails. |
| ProductProperties | Get all of the properties for the product object type, along with the property definitions. |
| Products | Query the available products in HubSpot. |
| SocialMediaMessages | Create and manage HubSpot social media messages. |
| TicketProperties | Get all of the properties for the ticket object type, along with the property definitions. |
| TicketPropertyGroups | Get all of the property groups for the specified Ticket object type. |
| Tickets | Get all tickets from a portal. |
| Workflows | Select and manage HubSpot workflows. |