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, browse 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

Call

Documentation: https://developers.hubspot.com/docs/api-reference/crm-calls-v3/guide

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
HsBodyPreview string - -
HsObjectSource string - -
HsAttachmentIds string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

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 - -

Campaign

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
Name string - -
CreatedAt datetime - -
UpdatedAt datetime - -
StartDate datetime - -
EndDate datetime - -
ColorHex string - -
Notes string - -
Audience string - -
OwnerID long Owner → ID -
CreatedByUserID long User → ID -
BudgetItemsSumAmount decimal - -
SpendItemsSumAmount decimal - -
ObjectID long - -

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 - -
Archived boolean - -
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 - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

CustomObject

Documentation: https://developers.hubspot.com/docs/guides/api/crm/objects/custom-objects#retrieve-existing-custom-objects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CustomObjectTypeID string CustomObjectType → ObjectTypeID -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

CustomObjectType

Documentation: https://developers.hubspot.com/docs/guides/api/crm/objects/custom-objects#retrieve-existing-custom-objects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
ObjectTypeID string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
FullyQualifiedName string - -
PrimaryDisplayProperty string - -
MetaType string - -
SingularLabel string - -
PluralLabel string - -
Restorable boolean - -

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 - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

Email

Documentation: https://developers.hubspot.com/docs/api-reference/crm-emails-v3/guide

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
HsAttachmentIds string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
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 -
BccEmails string -
  • 8 Nov 2021 Available on email
WhenStarted datetime - -
WhenTimestamp datetime - -
EndTime long -
  • 8 Nov 2021 Available on meeting
WhenEnd datetime - -

FeedbackSubmission

Documentation: https://developers.hubspot.com/beta-docs/guides/api/crm/objects/feedback-submissions

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreatedAt datetime - -
UpdatedAt datetime - -
Sentiment string - -
SurveyChannel string - -
SurveyID long - -
SurveyCRMObjectID long - -
SurveyName string - -
SubmissionUrl string - -
SubmissionName string - -
SurveyType string - -
AgentEmail string - -
AgentName string - -
ChatflowName string - -
CreatedByUserID long User → ID -
SubmissionTimestamp datetime - -
ResponseGroup string - -
TeamID long Team → ID -
IndustryStandardQuestionType string - -
OwnerID long Owner → ID -
OwnerAssignedDate datetime - -
Value int - -
ObjectSourceLabel string - -
ObjectSourceDetail1 string - -
ObjectSourceDetail2 string - -
ObjectSourceDetail3 string - -
Content string - -
Archived boolean - -
UpdatedByUserID long User → ID -

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 - -
Archived boolean - -
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 - -

Lead

Documentation: https://developers.hubspot.com/beta-docs/guides/api/crm/objects/leads

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
LeadName string - -
CreatedByUserID long User → ID -
LastActivityDate datetime - -
LastEngagementDate datetime - -
LastEngagementType string - -
AssociatedDealPipelineStage string PipelineStage → ID -
IsOpen boolean - -
Label string - -
MeetingCount decimal - -
OutreachActivityCount decimal - -
PipelineValue decimal - -
Source string - -
Type string - -
NextActivityDate datetime - -
NumberOfPageViews decimal - -
PrimaryAssociatedObjectName string - -
PrimaryCompanyID long Company → ID -
PrimaryContactID long Contact → ID -
OwnerAssignedDate datetime - -
OwnerID long Owner → ID -
TeamID long Team → ID -
RecordSourceDetail1 string - -
RecordSourceDetail2 string - -
RecordSourceDetail3 string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
UpdatedByUserID long User → ID -

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 - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

Meeting

Documentation: https://developers.hubspot.com/docs/api-reference/crm-meetings-v3/guide

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
HsMeetingTitle string - -
HsMeetingOutcome string - -
HsAttachmentIds string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
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 string -
  • 5 Mar 2025 Observed id values coming down that were not guids (i.e. 'cmf-8533497-4220479')
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 - -

Note

