Tables
The driver models the data in HubSpot into a list of tables that can be queried using standard SQL statements.
Generally, querying HubSpot tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC 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. |
| EcommerceSettings | Retrieve the current ecommerce settings for your portal or app. |
| 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. |
| LineItems | Query the available line items in HubSpot. |
| MarketingEmails | Create and manage HubSpot Marketing Emails. |
| 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. |