Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Monday.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Monday, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Monday Stored Procedures
| Name | Description |
| AddFileToColumn | Attaches a file to a specific column value in a board, enhancing item detail management. |
| AddFileToUpdate | Uploads and associates a file with a specific update in Monday. |
| BatchExtendTrialPeriod | Extends the trial period of an application for multiple selected accounts simultaneously. |
| ClearItemUpdates | Clears updates associated with a specific item on a board. |
| CreateDocBlock | Creates a new content block within a document in Monday. |
| CreateDocBoard | Creates a new document within a board. |
| CreateNotification | Sends a new notification to users, detailing specific events or updates. |
| DownloadAsset | Downloads a file uploaded to Monday.com by specifying the corresponding asset ID. |
| DuplicateBoard | Creates a duplicate of an existing board, including its items, columns, and structure. |
| DuplicateGroup | Duplicates an existing group within a board. |
| DuplicateItem | Duplicates an item within a board, including its associated data. |
| GetAccount | Retrieve information about the connected account. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Monday. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| LikeUpdate | Adds a 'like' to a specific update, indicating approval or acknowledgment. |
| MoveItemToBoard | Moves an item from its current board to a different board, transferring all associated data. |
| PinUpdate | Pins a specific update, keeping it at the top of the update list for better visibility. |
| RemoveMockAppSubscription | Removes a mock app subscription for the current account, typically used for testing purposes. |
| SetMockAppSubscription | Sets a mock app subscription for the current account, enabling testing scenarios. |
| UnpinUpdate | Unpins a previously pinned update, allowing it to return to its chronological position. |