DocBlocks

Fetches content blocks within documents associated with workspaces.

Table-Specific Information

SELECT

The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品.

DocId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

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. 使用できる値は次のとおりです。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, page_break
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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.

ODBC Driver for Monday