Exclusive: all our customers get a free six-month subscription to EDNA, a next-gen data and AI learning platform

Explore the Daylite API data model

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

Try our interactive ERD Or, browse below

Pulling data from the Daylite 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 Daylite 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

Appointment

Documentation: https://developer.marketcircle.com/reference/appointments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Timezone string - -
AllDay boolean - -
Category string - -
UtcStart datetime - -
UtcEnd datetime - -
CreateDate datetime - -
ModifyDate datetime - -
ShowAs string - -
Type string - -
Status string - -
Location string - -
Details string - -
Trashed boolean - -
Owner long User → ID -
Creator long User → ID -
Subject string - -
Self string - -

Category

Documentation: https://developer.marketcircle.com/reference/categories

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
CreateDate datetime - -
ModifyDate datetime - -
HexColour string - -
IsActive boolean - -
Self string - -

Company

Documentation: https://developer.marketcircle.com/reference/companies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Image string - -
Category string - -
Type string - -
Industry string - -
Region string - -
Details string - -
Owner long User → ID -
Creator long User → ID -
CreateDate datetime - -
ModifyDate datetime - -
Trashed boolean - -
Self string - -

Contact

Documentation: https://developer.marketcircle.com/reference/contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Prefix string - -
LastName string - -
Suffix string - -
FullName string - -
Alias string - -
Nickname string - -
Image string - -
Category string - -
Birthday datetime - -
Anniversary datetime - -
Details string - -
Owner long User → ID -
Creator long User → ID -
Trashed boolean - -
CreateDate datetime - -
ModifyDate datetime - -
FirstName string - -
Self string - -

Keyword

Documentation: https://developer.marketcircle.com/reference/keywords

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

Note

Documentation: https://developer.marketcircle.com/reference/notes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Details string - -
Category string - -
Trashed boolean - -
Owner long User → ID -
Creator long User → ID -
CreateDate datetime - -
ModifyDate datetime - -
Title string - -
Self string - -

Opportunity

Documentation: https://developer.marketcircle.com/reference/opportunities

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
State string - -
Type string - -
Probability int - -
Forecasted datetime - -
Start datetime - -
End datetime - -
Details string - -
Priority int - -
Category string - -
Owner long User → ID -
Creator long User → ID -
Trashed boolean - -
CreateDate datetime - -
ModifyDate datetime - -
Self string - -

Project

Documentation: https://developer.marketcircle.com/reference/projects

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Status string - -
Due datetime - -
Started datetime - -
Completed datetime - -
Details string - -
Priority int - -
Category string - -
Owner long User → ID -
Creator long User → ID -
Trashed boolean - -
CreateDate datetime - -
ModifyDate datetime - -
Self string - -

Relationship

Documentation: https://developer.marketcircle.com/reference/relationships

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Source long Contact → ID -
Destination long Contact → ID -
RelationshipType long RelationshipType → ID -
CreateDate datetime - -
Details string - -
Self string - -

RelationshipType

Documentation: https://developer.marketcircle.com/reference/relationship_types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
ForContact boolean - -
ForCompany boolean - -
IsActive boolean - -
CreateDate datetime - -
Forward string - -
Reverse string - -
Self string - -

Resource

Documentation: https://developer.marketcircle.com/reference/resources

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Location string - -
Details string - -
HexColour string - -
IsActive boolean - -
CreateDate datetime - -
ModifyDate datetime - -
Self string - -

Role

Documentation: https://developer.marketcircle.com/reference/roles

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Department string - -
Company long Company → ID -
Contact long Contact → ID -
Role string - -
Type long RoleType → ID -
CreateDate datetime - -
Trashed boolean - -
Title string - -
Self string - -

RoleType

Documentation: https://developer.marketcircle.com/reference/role_types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
CreateDate datetime - -
RoleName string - -
IsActive boolean - -
Self string - -

Task

Documentation: https://developer.marketcircle.com/reference/tasks

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Details string - -
Category string - -
Due datetime - -
Location string - -
Type string - -
Status string - -
Priority string - -
Started datetime - -
Completed datetime - -
EstimatedTime int - -
ParentTask long Task → ID -
Trashed boolean - -
Owner long User → ID -
Creator long User → ID -
CreateDate datetime - -
ModifyDate datetime - -
Title string - -
Self string - -

