Tables
The add-in models the data in HubSpot as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In 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. |
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. |