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.
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 | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | long | - | - |
Firstname | string | - | - |
Lastname | string | - | - |
string | - | - | |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
ArchivedAt | datetime | - | - |
CreatedByUserID | long | User → ID | - |
UpdatedByUserID | long | User → ID | - |
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 | - | - |
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 | - |
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 | - |
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 | - |
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 | - | - |
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 | - |
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 | - |
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 | - |
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 | - |
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 | - | - |
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 | - |
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 | - |
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 | - |
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 | - |
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 | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
PipelineRemoteID | string | Pipeline → RemoteID | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | string | - |
|
DisplayOrder | decimal | - | - |
Label | string | - | - |
Archived | boolean | - | - |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
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 | - | - |
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 | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | long | - | - |
string | - | - | |
PrimaryTeamID | long | Team → ID | - |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
ArchivedAt | datetime | - | - |
CreatedByUserID | long | User → ID | - |
UpdatedByUserID | long | User → ID | - |
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 | - | - |
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 | - | - |
Type | string | - | - |
ActivityType | string | - | - |
CreatedBy | long | User → ID | - |
ModifiedBy | long | User → ID | - |
Status | string | - |
|
TaskType | string | - |
|
Priority | string | - |
|
Subject | string | - |
|
Title | string | - |
|
Body | string | - |
|
StartTime | long | - |
|
FromEmail | string | - |
|
ToEmails | string | - |
|
CcEmails | string | - |
|
CallDispositionID | guid | CallDisposition → ID |
|
BccEmails | string | - |
|
WhenStarted | datetime | - | - |
EndTime | long | - |
|
WhenEnd | datetime | - | - |
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 | - |
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 | - |
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 | - |
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 | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | long | - | - |
CreatedAt | datetime | - | - |
UpdatedAt | datetime | - | - |
string | - | - | |
FirstName | string | - | - |
LastName | string | - | - |
UserID | long | User → ID | - |
Archived | boolean | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | guid | - | - |
Label | string | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
OwnerRemoteID | string | Owner → RemoteID | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
OwnerID | long | Owner → ID | - |
TeamID | long | Team → ID | - |
Primary | boolean | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
ID | long | - | - |
Name | string | - | - |
Column | Type | Relates to | Notes |
---|---|---|---|
RemoteID | string | - | - |
TeamRemoteID | string | Team → RemoteID | - |
MirrorRemoteID | int | - | - |
IsDeleted | boolean | - | - |
WhenCreated | datetime | - | - |
WhenModified | datetime | - | - |
TeamID | long | Team → ID | - |
UserID | long | User → ID | - |
Type | string | - | - |
SyncHub lives and breathes APIs and data. Keep exploring using the links below.