BoardDocs

Fetches a collection of documents associated with boards. Requires specifying an Id or ObjectId filter to identify the desired documents.

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.

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		A unique identifier for the document within the system, ensuring each document is distinctly recognized.
ObjectId	String	False		The unique identifier of the object associated with this document, linking the document to its parent entity.
WorkspaceId	String	False	Workspaces.Id	The unique identifier of the workspace where the document resides. A null value indicates it belongs to the main workspace.
CreatedById	String	False	Users.Id	The unique identifier of the user who created the document, allowing for tracking of document ownership.
DocKind	String	False		Specifies the document's visibility or access type, such as public, private, or shared. The allowed values are public, private, share.
Name	String	False		The name assigned to the document, used for identification and display purposes.
RelativeUrl	String	False		The relative URL of the document, specifying its location within the application's directory structure.
Settings	String	False		A JSON or serialized string containing configuration and settings specific to the document.
Url	String	False		The direct URL link to access the document, typically used for navigation.
CreatedAt	Date	False		The date and time when the document was created, stored in the system's standard date format.

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.