BoardDocs

Get a collection of docs from boards. This table requires specifying an Id or ObjectId filter.

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.

Note: This table requires specifying either Id or ObjectId to retrieve data.

Id supports the '=','IN' comparison operators.
ObjectId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM BoardDocs WHERE Id = '9014425'
SELECT * FROM BoardDocs WHERE Id IN ('9014425','9014490')
SELECT * FROM BoardDocs WHERE Id IN (SELECT ColumnDocId FROM Board)
SELECT * FROM BoardDocs WHERE ObjectId = '5499548740'
SELECT * FROM BoardDocs WHERE ObjectId IN ('5499548740','5499563743')
SELECT * FROM BoardDocs WHERE ObjectId IN (SELECT ColumnObjectId FROM Board)

INSERT

The following inputs can be used in INSERT statements:

ItemId, ColumnId

INSERT INTO BoardDocs (ItemId, ColumnId) VALUES ('1647941525','monday_doc__1')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The document's unique identifier.
ObjectId	String	False		The associated object's unique identifier.
WorkspaceId	String	False	Workspaces.Id	The document's workspace unique identifier (null for main workspace).
CreatedById	String	False	Users.Id	The user's unique identifier.
DocKind	String	False		The document's kind (public / private / share). 使用できる値は次のとおりです。public, private, share
Name	String	False		The document's name.
RelativeUrl	String	False		The document's relative url.
Settings	String	False		The document's settings.
Url	String	False		The document's direct url.
CreatedAt	Date	False		The document's creation date.

Pseudo-Columns

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