Documentation: https://developers.hubspot.com/docs/api-reference/crm-notes-v3/guide

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
HsBodyPreview string - -
HsAttachmentIds string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

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 - -
Email string - -
FirstName string - -
LastName string - -
UserID long User → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

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 - -
Archived boolean - -
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 User → ID -
UpdatedUserID long User → ID -
DisplayOrder decimal - -
Calculated boolean - -
ExternalOptions boolean - -
Archived boolean - -
HasUniqueValue boolean - -
Hidden boolean - -
ShowCurrencySymbol boolean - -
FormField boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -

Task

Documentation: https://developers.hubspot.com/docs/api-reference/crm-tasks-v3/guide

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
HsTaskSubject string - -
HsTaskType string - -
HsTaskStatus string - -
HsQueueMembershipIds string - -
HsAttachmentIds string - -
CreatedAt datetime - -
UpdatedAt datetime - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

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 - -
Archived boolean - -
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 - -
Archived boolean - -
CreatedByUserID long User → ID -
UpdatedByUserID long User → ID -

CallPropertyValue

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

CallUser

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
UserID long User → ID -

CallTeam

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
TeamID long Team → ID -

CallAttachment

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Call → ID -
AttachmentID long - -

CallCompany

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
CompanyID long Company → ID -

CallDeal

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
DealID long Deal → ID -

CallContact

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
ContactID long Contact → ID -

CallTicket

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

CallMeeting

Column Type Relates to Notes
RemoteID string - -
CallRemoteID string Call → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallID long Call → ID -
MeetingID long Meeting → ID -

CampaignBudget

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#campaign-budget

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignID guid Campaign → ID -
BudgetTotal decimal - -
SpendTotal decimal - -
RemainingBudget decimal - -
CurrencyCode string - -

CampaignMetrics

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#get-%2Fmarketing%2Fv3%2Fcampaigns%2F%7Bcampaignguid%7D%2Freports%2Fmetrics

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignID guid Campaign → ID -
Sessions int - -
NewContactsFirstTouch int - -
InfluencedContacts int - -
NewContactsLastTouch int - -

CampaignFirstTouchContact

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#get-%2Fmarketing%2Fv3%2Fcampaigns%2F%7Bcampaignguid%7D%2Freports%2Fcontacts%2F%7Bcontacttype%7D

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Contact → ID -
CampaignID guid Campaign → ID -

CampaignLastTouchContact

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#get-%2Fmarketing%2Fv3%2Fcampaigns%2F%7Bcampaignguid%7D%2Freports%2Fcontacts%2F%7Bcontacttype%7D

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Contact → ID -
CampaignID guid Campaign → ID -

CampaignInfluencedContact

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#get-%2Fmarketing%2Fv3%2Fcampaigns%2F%7Bcampaignguid%7D%2Freports%2Fcontacts%2F%7Bcontacttype%7D

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Contact → ID -
CampaignID guid Campaign → ID -

CampaignAdCampaign

Documentation: https://developers.hubspot.com/docs/reference/api/marketing/campaigns#get-%2Fmarketing%2Fv3%2Fcampaigns%2F%7Bcampaignguid%7D%2Fassets%2F%7Bassettype%7D

Column Type Relates to Notes
RemoteID string - -
CampaignRemoteID string Campaign → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long Contact → ID -
Name string - -
CampaignID guid Campaign → 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 -
ObjectID string - -
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 -
ObjectID string - -
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 -
CompanyID 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 -
DealID long Deal → ID -

CustomObjectPropertyValue

Column Type Relates to Notes
RemoteID string - -
CustomObjectRemoteID string CustomObject → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomObjectRemote string CustomObject → RemoteID -
CustomObjectTypePropertyRemoteID string CustomObjectTypeProperty → RemoteID -
Value string - -

CustomObjectTypeProperty

Column Type Relates to Notes
RemoteID string - -
CustomObjectTypeRemoteID string CustomObjectType → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Description string - -
CustomObjectTypeID string CustomObjectType → ObjectTypeID -
CreatedAt datetime - -
UpdatedAt datetime - -
CreatedUserID long User → ID -
UpdatedUserID long User → ID -
Archived boolean - -
DataSensitivity string - -
FieldType string - -
GroupName string - -
Label string - -
Type string - -
DisplayOrder int - -
FormField boolean - -
HasUniqueValue boolean - -
Hidden boolean - -
Calculated boolean - -

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 -
ObjectID string - -
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 -
CompanyID 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 -
LineItemID long LineItem → ID -

