Explore the monday.com data model

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

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

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 long - -
Name string - -
State string - -
OwnerID long User → ID -

Column

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

Column Type Relates to Notes
RemoteID string - -
BoardRemoteID string Board → RemoteID -
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 long Board → ID -
Title string - -
Type string - -
Archived boolean - -
Pos string -
  • 16 Jun 2020 The position on the board
SettingsStr string - -

Group

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

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

BoardTag

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

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 long - -
Event string - -
Entity string - -
Data string - -
CreatedAt long - -
BoardID long - -

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 long - -
Name string - -
State string - -
BoardID long Board → ID -
ParentItemID long Item → 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.

ColumnValue

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

Column Type Relates to Notes
RemoteID string - -
ItemRemoteID string Item → RemoteID -
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 long Item → ID -
BoardID long Board → ID -
Text string - -
Value string - -
ColumnRemoteID string - -

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 long - -
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 long - -
Name string - -
Birthday string - -
CountryCode string - -
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 - -
CreatedAt datetime - -
Enabled boolean - -

UserTeam

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

Need more?

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