Explore the monday.com API data model

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

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	-

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	-