User

Documentation: https://developer.marketcircle.com/reference/users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
AccessLevel string - -
HexColour string - -
PrivateTeam string - -
CreateDate datetime - -
ModifyDate datetime - -
Login string - -
IsActive boolean - -
Contact long Contact → ID -
Self string - -

AppointmentResource

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
ResourceID long Resource → ID -

AppointmentInvitation

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
Invitee long User → ID -
Status string - -

AppointmentContact

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
Contact long Contact → ID -

AppointmentNote

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
Note long Note → ID -

AppointmentProject

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
Project long Project → ID -

AppointmentKeyword

Column Type Relates to Notes
RemoteID string - -
AppointmentRemoteID string Appointment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AppointmentID long Appointment → ID -
Keyword string - -

CompanyKeyword

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

CompanyEmail

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 -
Iterator int - -
Label string - -
Address string - -
Ordering int - -
Note string - -

CompanyURL

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 -
Iterator int - -
Label string - -
Url string - -
Note string - -
Ordering string - -

CompanySocialProfile

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 -
Iterator int - -
Label string - -
Service string - -
Username string - -
Ordering int - -

CompanyPhoneNumber

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 -
Iterator int - -
Label string - -
Format string - -
Number string - -
Note string - -
Ordering int - -

CompanyAddress

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 -
Iterator int - -
Label string - -
Street string - -
City string - -
State string - -
PostalCode string - -
Country string - -
Note string - -

CompanyContact

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 -
Role string - -
Default boolean - -
Department string - -
Title string - -
Contact long Contact → ID -

CompanyOpportunity

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 -
Opportunity long Opportunity → ID -

ContactPhoneNumber

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 -
Iterator int - -
Label string - -
Format string - -
Number string - -
Note string - -
Ordering int - -

ContactEmail

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 -
Iterator int - -
Label string - -
Address string - -
Ordering int - -
Note string - -

ContactSocialProfile

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 -
Iterator int - -
Label string - -
Service string - -
Username string - -
Ordering int - -

ContactURL

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 -
Iterator int - -
Label string - -
Url string - -
Note string - -
Ordering string - -

ContactAddress

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 -
Iterator int - -
Label string - -
Street string - -
City string - -
State string - -
PostalCode string - -
Country string - -
Note string - -
Ordering int - -

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 -
Role string - -
Default boolean - -
Company long Company → ID -

ContactOpportunity

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 -
Opportunity long Opportunity → ID -

ContactAppointment

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 -
Appointment long Appointment → ID -

ContactKeyword

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

NoteKeyword

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

NoteAppointment

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 -
Appointment long Appointment → 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 -
Contact long Contact → ID -

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 -
Company long Company → ID -

NoteGroup

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

NoteOpportunity

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 -
Opportunity long Opportunity → ID -

NoteProject

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 -
Project long Project → ID -

NoteTask

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 -
Task long Task → ID -

OpportunityContact

Column Type Relates to Notes
RemoteID string - -
OpportunityRemoteID string Opportunity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OpportunityID long Opportunity → ID -
Contact long Contact → ID -

OpportunityCompany

Column Type Relates to Notes
RemoteID string - -
OpportunityRemoteID string Opportunity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OpportunityID long Opportunity → ID -
Company long Company → ID -

ProjectKeyword

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID long Project → ID -
Keyword string - -

RoleTypeEntity

Column Type Relates to Notes
RemoteID string - -
RoleTypeRemoteID string RoleType → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
RoleTypeID long RoleType → ID -
EntityType string - -

TaskKeyword

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 -
Keyword string - -
Iterator int - -

TaskAppointment

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 -
Appointment long Appointment → ID -

TaskSubtask

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 -
Task long Task → 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 -
Contact long Contact → ID -

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 -
Company long Company → ID -

TaskGroup

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

TaskNote

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 -
Note long Note → ID -

TaskOpportunity

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 -
Opportunity long Opportunity → ID -

TaskProject

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 -
Project long Project → ID -

Need more?

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

Connect your own Daylite data Querying Daylite using regular SQL