EmailPropertyValue

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

EmailUser

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
UserID long User → ID -

EmailTeam

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
TeamID long Team → ID -

EmailAttachment

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Email → ID -
AttachmentID long - -

EmailCompany

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
CompanyID long Company → ID -

EmailDeal

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
DealID long Deal → ID -

EmailContact

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
ContactID long Contact → ID -

EmailTicket

Column Type Relates to Notes
RemoteID string - -
EmailRemoteID string Email → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EmailID long Email → ID -
TicketID long Ticket → 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 Engagement → 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 Engagement → 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 Engagement → 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 Engagement → ID -

FeedbackSubmissionPropertyValue

Column Type Relates to Notes
RemoteID string - -
FeedbackSubmissionRemoteID string FeedbackSubmission → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
FeedbackSubmissionID long FeedbackSubmission → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

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 -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

LeadPropertyValue

Column Type Relates to Notes
RemoteID string - -
LeadRemoteID string Lead → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
LeadID long Lead → 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 -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

MeetingPropertyValue

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

MeetingUser

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
UserID long User → ID -
IsAttending boolean - -

MeetingTeam

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
TeamID long Team → ID -

MeetingAttachment

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
AttachmentID long - -

MeetingCompany

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
CompanyID long Company → ID -

MeetingContact

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
ContactID long Contact → ID -

MeetingDeal

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
DealID long Deal → ID -

MeetingLead

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
LeadID long Lead → ID -

MeetingCampaign

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ObjectID -
CampaignID long Campaign → ObjectID -

MeetingTask

Column Type Relates to Notes
RemoteID string - -
MeetingRemoteID string Meeting → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Meeting → ID -
TaskID long Task → ID -

MeetingTicket

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

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 string Message → ID
  • 5 Mar 2025 Observed id values coming down that were not guids (i.e. 'cmf-8533497-4220479')
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 string Message → ID
  • 5 Mar 2025 Observed id values coming down that were not guids (i.e. 'cmf-8533497-4220479')
DeliveryIdentifierType string - -
DeliveryIdentifierValue string - -
RecipientField string - -

NotePropertyValue

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

NoteUser

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
UserID long User → ID -

NoteTeam

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
TeamID long Team → ID -

NoteAttachment

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
AttachmentID long - -

NoteCompany

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
CompanyID long Company → ID -

NoteContact

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
ContactID long Contact → ID -

NoteDeal

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
DealID long Deal → ID -

NoteLead

Column Type Relates to Notes
RemoteID string - -
NoteRemoteID string Note → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
NoteID long Note → ID -
LeadID long Lead → ID -

NoteTicket

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

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 -
ObjectID string - -
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 - -

TaskPropertyValue

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
ObjectID string - -
PropertyRemoteID string Property → RemoteID -
Value string - -

TaskUser

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
UserID long User → ID -

TaskTeam

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
TeamID long Team → ID -

TaskAttachment

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MeetingID long Task → ID -
AttachmentID long - -

TaskCompany

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
CompanyID long Company → ID -

TaskDeal

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
DealID long Deal → ID -

TaskContact

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
ContactID long Contact → ID -

TaskLead

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
LeadID long Lead → ID -

TaskTask

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -

TaskTicket

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

TaskMeeting

Column Type Relates to Notes
RemoteID string - -
TaskRemoteID string Task → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaskID long Task → ID -
MeetingID long Meeting → ID -

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 -
ObjectID string - -
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 -
CompanyID 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 -
DealID 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 -
ContactID long Contact → ID -

CampaignBudgetItem

Column Type Relates to Notes
RemoteID string - -
CampaignBudgetRemoteID string CampaignBudget → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
CampaignID guid CampaignBudget → CampaignID -
Amount decimal - -
Order int - -
CreatedAt long - -
UpdatedAt long - -

CampaignBudgetSpendItem

Column Type Relates to Notes
RemoteID string - -
CampaignBudgetRemoteID string CampaignBudget → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
CampaignID guid CampaignBudget → CampaignID -
Amount decimal - -
Order int - -
CreatedAt long - -
UpdatedAt long - -

Need more?

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

Connect your own HubSpot data Querying HubSpot using regular SQL