CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Tables

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

The adapter models the data in HubSpot into a list of tables that can be queried using standard SQL statements.

Generally, querying HubSpot tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData BizTalk Adapter for HubSpot 2019 Tables

Name Description
Companies Retrieve the available Companies in HubSpot.
CompanyAssociations Retrieve the IDs of contacts, deals and tickets associated to specific companies in HubSpot.
ContactAssociations Retrieve the IDs of companies, deals and tickets associated to specific contacts in HubSpot.
Contacts Retrieve the available Contacts in HubSpot.
DealAssociations Retrieve the IDs of companies and contacts associated to specific deals in HubSpot.
DealPipelineStages Pipelines of deals in HubSpot.
DealPipelineStages Pipeline stages of deals in HubSpot.
Deals Retrieve the available Deals in HubSpot.
LineItemAssociations Retrieve the IDs of objects associated to specific line items in HubSpot.
LineItems Retrieve the available LineItems in HubSpot.
ProductAssociations Retrieve the IDs of objects associated to specific products in HubSpot.
Products Retrieve the available Products in HubSpot.
QuoteAssociations Retrieve the IDs of objects associated to specific quotes in HubSpot.
Quotes Retrieve the available Quotes in HubSpot.
TicketAssociations Retrieve the IDs of objects associated to specific tickets in HubSpot.
TicketPipelineStages Discover pipelines that a ticket goes through in HubSpot.
TicketPipelineStages Pipeline stages of tickets in HubSpot.
Tickets Retrieve the available Tickets in HubSpot.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0