| Date | Build
Number | Change
Type | Description |
| 02/22/2024 | 8818 | Monday | Added
- Added TeamUsers as a new table. This table can be used to retrieve the users that are part of a specific team. This table supports INSERT and DELETE operations.
- Added UPDATE support for Workspaces.
- Added SourceViewId to BoardViews.
Changed
- Updated supported API version to 2024-01.
- Renamed BoardTeamOwners to BoardTeams. This table can be used to retrieve the board's team subscribers and filter those that are owners by using the Kind column. Additionally, the table now supports INSERT and DELETE operations.
|
| 02/08/2024 | 8804 | Monday | Added
- Added BoardUsers, BoardTeamOwners, WorkspaceTeams, WorkspaceUsers as new tables to get information on the members of a board and workspace.
- Added Docs, DocBlocks as new table to get information on docs and their content.
- Added Folders as a new table to get information on folders.
- Added Webhooks as a new table to get information on webhooks.
- Added Workspaces as a new table to get information on workspaces.
- Added CUD operations support (INSERT, UPDATE, DELETE) to Boards, BoardUsers, Docs, DocBlocks, Folders, Groups, Tags, Updates, Webhooks, Workspaces, WorkspaceTeams, WorkspaceUsers, and all dynamically generated board tables. Refer to the documentation for the exact supported operations and example statements.
- Added AddFileToColumn, AddFileToUpdate, BatchExtendTrialPeriod, ClearItemUpdates, CreateDocBlock, CreateDocBoard, CreateNotification, DownloadAsset, DuplicateBoard, DuplicateGroup, DuplicateItem, GetOAuthAccessToken, GetOAuthAuthorizationUrl, LikeUpdate, MoveItemToBoard, SetMockAppSubscription, RemoveMockAppSubscription as stored procedures.
Changed
- Rewrote the data model to accurately support monday's structural hierarchy. The data model is now divided into three schema types; 'Information' for general views with information on your account's data, 'AuditLog' for the Audit Log API, and dynamically generated schemas based on the workspaces in your account. Workspaces are now pushed as their own schema with boards as their own tables. These tables include the basic columns from the now removed Items view, and all custom columns configured in the user interface. See the sample Workspace data model for an example board, subitems-type board, supported server-side filtering and CUD operations.
- Updated existing functionality and views to support API version 2023-10.
- Reduced MaxPointsPerCall default value from 1,000,000 to 100,000.
Removed
- Removed the Items, Columns and ColumnValues views since boards are now their own tables.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/09/2023 | 8713 | cis | Changed
- Salesforce with SSO Adapter reports the Double type as Doule type instead of Decimial type
- Salesforce with SSO Adapter supports create a table with Clob type column. The Clob type is mapped to Salesforce LongTextArea field.
|
| 10/10/2023 | 8683 | Monday | Removed
- Removed EncryptApiToken from Users.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 11/14/2022 | 8353 | Monday | Added
- Added ItemsCount column to Boards. This new field will return the number of items on boards across an account or across certain boards if specified in the query. Use ItemsCount with caution, as it comes with a high complexity cost.
- Added TeamsIds to Users.
- Added Email column to Items.
Removed
- Removed UserIds from Teams.
Added
- Added ItemsCount column to Boards. This new field will return the number of items on boards across an account or across certain boards if specified in the query. Use ItemsCount with caution, as it comes with a high complexity cost.
- Added TeamsIds to Users.
- Added Email column to Items.
Removed
- Removed UserIds from Teams.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 09/15/2022 | 8293 | Monday | Added
- Added new connection property 'Schema' with values: AuditLog and GraphQL.
- Added new connection property 'Domain' required for AuditLog schema only.
- Added new view for AuditLog schema.
Changed
- Changed existing views' schema from 'Monday' to 'GraphQL'
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|