Explore the monday.com data model

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

Background

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

At SyncHub, we not only pull your monday.com 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

ActivityLog

Documentation: https://monday.com/developers/v2#queries-section-activity-logs

Column Type Relates to Notes
RemoteID string -
  • 19 Jun 2020 We could use the id here to uniquely identify our record. However, we append the board_id column too, as it then lets us call back and get this record individually via the API if we need to (logs are queried through the board entity)
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
AccountID int - -
Event string - -
Entity string - -
Data string - -
CreatedAt long - -
BoardID int - -

Board

Documentation: https://monday.com/developers/v2#queries-section-boards

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
State string - -
OwnerID int User → ID -

BoardTag

Column Type Relates to Notes
RemoteID string - -
BoardTagRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
BoardID int Board → ID -

Column

Documentation: https://monday.com/developers/v2#queries-section-columns

Column Type Relates to Notes
RemoteID string - -
ColumnRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 16 Jun 2020 The column id is a string e.g. 'status' or 'date4'
BoardID int Board → ID -
Title string - -
Type string - -
Archived boolean - -
Pos string -
  • 16 Jun 2020 The position on the board
SettingsStr string - -

ColumnValue

Documentation: https://monday.com/developers/v2#queries-column-values

Column Type Relates to Notes
RemoteID string - -
ColumnValueRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 16 Jun 2020 Refers to the Column.id field - it is not a unique id of this record.
ItemID int - -
BoardID int - -
Text string - -
Value string - -
ColumnRemoteID string - -

Group

Documentation: https://monday.com/developers/v2#queries-section-groups

Column Type Relates to Notes
RemoteID string - -
GroupRemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Title string - -
BoardID int Board → ID -
Position string - -
Color string - -
Archived boolean - -
Deleted boolean - -

Item

Documentation: https://monday.com/developers/v2#queries-section-items

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int -
  • 16 Jun 2020 The column id is a string e.g. 'status' or 'date4'
Name string - -
BoardID int Board → ID -
GroupID string Group → RemoteID -
UpdatedAt string -
  • 16 Jun 2020 This field is formatted with the description 'UTC' at the end (e.g '2020-06-16 03:04:47 UTC'). This is not a standard parseable format, so we record it as a string value here, then use our WhenModified property to parse it to a proper date
CreatedAt string -
  • 16 Jun 2020 This field is formatted with the description 'UTC' at the end (e.g '2020-06-16 03:04:47 UTC'). This is not a standard parseable format, so we record it as a string value here, then use our WhenCreated property to parse it to a proper date
CreatorID long -
  • 10 Aug 2020 API documentation mentions that creator is of type User, however creator_id does not point to any of the users in our sample data.

Team

Documentation: https://monday.com/developers/v2#queries-section-teams

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

User

Documentation: https://monday.com/developers/v2#queries-section-users

Column Type Relates to Notes
RemoteID string - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID int - -
Name string - -
Birthday string - -
CountryCode string - -
CreatedAt datetime - -
Enabled boolean - -
Email string - -
IsGuest boolean - -
IsPending boolean - -
IsViewOnly boolean - -
JoinDate datetime - -
Location string - -
MobilePhone string - -
Phone string - -
PhotoOriginal string - -
TimeZoneIdentifier string - -
Title string - -
Url string - -
UtcHoursDiff int - -

UserTeam

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

Need more?

Why not check out our interactive Entity Relationship Diagram.