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 |
| CallProperties | Retrieve the available Quote properties in HubSpot. |
| CommunicationProperties | Retrieve the available Communications properties in HubSpot. |
| Companies | Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| CompanyAssociations | Retrieve the IDs of all the objects associated to specific Companies objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| CompanyPipelines | Pipelines of companies in HubSpot. |
| CompanyPipelineStages | Pipeline stages of companies in HubSpot. |
| ContactAssociations | Retrieve the IDs of all the objects associated to specific Contacts objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| ContactPipelines | Pipelines of contacts in HubSpot. |
| ContactPipelineStages | Pipeline stages of deals in HubSpot. |
| Contacts | Retrieve available contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication methods. |
| ContactsToDealsAssociations | Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| CustomObjectAssociations | Retrieve and manage associations between Custom object types in HubSpot. |
| DealAssociations | Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| DealPipelines | Pipelines of deals in HubSpot. |
| DealPipelineStages | Pipeline stages of deals in HubSpot. |
| Deals | Retrieve the available Deals in HubSpot. his table supports both OAuth and PrivateAppToken authentications. |
| EmailProperties | Retrieve the available Quote properties in HubSpot. |
| 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 Feedbacksubmissions objects in HubSpot. |
| FeedbackSubmissionProperties | Retrieve the available Quote properties in HubSpot. |
| Feedbacksubmissions | Retrieve the available Feedbacksubmissions in HubSpot. |
| Forms | Retrieve HubSpot forms used to collect lead information about your visitors and contacts. |
| LeadAssociations | Retrieve the IDs of all the objects associated to specific Leads objects in HubSpot. |
| LeadPipelineStages | Pipeline stages of Leads in HubSpot. |
| LeadProperties | Retrieve the available LeadProperties in HubSpot. |
| LeadPropertyGroups | Retrieve the available Lead property groups in HubSpot. |
| Leads | Retrieve the available Leads in HubSpot. |
| LineitemAssociations | Retrieve the IDs of all the objects associated to specific Lineitems objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| LineItemProperties | Retrieve the available Quote properties in HubSpot. |
| Lineitems | Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| MeetingProperties | Retrieve the available Quote properties in HubSpot. |
| NoteProperties | Retrieve the available Quote properties in HubSpot. |
| OrderAssociations | Retrieve the IDs of all the objects associated to specific Orders objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| OrderPipelines | Pipelines of Orders in HubSpot. |
| OrderPipelineStages | Pipeline stages of Orders in HubSpot. |
| OrderProperties | Retrieve the available Order properties in HubSpot. |
| OrderPropertyGroups | Retrieve the available Order property groups in HubSpot. |
| Orders | Retrieve the available Orders in HubSpot. |
| PostalEmailProperties | Retrieve the available PostalEmails properties in HubSpot. |
| ProductProperties | Retrieve the available Quote properties in HubSpot. |
| Products | Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| QuoteAssociations | Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot. table supports only PrivateAppToken authentication. |
| Quotes | Retrieve the available Quotes in HubSpot. This table supports only PrivateAppToken authentication. |
| TaskProperties | Retrieve the available Quote properties in HubSpot. |
| Threads | Retrieve the available Threads in a Conversation in HubSpot. |
| TicketAssociations | Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| TicketPipelines | Discover pipelines that a ticket goes through in HubSpot. |
| TicketPipelineStages | Pipeline stages of tickets in HubSpot. |
| Tickets | Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentications. |
| Workflows | Select and manage HubSpot workflows. |