テーブル

本製品はHubSpot のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData Power BI Connector for HubSpot テーブル


Name	Description
Companies	Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
CompanyAssociations	Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
ContactAssociations	Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Contacts	Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
ContactsToDealsAssociations	Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications.
DealAssociations	Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Deals	Retrieve the available Deals in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
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 feedback submissions objects in HubSpot.
Feedbacksubmissions	Retrieve the available feedback submissions in HubSpot.
LeadAssociations	Retrieve the IDs of all the objects associated to specific Leads objects in HubSpot.
Leads	Retrieve the available Leads in HubSpot.
LineitemAssociations	Retrieve the IDs of all the objects associated to specific line items objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Lineitems	Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
OrderAssociations	Retrieve the IDs of all the objects associated to specific Orders objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications.
Orders	Retrieve the available Orders in HubSpot.
Products	Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
QuoteAssociations	Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot. This table supports only PrivateAppToken authentication.
Quotes	Retrieve the available Quotes in HubSpot. This table supports only PrivateAppToken authentication.
TicketAssociations	Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Tickets	Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentication.