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 | Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
CompanyAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
ContactAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
Contacts | Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
DealAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
Deals | Retrieve the available Deals in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
EngagementsCalls | Retrieve the available Calls in HubSpot. |
EngagementsEmails | Retrieve the available Emails in HubSpot. |
EngagementsMeetings | Retrieve the available Meetings in HubSpot. |
EngagementsNotes | Retrieve the available Notes in HubSpot. |
EngagementsTasks | Retrieve the available Tasks in HubSpot. |
FeedbackSubmissionAssociations | Retrieve the IDs of all the objects associated to specific feedback submissions objects in HubSpot. |
Feedbacksubmissions | Retrieve the available feedback submissions in HubSpot. |
LineitemAssociations | Retrieve the IDs of all the objects associated to specific line items objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
Lineitems | Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
Products | Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
QuoteAssociations | Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot. This table supports only PrivateAppToken authentication. |
Quotes | Retrieve the available Quotes in HubSpot. This table supports only PrivateAppToken authentication. |
TicketAssociations | Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |
Tickets | Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentication. |