CData Python Connector for Monday

Build 23.0.8839


Get a document's content blocks.

View-Specific Information


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 statements are mapped to the 'create_doc_block' GraphQL mutation.

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 statements are mapped to the 'update_doc_block' GraphQL mutation.

The following inputs can be used in UPDATE statements:

Id, Content

UPDATE DocBlocks SET Content='{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'


DELETE statements are mapped to the 'delete_doc_block' GraphQL mutation.

You can delete entries by specifying the Id.

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


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


The block's document unique identifier.

CreatedById String False


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.

CreatedAt Date False

The block's creation date.

UpdatedAt Date False

The block's last updated date.


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839