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 Python 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.
CallAssociations	Returns object IDs associated with specific call records, allowing tracking of call-related associations.
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	Retrieves company records available in HubSpot, supporting both OAuth and private-app token authentication methods.
CompanyAssociations	Lists object IDs associated with specific companies, useful for managing company-related associations.
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	Lists object IDs associated with specific contacts, supporting management of contact associations.
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	Retrieves contact records from HubSpot, supporting both OAuth and private-app token authentication methods.
ContactsToDealsAssociations	Lists deal IDs associated with specific contacts, useful for managing contact-deal relationships.
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	Returns object IDs associated with specific deals, supporting the management of deal associations.
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	Retrieves all deals from HubSpot, supporting both OAuth and private-app token authentication methods.
EmailAssociations	Lists object IDs associated with specific email records, enabling email engagement tracking.
EmailProperties	Retrieves property fields associated with email records in HubSpot, used for email data management.
EngagementsCalls	Retrieves all call engagement records in HubSpot, useful for tracking customer communication.
EngagementsEmails	Retrieves all email engagement records in HubSpot, supporting email interaction analysis.
EngagementsMeetings	Retrieves all meeting engagement records, used to track meetings scheduled within HubSpot.
EngagementsNotes	Retrieves all note engagement records, helpful for logging internal or customer-related notes.
EngagementsTasks	Retrieves all task engagement records, allowing management of action items related to CRM records.
FeedbackSubmissionAssociations	Lists object IDs associated with specific feedback submissions, supporting feedback-related associations.
FeedbackSubmissionProperties	Retrieves property fields for feedback submission records in HubSpot, enabling feedback analysis.
Forms	Retrieves forms used in HubSpot for lead capture and contact data collection.
InvoiceAssociations	Retrieve the IDs of all the objects associated to specific Invoices objects in HubSpot.
Invoices	Retrieve the available Invoices in HubSpot.
LeadAssociations	Lists object IDs associated with specific lead records in HubSpot, supporting 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	Retrieves all lead records from HubSpot for lead tracking and management.
LineitemAssociations	Lists object IDs associated with specific line items, supporting line item associations in deals.
LineItemProperties	Retrieves all properties for line items, including standard and custom fields, supporting detailed item tracking.
Lineitems	Lists all line items in HubSpot, with support for 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	Marketing emails in HubSpot.
MeetingAssociations	Returns object IDs associated with specific meeting records, enabling meeting-related CRM associations.
MeetingProperties	Retrieves available property fields associated with meeting records for meeting data management.
NoteAssociations	Lists object IDs associated with specific notes, supporting associations of notes to other CRM objects.
NoteProperties	Retrieves all available property fields for notes, useful for managing note metadata.
OrderAssociations	Returns object IDs associated with specific orders, supporting both OAuth and private-app token authentications.
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 orders in HubSpot, with support for OAuth and private-app token authentication.
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.
QuoteAssociations	Lists object IDs associated with specific quotes, enabling management of quote associations.
QuoteProperties	Retrieves available property fields for quotes, supporting quote record management.
Quotes	Lists all quotes in HubSpot, useful for managing proposals and sales offers.
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.
TaskAssociations	Returns object IDs associated with specific tasks, supporting task-related CRM associations.
TaskProperties	Retrieves available property fields associated with tasks, useful for managing task records.
Threads	Lists all available conversation threads in HubSpot, useful for managing customer interactions.
TicketAssociations	Returns object IDs associated with specific ticket records, supporting ticket associations in CRM.
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 tickets in HubSpot, supporting both OAuth and private-app token authentication methods.
Workflows	Retrieves and manages workflows in HubSpot used to automate processes across marketing, sales, and service.