Get content blocks for documents in boards. This table requires specifying a DocId or DocObjectId filter.

Table-Specific Information

SELECT

The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

Note: This table requires specifying DocId to retrieve data.

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

For example, the following queries are processed server side:

SELECT * FROM BoardDocBlocks WHERE DocId = '9014425'
SELECT * FROM BoardDocBlocks WHERE DocId IN ('9014425','9014490')
SELECT * FROM BoardDocBlocks WHERE DocId IN (SELECT ColumnDocId FROM Board)

INSERT

The following inputs can be used in INSERT statements:

ParentBlockId, DocId, Content, Type, AfterBlockId

INSERT INTO BoardDocBlocks (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 BoardDocBlocks 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 BoardDocBlocks WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The block's unique identifier.
ParentBlockId	String	False		The block's parent block unique identifier.
DocId	String	False	BoardDocs.Id	The block's document unique identifier.
CreatedById	String	False	Users.Id	The user's unique identifier.
Position	Double	False		The block's position on the document.
Content	String	False		The block's content.
Type	String	False		The block content type. 使用できる値は次のとおりです。normal_text, large_title, medium_title, small_title, quote, divider, bulleted_list, numbered_list, check_list, image, video, table, layout, code, notice_box
CreatedAt	Date	False		The block's creation date.
UpdatedAt	Date	False		The block's last updated date.

Pseudo-Columns

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

Name	Type	Description
AfterBlockId	String	After which block to insert this one. If not provided, will be inserted first in the document.