Tables
The add-in models the data in Monday as a list of tables in a relational database that can be queried using standard SQL statements.
CData Excel Add-In for Monday Tables
Name | Description |
BoardDocBlocks | Get content blocks for documents in boards. This table requires specifying a DocId or DocObjectId filter. |
BoardDocs | Get a collection of docs from boards. This table requires specifying an Id or ObjectId filter. |
Boards | Get a collection of boards. |
BoardTeams | Get a board's team subscribers. |
BoardUsers | Get a board's subscribers. |
Columns | The board's visible columns. |
DocBlocks | Get content blocks for documents in workspaces. |
Docs | Get a collection of docs from workspaces. |
Folders | Get a collection of folders. Note that this won't return folders from closed workspaces to which you are not subscribed. |
Groups | Get a board's visible groups. |
Tags | Get a collection of tags. |
TeamUsers | Get a team's users. |
Updates | Get a collection of updates. |
Webhooks | Get a collection of webhooks. |
Workspaces | Get a collection of workspaces. |
WorkspaceTeams | Get the teams subscribed to the workspace. |
WorkspaceUsers | Get the users subscribed to the workspace. |