Monday.com is a collaboration platform that helps businesses to manage tasks, projects, and workflows to streamline communication, enhance productivity, and track progress.
Data integration: Skyvia supports importing data to and from Monday.com, exporting Monday.com data to CSV files, replicating Monday.com data to relational databases, and synchronizing Monday.com data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Monday.com.
Query: Skyvia Query supports Monday.com.
To create a connection to Monday.com, specify the Access Token.
To get the Access Token, do the following:
- Sign in to Monday.com.
Click the user icon on the left and select Developers.
Click Developer above and select My Access Tokens.
Click Show and copy the appeared access token value.
To connect to Monday.com, paste the obtained Access Token value to the corresponding box in the Connection Editor.
There are three types of Monday.com objects:
Users, Teams, Workspaces, Boards, BoardItemGroups, BoardViews, ActivityLogs, Docs, DocBlocks, Tags, Updates, UpdateAssets These objects have static metadata.
<BoardName>_Items and <BoardName>_Subitems Objects
Every Board created by a user in Monday.com UI has a corresponding object with <BoardName>_Items name, where <BoardName> is the name of the Board created by the user. Most of the fields in these objects are custom. Users manage these fields and define their types.
The <BoardName>_Subitems object is created when the corresponding Board has subitems.
Assets Type Objects
Every <BoardName>_Items and <BoardName>_Subitems field of the Assets type has a corresponding object with the <BoardName>_Items_<FieldName>_Assets and BoardName_Subitems_<FieldName>_Assets names, where _<BoardName>_ is the name of the Board created by the user and <FieldName> is a name of the field of the Assets type.
The following objects are read-only: Users, Teams, BoardViews, ActivityLogs, Docs, DocBlocks.
The Content field value in the UpdateAssets, <BoardName>_Items_<FieldName>_Assets, and <BoardName>_Subitems_<FieldName>_Assets objects contains the binary data of the assets binary data. Skyvia reads the Content values via additional API call for each record. Thus, querying this field significantly increases reading time and API calls usage.
Skyvia supports only asset type attachments. It doesn’t support files attached directly to the item records in the <BoardName>_Items or <BoardName>_Subitems objects.
You can insert tags with new Name values. If you try to insert a Tag with an already existing Name value, the API will return the Id of the existing record instead of inserting it.
The following Monday.com objects store the nested JSON objects:
You can use the nested objects supporting INSERT, UPDATE and DELETE operations in Import and Data Flow integrations.
DML Operations Support
|INSERT, UPDATE, DELETE||Boards, BoardItemGroups, <BoardName>_Items, <BoardName>_Subitems|
|INSERT, DELETE||Workspaces, Updates|
|INSERT||Tags, UpdateAssets, <BoardName>_Items_<FieldName>_Assets, <BoardName>_Subitems_<FieldName>_Assets|
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for the Users, Workspaces, Boards, ActivityLogs, Updates, UpdateAssets, <BoardName>_Items, <BoardName>_Subitems, <BoardName>_Items_<FieldName>_Assets, <BoardName>_Subitems_<FieldName>_Assets objects.
Replication detects only the new records for the Users, Workspaces, ActivityLogs, UpdateAssets, <BoardName>_Items_<FieldName>_Assets, <BoardName>_Subitems_<FieldName>_Assets object.
Skyvia supports Synchronization for the objects which contain the CreatedDate or UpdatedDate field and support the INSERT and UPDATE operations.
Skyvia supports all the common actions for Monday.com.