Tables

The connector models the data in HubSpot as a list of tables in a relational database that can be queried using standard SQL statements.

CData Power BI Connector for HubSpot Tables


Name	Description
AppointmentAssociations	Retrieve the IDs of all the objects associated to specific Appointments objects in HubSpot.
AppointmentPipelines	Pipelines of Appointments in HubSpot.
AppointmentPipelineStages	PipelineStages of Appointments in HubSpot.
Appointments	Retrieve the available Appointments in HubSpot.
BlogAuthors	Blog authors in HubSpot.
BlogPosts	Blog posts in HubSpot.
BlogTags	Blog tags in HubSpot.
CallProperties	Retrieves available property fields associated with call records, supporting call data management.
Campaigns	Retrieve the available marketing Campaigns in HubSpot
CommunicationProperties	Provides property fields for communication records, enabling management of calls, emails, and messages.
Communications	Lists communication records such as calls and emails in HubSpot, supporting engagement tracking.
Companies	Lists all company records in HubSpot, supporting both OAuth and private-app token authentication methods.
CompanyAssociations	Returns object IDs associated with specific companies, useful for managing associations to deals and other CRM objects.
CompanyPipelines	Provides pipelines associated with companies, used to visualize and manage company lifecycle stages.
CompanyPipelineStages	Lists stages within company pipelines, helping manage progress through company-related workflows.
CompanyProperties	Retrieves all available company property fields in HubSpot, supporting company data enrichment.
CompanyPropertyGroups	Provides access to groups used to organize company properties for easier data management.
ContactAssociations	Returns object IDs associated with specific contacts, enabling management of contact relationships to deals and other objects.
ContactPipelines	Retrieves pipelines configured for managing contact progress through different lifecycle stages.
ContactPipelineStages	Lists stages within the contact pipeline to track the progress of contacts through various lifecycle stages.
ContactProperties	Retrieves all available contact property fields in HubSpot, including both standard and custom properties.
ContactPropertyGroups	Provides groups used to organize contact properties, simplifying property management.
Contacts	Lists all contacts in HubSpot, supporting both OAuth and private-app token authentication methods.
CourseAssociations	Retrieve the IDs of all the objects associated to specific Courses objects in HubSpot.
CoursePipelines	Pipelines of Courses in HubSpot.
CoursePipelineStages	PipelineStages of Courses in HubSpot.
Courses	Retrieve the available Courses in HubSpot.
CustomObjectAssociations	Manages associations between custom object types in HubSpot, facilitating complex object relationships.
DealAssociations	Lists object IDs associated with specific deals, supporting deal-to-object relationships management.
DealPipelines	Provides pipelines associated with deals, used to visualize and manage sales stages.
DealPipelineStages	Lists stages within deal pipelines to track deal progress through different phases.
DealProperties	Retrieves all available deal property fields in HubSpot, both standard and custom properties.
DealPropertyGroups	Provides access to groups used to organize deal properties logically.
Deals	Lists all deal records in HubSpot, supporting both OAuth and private-app token authentication methods.
EmailProperties	Retrieves property fields associated with email records in HubSpot, used for email data management.
EngagementsCalls	Retrieves all call engagement records in HubSpot, used for tracking customer communication.
EngagementsEmails	Retrieves all email engagement records in HubSpot for analyzing customer email interactions.
EngagementsMeetings	Lists all meeting engagement records in HubSpot, useful for scheduling and meeting tracking.
EngagementsNotes	Retrieves note engagement records in HubSpot, used for logging internal or customer notes.
EngagementsTasks	Lists all task engagement records in HubSpot for managing CRM-related tasks.
FeedbackSubmissionAssociations	Returns object IDs associated with specific feedback submissions, useful for feedback association tracking.
FeedbackSubmissionProperties	Retrieves property fields for feedback submission records in HubSpot, enabling feedback analysis.
InvoiceAssociations	Retrieve the IDs of all the objects associated to specific Invoices objects in HubSpot.
Invoices	Retrieve the available Invoices in HubSpot.
LandingPages	Returns the landing pages associated with a HubSpot account.
LeadAssociations	Returns object IDs associated with specific leads, enabling management of lead associations.
LeadPipelineStages	Lists stages within lead pipelines, helping visualize and manage the lead funnel.
LeadProperties	Retrieves all available lead property fields, supporting lead data management and enrichment.
LeadPropertyGroups	Provides groups used to organize lead properties for easier data management.
Leads	Lists all lead records available in HubSpot, supporting lead management workflows.
LineitemAssociations	Returns object IDs associated with specific line items in HubSpot, supporting deal line item relationships.
LineItemProperties	Retrieves all properties for line items, including standard and custom fields, supporting detailed item tracking.
Lineitems	Lists all line item records in HubSpot, supporting both OAuth and private-app token authentications.
ListingAssociations	Retrieve the IDs of all the objects associated to specific Listings objects in HubSpot.
ListingPipelines	Pipelines of Listings in HubSpot.
ListingPipelineStages	PipelineStages of Listings in HubSpot.
Listings	Retrieve the available Listings in HubSpot.
ListMemberships	Represents the relationships between HubSpot lists and CRM objects (contacts, companies, deals, etc.). Each record defines a single object's membership in a specific list, enabling segmentation and targeted marketing activities.
Lists	Retrieves and describes all lists in your HubSpot account.
MarketingEmails	Enables creation, management, and retrieval of marketing emails in HubSpot for email campaign management.
MarketingEvents	Marketing events in HubSpot.
MeetingProperties	Retrieves available property fields associated with meeting records for meeting data management.
NoteProperties	Retrieves all available property fields for notes, useful for managing note metadata.
OrderAssociations	Returns object IDs associated with specific order records, enabling order association tracking.
OrderPipelines	Provides pipelines configured for managing orders, useful for order processing workflows.
OrderPipelineStages	Lists stages within order pipelines, representing steps in the order lifecycle.
OrderProperties	Retrieves all properties associated with orders, including standard and custom fields.
OrderPropertyGroups	Provides access to groups used to organize order properties logically.
Orders	Lists all order records in HubSpot for managing order workflows.
PostalMailProperties	Retrieves all property fields associated with postal mails, enabling management of postal mail records.
PostalMails	Lists all postal mail records in HubSpot, used for tracking postal communication.
ProductAssociations	Returns object IDs associated with specific product records, supporting product associations.
ProductProperties	Retrieves all available product property fields, including standard and custom fields.
Products	Lists all product records configured in HubSpot, supporting both OAuth and private-app token authentications.
Projects	Returns all Projects from HubSpot, used to plan, track, and collaborate on work across your team.
QuoteAssociations	Returns object IDs associated with specific quotes in HubSpot for managing quote associations.
QuoteProperties	Retrieves available property fields for quotes, supporting quote record management.
Quotes	Lists all quote records in HubSpot, useful for sales proposal management.
ServiceAssociations	Retrieve the IDs of all the objects associated to specific Services objects in HubSpot.
ServicePipelines	Pipelines of Services in HubSpot.
ServicePipelineStages	PipelineStages of Services in HubSpot.
Services	Retrieve the available Services in HubSpot.
SitePages	Returns the site pages associated with a HubSpot account.
SubscriptionAssociations	Retrieve the Ids of all the objects associated to specific Subscriptions objects in HubSpot.
Subscriptions	Retrieve the available Subscriptions in HubSpot.
TaskProperties	Retrieves available property fields associated with tasks, useful for managing task records.
TicketAssociations	Returns object IDs associated with specific tickets, supporting customer support case associations.
TicketPipelines	Lists pipelines configured for managing tickets, representing customer support workflows.
TicketPipelineStages	Lists stages within ticket pipelines, used to track progress of customer support cases.
TicketProperties	Retrieves all property fields associated with tickets, supporting ticket data management.
TicketPropertyGroups	Provides access to groups used to organize ticket properties logically.
Tickets	Lists all ticket records in HubSpot, supporting both OAuth and private-app token authentication methods.
URLRedirects	Returns the URL redirects configured in HubSpot.