Explore the HubSpot data model

See how the various HubSpot endpoints relate to each other, using our handy Entity Relationship Diagram.

Background

Pulling data from HubSpot is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only pull your HubSpot endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Company

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Domain string - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

CompanyPropertyValue

Column Type Relates to Notes
RemoteID string - -
CompanyRemoteID string Company → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CompanyID long Company → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

Contact

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Firstname string - -
Lastname string - -
Email string - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

ContactCompany

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
ID long Company → ID -

ContactDeal

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
ID long Deal → ID -

ContactPropertyValue

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

Deal

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
PipelineStageRemoteID string PipelineStage → RemoteID -
PipelineRemoteID string Pipeline → RemoteID -
Dealname string - -
Dealtype string - -
Currency string - -
Amount decimal - -
CloseDate datetime - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

DealCompany

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID long Deal → ID -
ID long Company → ID -

DealLineItem

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID long Deal → ID -
ID long LineItem → ID -

DealPropertyValue

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID long Deal → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

Engagement

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt long - -
LastUpdated long - -
Active boolean - -
Source string - -
CreatedBy long User → ID -
ModifiedBy long User → ID -
Status string -
  • 8 Nov 2021 Available on task and call
TaskType string -
  • 8 Nov 2021 Available on task
Priority string -
  • 8 Nov 2021 Available on task
Subject string -
  • 8 Nov 2021 Available on task
Title string -
  • 8 Nov 2021 Available on call
Body string -
  • 8 Nov 2021 Available on task, call, meeting and note
StartTime long -
  • 8 Nov 2021 Available on meeting
FromEmail string -
  • 8 Nov 2021 Available on email
ToEmails string -
  • 8 Nov 2021 Available on email
CcEmails string -
  • 8 Nov 2021 Available on email
BccEmails string -
  • 8 Nov 2021 Available on email
WhenStarted datetime - -
EndTime long -
  • 8 Nov 2021 Available on meeting
WhenEnd datetime - -

EngagementCompany

Column Type Relates to Notes
RemoteID string - -
EngagementRemoteID string Engagement → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CompanyID long Company → ID -
EngagementID long EngagementDetails → ID -

EngagementContact

Column Type Relates to Notes
RemoteID string - -
EngagementRemoteID string Engagement → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
EngagementID long EngagementDetails → ID -

EngagementDeal

Column Type Relates to Notes
RemoteID string - -
EngagementRemoteID string Engagement → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID long Deal → ID -
EngagementID long EngagementDetails → ID -

EngagementOwner

Column Type Relates to Notes
RemoteID string - -
EngagementRemoteID string Engagement → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID long User → ID -
EngagementID long EngagementDetails → ID -

LineItem

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Description string - -
ProductID long Product → ID -
Currency string - -
Amount decimal - -
CostOfGoodsSold decimal - -
Discount decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

LineItemPropertyValue

Column Type Relates to Notes
RemoteID string - -
LineItemRemoteID string LineItem → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LineItemID long LineItem → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

Pipeline

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 16 Sep 2021 The id field can be either a Int64, or a string such as 'appointmentscheduled'. We've also noticed this coming down as zero.
Archived boolean - -
DisplayOrder decimal - -
Label string - -
CreatedAt datetime - -
UpdatedAt datetime - -

PipelineStage

Column Type Relates to Notes
RemoteID string - -
PipelineRemoteID string Pipeline → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 16 Sep 2021 The id field can be either a Int64, or a string such as 'appointmentscheduled'
DisplayOrder decimal - -
Label string - -
Archived boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

Product

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
Price decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

ProductPropertyValue

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProductID long Product → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

Property

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
Label string - -
Type string -
  • 16 Sep 2021 The object type - string, number, enumeration etc
FieldType string -
  • 16 Sep 2021 How the object is presented - select, text etc
GroupName string - -
CreatedUserID long - -
UpdatedUserID long - -
DisplayOrder decimal - -
Calculated boolean - -
ExternalOptions boolean - -
Archived boolean - -
HasUniqueValue boolean - -
Hidden boolean - -
ShowCurrencySymbol boolean - -
FormField boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

PropertyOption

Column Type Relates to Notes
RemoteID string - -
PropertyRemoteID string Property → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Label string - -
Value string - -
DisplayOrder decimal - -
Hidden boolean - -

Ticket

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Subject string - -
Priority string - -
SourceType string - -
PipelineStageRemoteID string PipelineStage → RemoteID -
PipelineRemoteID string Pipeline → RemoteID -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

TicketCompany

Column Type Relates to Notes
RemoteID string - -
TicketRemoteID string Ticket → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TicketID long Ticket → ID -
ID long Company → ID -

TicketContact

Column Type Relates to Notes
RemoteID string - -
TicketRemoteID string Ticket → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TicketID long Ticket → ID -
ID long Contact → ID -

TicketDeal

Column Type Relates to Notes
RemoteID string - -
TicketRemoteID string Ticket → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TicketID long Ticket → ID -
ID long Deal → ID -

TicketPropertyValue

Column Type Relates to Notes
RemoteID string - -
TicketRemoteID string Ticket → RemoteID -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TicketID long Ticket → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

User

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Email string - -
CreatedAt datetime - -
UpdatedAt datetime - -
ArchivedAt datetime - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.