DocBlocks
Fetches content blocks within documents associated with workspaces.
Table-Specific Information
SELECT
The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.
- DocId supports the '=','IN' comparison operators.
SELECT * FROM DocBlocks WHERE DocId = '9014425'
SELECT * FROM DocBlocks WHERE DocId IN ('9014425','9014490')
INSERT
The following inputs can be used in INSERT statements:
ParentBlockId, DocId, Content, Type, AfterBlockId
INSERT INTO DocBlocks (DocId,Type,Content,AfterBlockId) VALUES ('9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')
UPDATE
The following inputs can be used in UPDATE statements:
Content
UPDATE DocBlocks SET Content = '{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'
DELETE
You can delete entries by specifying the Id.
DELETE FROM DocBlocks WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the block within the document, ensuring each block can be individually referenced and tracked. | |
| ParentBlockId | String | False |
The unique identifier of the block's parent, establishing the hierarchical relationship between blocks in the document structure. | |
| DocId | String | False |
Docs.Id |
The unique identifier for the document to which the block belongs, helping link blocks to specific documents in the system. |
| CreatedById | String | False |
Users.Id |
The unique identifier of the user who created the block, allowing traceability of the block's origin and providing context for audit trails. |
| Position | Double | False |
The position of the block within the document, typically represented as a floating-point number to precisely determine its order or location relative to other blocks. | |
| Content | String | False |
The actual content of the block, which may include text, media, or other data, depending on the block type and intended usage. | |
| Type | String | False |
The type of content within the block, indicating whether it contains text, an image, or another format, helping to differentiate the block's role in the document. The allowed values are board, bulleted_list, check_list, code, divider, image, large_title, layout, medium_title, normal_text, notice_box, numbered_list, quote, small_title, table, video, widget. | |
| CreatedAt | Date | False |
The date and time when the block was created, providing a timestamp for when it was initially added to the document. | |
| UpdatedAt | Date | False |
The date and time when the block was last modified, tracking when changes were made to the block's content or attributes. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AfterBlockId | String |
The identifier of the block that should appear immediately before the current block, allowing precise control over the order of blocks within a document. If not provided, the block will be inserted first in the document. |