Schema Information

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.

For more information, see HubSpot- Owners.

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.

For more information, see HubSpot- Company Properties.

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.

For more information, see HubSpot- Company Properties Groups.

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.

For more information, see HubSpot- Contact List.

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.

For more information, see HubSpot- Contact Properties Groups.

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.

For more information, see HubSpot- Deal Properties.

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.

For more information, see HubSpot- Call Disposition.

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.

For more information, see HubSpot- Contact Properties.

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.

For more information, see HubSpot- Deals.

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.

For more information, see HubSpot- Contacts.

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.

For more information, see HubSpot- Companies.

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.

For more information, see HubSpot- Engagement.

FIELDS

Field Name	Data Type
engagement	RECORD
associations	RECORD
metadata	RECORD