Schema Information of Hubspot v2
This subtopic provides a structured reference to assist you in working with Daton's HubSpot v2 connector and the associated fields and tables.
Schema Information of Hubspot v2
This subtopic provides a structured reference to assist you in working with Daton's HubSpot v2 connector and the associated fields and tables.
Tables/APIs
The following are the tables or APIs associated with the HubSpot v2 connector:
Owners
The Owners API allows you to manage and retrieve information about the owners (users) of records in HubSpot, such as contacts, companies, and deals.
FIELDS
Field Name |
Data Type |
|---|---|
portalId |
NUMERIC |
ownerId |
NUMERIC |
type |
STRING |
firstName |
STRING |
lastName |
STRING |
email |
STRING |
createdAt |
NUMERIC |
updatedAt |
NUMERIC |
remoteList |
RECORD |
hasContactsAccess |
BOOLEAN |
activeUserId |
NUMERIC |
isActive |
BOOLEAN |
userIdIncludingInactive |
NUMERIC |
Company Properties
This API enables you to access and manage properties (fields) associated with company records in HubSpot, facilitating customization and data management.
FIELDS
Field Name |
Data Type |
|---|---|
name |
STRING |
label |
STRING |
description |
STRING |
groupName |
STRING |
type |
STRING |
fieldType |
STRING |
hidden |
BOOLEAN |
isCustomizedDefault |
BOOLEAN |
createdAt |
NUMERIC |
updatedAt |
NUMERIC |
favoritedOrder |
NUMERIC |
calculated |
BOOLEAN |
externalOptions |
BOOLEAN |
displayMode |
STRING |
hubspotDefined |
BOOLEAN |
formField |
BOOLEAN |
searchableInGlobalSearch |
BOOLEAN |
hasUniqueValue |
BOOLEAN |
displayOrder |
NUMERIC |
readOnlyValue |
BOOLEAN |
readOnlyDefinition |
BOOLEAN |
mutableDefinitionNotDeletable |
BOOLEAN |
favorited |
BOOLEAN |
Company Properties Groups
With this API, you can organize and work with property groups that categorize properties related to company records in HubSpot.
FIELDS
Field Name |
Data Type |
|---|---|
name |
STRING |
fulcrumPortalId |
NUMERIC |
fulcrumTimestamp |
NUMERIC |
displayName |
STRING |
displayOrder |
NUMERIC |
hubspotDefined |
BOOLEAN |
properties |
RECORD |
Contact List
The Contact List API provides tools to manage and interact with contact lists in HubSpot, making it easier to segment and work with specific groups of contacts.
FIELDS
Field Name |
Data Type |
|---|---|
portalId |
NUMERIC |
listId |
NUMERIC |
createdAt |
NUMERIC |
updatedAt |
NUMERIC |
name |
STRING |
listType |
STRING |
authorId |
NUMERIC |
metaData |
RECORD |
archived |
BOOLEAN |
ilsFilterBranch |
STRING |
readOnly |
BOOLEAN |
internal |
BOOLEAN |
limitExempt |
BOOLEAN |
dynamic |
BOOLEAN |
Contact Properties Groups
The Contact Properties Groups API allows you to organize and handle property groups that categorize properties associated with contact records in HubSpot.
FIELDS
Field Name |
Data Type |
|---|---|
name |
STRING |
fulcrumPortalId |
NUMERIC |
fulcrumTimestamp |
NUMERIC |
displayName |
STRING |
displayOrder |
NUMERIC |
hubspotDefined |
BOOLEAN |
Deal Properties
Using the Deal Properties API, you can access and manage properties (fields) associated with deal records in HubSpot, enhancing customization and data management for sales processes.
FIELDS
Field Name |
Data Type |
|---|---|
name |
STRING |
label |
STRING |
description |
STRING |
groupName |
STRING |
type |
STRING |
fieldType |
STRING |
hidden |
BOOLEAN |
createdAt |
NUMERIC |
formField |
BOOLEAN |
displayOrder |
NUMERIC |
readOnlyValue |
BOOLEAN |
readOnlyDefinition |
BOOLEAN |
mutableDefinitionNotDeletable |
BOOLEAN |
favorited |
BOOLEAN |
favoritedOrder |
NUMERIC |
calculated |
BOOLEAN |
externalOptions |
BOOLEAN |
displayMode |
STRING |
showCurrencySymbol |
BOOLEAN |
deleted |
BOOLEAN |
updatedAt |
NUMERIC |
createdUserId |
NUMERIC |
searchableInGlobalSearch |
BOOLEAN |
hasUniqueValue |
BOOLEAN |
numberDisplayHint |
STRING |
isCustomizedDefault |
BOOLEAN |
updatedUserId |
NUMERIC |
options |
RECORD |
Call Disposition
The Call_Disposition API offers tools to manage call dispositions, which are labels or tags applied to calls, helping track call outcomes and interactions in HubSpot.
FIELDS
Field Name |
Data Type |
|---|---|
id |
STRING |
label |
STRING |
deleted |
BOOLEAN |
Contact Properties
The Contact Properties API provides access to properties (fields) associated with contact records in HubSpot, allowing customization and data management for contacts.
FIELDS
Field Name |
Data Type |
|---|---|
name |
STRING |
label |
STRING |
description |
STRING |
groupName |
STRING |
type |
STRING |
fieldType |
STRING |
hidden |
BOOLEAN |
isCustomizedDefault |
BOOLEAN |
createdAt |
NUMERIC |
formField |
BOOLEAN |
displayOrder |
NUMERIC |
readOnlyValue |
BOOLEAN |
readOnlyDefinition |
BOOLEAN |
mutableDefinitionNotDeletable |
BOOLEAN |
favorited |
BOOLEAN |
favoritedOrder |
NUMERIC |
calculated |
BOOLEAN |
externalOptions |
BOOLEAN |
displayMode |
STRING |
showCurrencySymbol |
BOOLEAN |
deleted |
BOOLEAN |
updatedAt |
NUMERIC |
createdUserId |
NUMERIC |
searchableInGlobalSearch |
BOOLEAN |
hasUniqueValue |
BOOLEAN |
numberDisplayHint |
STRING |
updatedUserId |
NUMERIC |
options |
RECORD |
Deals
With the Deals API, you can manage and interact with deal records in HubSpot, facilitating sales pipeline management and deal tracking.
FIELDS
Field Name |
Data Type |
|---|---|
portalId |
NUMERIC |
dealId |
NUMERIC |
isDeleted |
BOOLEAN |
associations |
RECORD |
properties |
RECORD |
Contacts
The Contacts API allows you to manage and retrieve information related to contact records in HubSpot, enabling efficient customer relationship management.
FIELDS
Field Name |
Data Type |
|---|---|
vid |
NUMERIC |
canonical-vid |
NUMERIC |
portal-id |
NUMERIC |
is-contact |
BOOLEAN |
properties |
RECORD |
form-submissions |
RECORD |
identity-profiles |
RECORD |
addedAt |
NUMERIC |
Companies
The Companies API offers tools to manage and interact with company records in HubSpot, facilitating B2B relationship management and data organization.
FIELDS
Field Name |
Data Type |
|---|---|
portalId |
NUMERIC |
companyId |
NUMERIC |
isDeleted |
BOOLEAN |
properties |
RECORD |
Engagement
The Engagement API provides access to engagement records, which include interactions such as emails, calls, and meetings, allowing for the tracking and analysis of customer engagements in HubSpot.
FIELDS
Field Name |
Data Type |
|---|---|
engagement |
RECORD |
associations |
RECORD |
metadata |
RECORD |