2024 is the year of the connector - vote here

Explore the monday.com API data model

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

Pulling data from the monday.com 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 monday.com 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

ActivityLog

Documentation: https://developer.monday.com/api-reference/docs/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)
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID guid - -
AccountID long - -
Event string - -
Entity string - -
Data string - -
CreatedAt long - -
BoardID long Board → ID -
UserID long User → ID -
ItemID long Item → ID -

Board

Documentation: https://developer.monday.com/api-reference/docs/boards

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
BoardFolderID long - -
ItemsCount int - -
ItemTerminology string - -
UpdatedAt datetime - -
Type string - -
WorkspaceID long Workspace → ID -
State string - -
OwnerID long User → ID -
WhenLastActivityLog datetime - -

Column

Documentation: https://developer.monday.com/api-reference/docs/columns

Column Type Relates to Notes
RemoteID string - -
BoardRemoteID string Board → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 - -
SettingsStr string - -

ColumnValue

Documentation: https://developer.monday.com/api-reference/docs/column-values-v2

Column Type Relates to Notes
RemoteID string - -
ItemRemoteID string Item → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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 - -
Typename string - -
ColumnRemoteID string - -

Group

Documentation: https://developer.monday.com/api-reference/docs/groups

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

Item

Documentation: https://developer.monday.com/api-reference/docs/items

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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
WhenLastColumnValueChanged datetime - -
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://developer.monday.com/api-reference/docs/teams

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

User

Documentation: https://developer.monday.com/api-reference/docs/users

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
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 - -

Workspace

Documentation: https://developer.monday.com/api-reference/docs/workspace-queries

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
State string - -
Kind string - -
CreatedAt datetime - -

BoardTag

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

UserTeam

Column Type Relates to Notes
RemoteID string - -
UserRemoteID string User → RemoteID -
WhenUpsertedIntoDataStore datetime - -
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.