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.

ActivityLog

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

Column	Type	Relates to	Notes
RemoteID	string	-	-
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	-	24 Feb 2025 Historically, this field came down in an invalid date format. It has since been rectified however we continue to cast to a string property type, for backwards compatibility
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 24 Feb 2025 Historically, this field came down in an invalid date format. It has since been rectified however we continue to cast to a string property type, for backwards compatibility
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	-