Excel Add-In for Monday

Build 24.0.9062

Columns

The board's visible columns.

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.

  • Id supports the '=','IN' comparison operators.
  • BoardId supports the '=','IN' comparison operator.
  • Type supports the '=','IN' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM Columns WHERE Id = 'name'
SELECT * FROM Columns WHERE Id IN ('name', 'status')

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Settings, Title, Description, Type, AfterColumnId

INSERT INTO Columns (BoardId,Id,Type) VALUES ('3820334','custom_column_id_123','status')

UPDATE

The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):

Title, Description

UPDATE Columns SET Title='AnotherName' WHERE Id='name' AND BoardId='3820334'

DELETE

You can delete entries by specifying the Id and BoardId.

DELETE FROM Boards WHERE Id='test' AND BoardId='3820334'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The column's identifier, unique only to its board.

BoardId [KEY] String False

Boards.Id

The unique identifier of the board.

Archived Bool False

Whether or not the column is archived.

Settings String False

The column's settings in a string form.

Title String False

The column's title.

Description String False

The column's description.

Type String False

The column's type.

Width Int False

The column's width.

Pseudo-Columns

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

Name Type Description
AfterColumnId String

The column's unique identifier after which the new column will be inserted.

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