SSIS Components for Monday

Build 24.0.9062

BoardTeams

Get a board's team subscribers.

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.

  • BoardId supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM BoardTeams WHERE BoardId='5557271485'

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Kind

INSERT INTO BoardTeams (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')

DELETE

You can delete entries by specifying the Id and BoardId.

DELETE FROM BoardTeams WHERE Id='51688059' AND BoardId='5546871560'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

Teams.Id

The board team's unique identifier.

BoardId [KEY] String False

Boards.Id

The unique identifier of the board.

Kind String False

The team's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners.

使用できる値は次のとおりです。owner

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