2024 is the year of the connector - vote here

Explore the HubSpot API data model

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

Try our interactive ERD Or, read the docs below

Pulling data from the HubSpot API 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 sync your HubSpot API 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

CallDisposition

Documentation: https://legacydocs.hubspot.com/docs/methods/engagements/get-call-dispositions

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Label string - -

Company

Documentation: https://developers.hubspot.com/docs/api/crm/companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

Contact

Documentation: https://developers.hubspot.com/docs/api/crm/contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

Deal

Documentation: https://developers.hubspot.com/docs/api/crm/deals

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

Engagement

Documentation: https://legacydocs.hubspot.com/docs/methods/engagements/get-recent-engagements

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt long - -
LastUpdated long - -
Active boolean - -
Source string - -
Type string - -
ActivityType string - -
Timestamp long - -
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
CallDispositionID guid CallDisposition → ID
  • 2 Oct 2022 Available on calls, indicating the outcome of the call
BccEmails string -
  • 8 Nov 2021 Available on email
WhenStarted datetime - -
WhenTimestamp datetime - -
EndTime long -
  • 8 Nov 2021 Available on meeting
WhenEnd datetime - -

Goal

Documentation: https://developers.hubspot.com/docs/api/crm/goals

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

Inbox

Documentation: https://developers.hubspot.com/docs/api/conversations/conversations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CreatedAt datetime - -

LineItem

Documentation: https://developers.hubspot.com/docs/api/crm/line-items

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

Message

Documentation: https://developers.hubspot.com/docs/api/conversations/conversations

Column Type Relates to Notes
RemoteID string - -
ThreadRemoteID string Thread → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
ThreadID long Thread → ID -
Status string - -
ClientType string - -
ClientIntegrationAppID string - -
CreatedAt datetime - -
CreatedBy string - -
Archived boolean - -
Text string - -
RichText string - -
Type string - -
Subject string - -
TruncationStatus string - -
Direction string - -
ChannelID long - -
ChannelAccountID long - -

Owner

Documentation: https://developers.hubspot.com/docs/api/crm/owners

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt datetime - -
UpdatedAt datetime - -
Email string - -
FirstName string - -
LastName string - -
UserID long User → ID -
Archived boolean - -

Pipeline

Documentation: https://developers.hubspot.com/docs/api/crm/pipelines

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 - -

Product

Documentation: https://developers.hubspot.com/docs/api/crm/products

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

Property

Documentation: https://developers.hubspot.com/docs/api/crm/properties

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 - -

Team

Documentation: https://developers.hubspot.com/docs/api/settings/user-provisioning#endpoint?spec=GET-/settings/v3/users/teams

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -

Thread

Documentation: https://developers.hubspot.com/docs/api/conversations/conversations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt datetime - -
Status string - -
LatestMessageTimestamp datetime - -
LatestMessageSentTimestamp datetime - -
LatestMessageReceivedTimestamp datetime - -
AssignedTo string - -
Spam boolean - -
InboxID long Inbox → ID -
AssociatedContactID long Contact → ID -
Archived boolean - -

Ticket

Documentation: https://developers.hubspot.com/docs/api/crm/tickets

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 -

User

Documentation: https://developers.hubspot.com/docs/api/settings/user-provisioning#endpoint?spec=GET-/settings/v3/users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Email string - -
PrimaryTeamID long Team → ID -
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 -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CompanyID long Company → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

ContactPropertyValue

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

ContactCompany

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
ID long Deal → ID -

DealPropertyValue

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

DealCompany

Column Type Relates to Notes
RemoteID string - -
DealRemoteID string Deal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DealID long Deal → ID -
ID long LineItem → ID -

EngagementDeal

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

EngagementCompany

Column Type Relates to Notes
RemoteID string - -
EngagementRemoteID string Engagement → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID long Contact → ID -
EngagementID long EngagementDetails → ID -

EngagementOwner

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

GoalPropertyValue

Column Type Relates to Notes
RemoteID string - -
GoalRemoteID string Goal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
GoalID long Goal → ID -
PropertyRemoteID string Property → RemoteID -
Value string - -

LineItemPropertyValue

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

MessageSender

Column Type Relates to Notes
RemoteID string - -
MessageRemoteID string Message → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MessageID guid Message → ID -
DeliveryIdentifierType string - -
DeliveryIdentifierValue string - -
ActorID string - -
SenderField string - -

MessageRecipient

Column Type Relates to Notes
RemoteID string - -
MessageRemoteID string Message → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MessageID guid Message → ID -
DeliveryIdentifierType string - -
DeliveryIdentifierValue string - -
RecipientField string - -

OwnerTeam

Column Type Relates to Notes
RemoteID string - -
OwnerRemoteID string Owner → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OwnerID long Owner → ID -
TeamID long Team → ID -
Primary boolean - -

PipelineStage

Column Type Relates to Notes
RemoteID string - -
PipelineRemoteID string Pipeline → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 - -

ProductPropertyValue

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

PropertyOption

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

TeamUser

Column Type Relates to Notes
RemoteID string - -
TeamRemoteID string Team → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TeamID long Team → ID -
UserID long User → ID -
Type string - -

TicketPropertyValue

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

TicketCompany

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

TicketDeal

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

TicketContact

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

Need more?

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

Connect your own HubSpot data Interactive ERD Querying HubSpot using regular SQL