Get content blocks for documents in 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. 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.

• 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 block's unique identifier.
ParentBlockId	String	False		The block's parent block unique identifier.
DocId	String	False	Docs.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.