Get content blocks for documents in workspaces.

Table-Specific Information

SELECT

The cmdlet uses the Monday API to process some of the filters. The cmdlet processes other filters client-side within the cmdlet. 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. The allowed values are 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

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	After which block to insert this one. If not provided, will be inserted first in the document.