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
BlogAuthors Retrieve the available blog authors in HubSpot.
BlogPosts Retrieve the available blog posts in HubSpot.
BlogTopics Retrieve the available blog topics in HubSpot.
Companies Companies may be kept track of in HubSpot just like contacts. They can be added to, updated, and removed from this table.
CompanyProperties Company properties are the standard and custom pieces of field data that appear in HubSpot.
CompanyPropertyGroups Company property groups in HubSpot offer a way of organizing individual types of properties for companies. Each company property must belong to a property group.
ContactLists Contact lists in HubSpot can be used to group together contacts with similar characteristics.
ContactProperties Contact properties are the standard and custom pieces of field data that appear in HubSpot.
ContactPropertyGroups Contact property groups in HubSpot offer a way of organizing individual types of properties for contacts. Each contact property must belong to a property group.
Contacts Your contacts in HubSpot may be used for marketing campaigns and can be retrieved, inserted, updated, and deleted from this table.
ContactsInList Retrieves the contacts in a given list in HubSpot. New contacts may be added to the list or removed from it. A ListId must be specified to retrieve the current contacts in the list.
CrmAssociations Query the available CRM Associations in HubSpot.
DealAssociations Deal associations can be used to insert or delete individual associations with Deals.
DealPipelines Deal pipelines may be used to organize what stages a given deal is on.
DealProperties Deal properties are the standard and custom pieces of field data that appear in HubSpot.
DealPropertyGroups Contact property groups in HubSpot offer a way of organizing individual types of properties for contacts. Each contact property must belong to a property group.
Deals Your deals in HubSpot which may be used for making offers to potential customers.
EcommerceSettings Retrieve the current ecommerce settings for your portal or app.
EmailCampaigns Email campaigns in HubSpot allow you to keep track of and update email marketing campaigns. This table allows you to create, update, and delete your email campaigns in HubSpot.
EmailSubscriptions The subscription types a given email is subscribed to. An email must be specified to return results. Subscriptions may be removed by deleting them.
Engagements Engagements represent any of a number of different types of engagements you have in HubSpot.
Folders Retrieves information about the available folders in HubSpot.
Forms Create and manage HubSpot Forms.
LineItems Query the available line items in HubSpot.
MarketingEmails Create and manage HubSpot Marketing Emails.
Pages Retrieve the available pages in HubSpot.
Products Query the available products in HubSpot.
SocialMediaMessages Create and manage HubSpot social media messages.
Tasks Retrieve task events for Calendar.
TicketProperties Get all of the properties for the ticket object type, along with the property definitions.
TicketPropertyGroups Get all of the property groups for the specified Ticket object type.
Tickets Get all tickets from a portal.
Workflows Select and manage HubSpot workflows.

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