Retrieves content blocks from documents associated with boards. Requires a DocId or DocObjectId filter to narrow results.

Table-Specific Information

SELECT

Note: This table requires specifying DocId to retrieve data.

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 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 columns can be used to create a new record:

ParentBlockId, DocId, Content, Type

The following pseudo-column can be used to create a new record:

AfterBlockId

INSERT INTO BoardDocBlocks (ParentBlockId,DocId,Type,Content,AfterBlockId) VALUES ('63bb329e-246d-57f5-7d43-2a13e893b431','9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')

UPDATE

The following column can be updated:

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 following column:

Id

DELETE FROM BoardDocBlocks WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the block, used to distinguish it from other blocks in the document.
ParentBlockId	String	True		The unique identifier of the parent block, establishing hierarchical relationships between blocks.
DocId	String	True	BoardDocs.Id	The unique identifier of the document that contains this block.
CreatedById	String	True	Users.Id	The unique identifier of the user who created the block.
Position	Double	True		The position of the block within the document, used to determine its order.
Content	String	False		The content of the block, which could include text, media, or other data.
Type	String	True		Specifies the type of content stored in the block, such as text, image, or table. 使用できる値は次のとおりです。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	True		The date when the block was initially created.
UpdatedAt	Date	True		The date when the block was last updated.

Pseudo-Columns

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

Name	Type	Description
AfterBlockId	String	Specifies the unique identifier of the block after which this block should be inserted. If not provided, the block will be inserted at the beginning of the document.