Excel Add-In for Monday

Build 24.0.9062

BoardDocs

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

Table-Specific Information

SELECT

The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ItemId String

The item's unique identifier.

ColumnId String

The column's unique identifier.

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