Monday への接続を追加

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. Monday アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからMonday コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Monday への接続

Monday AuditLog API

Monday AuditLog API は、API トークンによる認証のみをサポートしています。

監査ログAPI トークンを生成するには：

1. monday.com アカウントにログインします。
2. 画面右上のアバター（画像アイコン）をクリックします。
3. 表示されたメニューからAdministration を選択します。
4. 左側のナビゲーションでSecurity をクリックします。
5. Audit タブをクリックします。
6. Monitor by API -> Copy をクリックして、AuditLog API トークンをコピーします。

API トークンを取得した後、以下の接続プロパティを設定します。

• Schema："AuditLog" に設定。
• AuthScheme：Token
• APIToken：取得した監査ログAPI トークン
• URL：Monday アカウントURL。ログイン後、自身のMonday ホームページのURL をコピーできます。例：https://your-account-name.monday.com/。

Monday GraphQL API

Monday GraphQL API は、API トークンまたはOAuth 標準による認証をサポートしています。

API トークン

API トークンでSync App に接続するには、AuthScheme をToken に設定し、次の手順でAPIToken を取得します。

1. monday.com アカウントにログインします。
2. 画面右上のアバター（画像アイコン）をクリックします。
3. 表示されたメニューからAdministration を選択します（管理者権限が必要です）。
4. 左側のナビゲーションでConnections をクリックし、表示されたページでAPI タブをクリックします。
5. Personal API Token で、Create token をクリックしてパーソナルAPI トークンを作成します。APIToken 接続プロパティをこの値に設定します。
   • すでにトークンを作成している場合は、Personal API Token でCopy ボタンをクリックしてAPI トークンをコピーします。APIToken 接続プロパティをこの値に設定します。

OAuth

以下のサブセクションでは、3つの一般的な認証フローでのMonday への認証について詳しく説明します。

• デスクトップ：ユーザーのローカルマシン上でのサーバーへの接続で、テストやプロトタイピングによく使用されます。
• Web：共有ウェブサイト経由でデータにアクセスします。
• ヘッドレスサーバー：他のコンピュータやそのユーザーにサービスを提供する専用コンピュータで、モニタやキーボードなしで動作するように構成されています。

カスタムOAuth アプリケーションの作成については、カスタムOAuth アプリケーションの作成 を参照してください。

Monday で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

アクセストークンの期限が切れたときは、Sync App は自動でアクセストークンをリフレッシュします。

OAuth アクセストークンの自動リフレッシュ：

Sync App がOAuth アクセストークンを自動的にリフレッシュするようにするには、次のように設定します。

1. はじめてデータに接続する際、次の接続プロパティを設定します。
   • InitiateOAuth = REFRESH。
   • OAuthClientId = アプリケーション設定のクライアントId。
   • OAuthClientSecret = アプリケーション設定のクライアントシークレット。
   • OAuthAccessToken = によって返されたアクセストークン。
   • OAuthSettingsLocation = Sync App がOAuth 値を保存する場所のパス。これは接続間で維持されます。
2. その後のデータ接続では、以下を設定します。
   • InitiateOAuth
   • OAuthSettingsLocation

このセクションでは、Monday Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

詳しくは、クエリ処理 を参照してください。

ログ

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

CData Sync App はMonday データをテーブル、ビュー、ストアドプロシージャを備えた使いやすいSQL データベースとしてモデル化します。

プロバイダーは3種類のスキーマを公開します。

• Information データモデル には、Monday.com プラットフォーム上のワークマネジメントに関連するデータを構造化し、整理するテーブルが含まれています。ボード、アイテム、カラム、および更新がどのように相互作用するかを定義します。
• AuditLog データモデル には、システムイベントとユーザーアクションを追跡し、ログに記録するための構造化された方法を提供するテーブルが含まれています。
• Workspace データモデル には、Monday.com アカウント内のワークスペースの構造と組織を定義するテーブルが含まれています。

In the Information Data Model schema, the provider models the data entities and relationships with the Monday.com platform as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Monday.com account are immediately reflected in the provider.

Tables

The テーブル section, which details standard SQL tables, and the ビュー section, which lists read-only SQL tables, contain samples of what you may have access to in your Monday account.

Common tables include:

Stored Procedures

ストアドプロシージャ are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including duplicating items in a board, adding a file to a column value in a board, and sending a new notification to users.

Sync App はMonday のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Monday Connector for CData Sync テーブル

Retrieve metadata about apps built with the apps framework.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App

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

For example, the following queries are processed server-side:

  SELECT * FROM Apps WHERE Id = '10483971'
  SELECT * FROM Apps WHERE Id IN ('10483971', '10483972')

INSERT

The following columns can be used to create a new record:

Name, Kind, Description, Permissions, Slug, WebhookURL, CollaboratorIds

UPDATE

The following columns can be updated:

Name, Kind, Description, Permissions, Slug, WebhookURL, CollaboratorIds

Columns

Retrieves content blocks from documents associated with boards. Requires a DocId or DocObjectId filter to narrow results.

Table-Specific Information

SELECT

Note: This table requires specifying DocId to retrieve data.

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• DocId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM BoardDocBlocks WHERE DocId = '9014425'
  SELECT * FROM BoardDocBlocks WHERE DocId IN ('9014425','9014490')
  SELECT * FROM BoardDocBlocks WHERE DocId IN (SELECT ColumnDocId FROM Board)

INSERT

The following columns can be used to create a new record:

ParentBlockId, DocId, Content, Type

The following pseudo-column can be used to create a new record:

AfterBlockId

INSERT INTO BoardDocBlocks (ParentBlockId,DocId,Type,Content,AfterBlockId) VALUES ('63bb329e-246d-57f5-7d43-2a13e893b431','9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')

UPDATE

The following column can be updated:

Content

UPDATE BoardDocBlocks SET Content='{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM BoardDocBlocks WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

Pseudo-Columns

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

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 Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• 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 = 'Val1'
  SELECT * FROM BoardDocs WHERE ObjectId = 'Val1'

INSERT

The following column can be used to create a new record:

The following pseudo-columns can be used to create a new record:

ItemId, ColumnId

Columns

Pseudo-Columns

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

Retrieves a collection of boards, including their details and associated data.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the =, IN comparison operators.
• BoardKind supports the = comparison operator.
• State supports the = comparison operator.
• WorkspaceId supports the =, IN comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Boards WHERE Id = '2181960030'
  SELECT * FROM Boards WHERE Id IN ('2307103055', '2182296646', '2181960030')
  SELECT * FROM Boards WHERE BoardKind = 'public'
  SELECT * FROM Boards WHERE State = 'Val1'
  SELECT * FROM Boards WHERE WorkspaceId = '1345997021'

INSERT

The following columns can be used to create a new record: Name, Description, BoardKind, BoardFolderId, and WorkspaceId.

The following pseudo-columns can be used to create a new record: ItemNicknamePlural, ItemNicknamePresetType, ItemNicknameSingular, TemplateId, BoardOwnerIds, BoardOwnerTeamIds, BoardSubscriberIds, BoardSubscriberTeamIds, and Empty.

UPDATE

The following columns can be updated: Name, Description, Communication, and State.

The following pseudo-column can be used to update a record: BasicRoleName.

DELETE

You can delete entries by specifying the following column: Id.

Columns

Pseudo-Columns

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

Fetches a list of team subscribers associated with a specific board.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• BoardId supports the '=' comparison operator.
• Kind supports the '=','IN' comparison operators.

SELECT * FROM BoardTeams WHERE BoardId='5557271485'
SELECT * FROM BoardTeams WHERE Kind = 'owner'

INSERT

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

The following inputs can be used in INSERT statements:

Id, BoardId, Kind

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

DELETE

Note: API limitations may cause affected row counts to be reported inaccurately when attempting to delete relationships between entities that are not related.

You can delete entries by specifying the Id and BoardId.

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

Columns

Retrieves a list of user subscribers for a specific board.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• BoardId supports the '=','IN' comparison operators.
• Kind supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM BoardUsers WHERE BoardId = 'Val1'
  SELECT * FROM BoardUsers WHERE Kind = 'owner'

INSERT

The following columns can be used to create a new record:

Id, BoardId, Kind

DELETE

You can delete entries by specifying the following columns:

Id, BoardId

Columns

Fetches a list of views configured for a specific board.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operators.
• Type supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM BoardViews WHERE Id = 'Val1'
  SELECT * FROM BoardViews WHERE BoardId = 'Val1'
  SELECT * FROM BoardViews WHERE Type = 'Val1'

INSERT

The following columns can be used to create a new record:

BoardId, Name, Settings, Type, FilterTeamId, FilterUserId, Sort, Tags

The following pseudo-columns can be used to create a new record:

FilterGroups (references ViewQueryGroup), FilterOperator, FilterRules (references ViewQueryRule)

ViewQueryGroup Temporary Table Columns

ViewQueryRule Temporary Table Columns

UPDATE

The following columns can be updated:

Name, Settings, Type, FilterTeamId, FilterUserId, Sort, Tags

The following pseudo-columns can be used to update a record:

FilterGroups (references ViewQueryGroup), FilterOperator, FilterRules (references ViewQueryRule)

ViewQueryGroup Temporary Table Columns

ViewQueryRule Temporary Table Columns

DELETE

You can delete entries by specifying the following columns:

Id, BoardId

Columns

Pseudo-Columns

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

Retrieves the visible columns for a specific board, providing structural information.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operators.
• Type supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Columns WHERE Id = 'name'
  SELECT * FROM Columns WHERE Id IN ('name', 'status')
  SELECT * FROM Columns WHERE BoardId = '128443935'
  SELECT * FROM Columns WHERE Type = 'board-relation'

INSERT

The following columns can be used to create a new record:

Id, BoardId, Settings, Title, Description, Type, CapabilitiesFunction

The following pseudo-columns can be used to create a new record:

AfterColumnId, SettingsLabels (references ColumnSettings), SettingsDropdownLimitCount, SettingsDropdownLimitSelect

ColumnSettings Temporary Table Columns

UPDATE

The following columns can be updated:

Settings, Title, Description, Type, Revision, CapabilitiesFunction

The following pseudo-columns can be used to update a record:

SettingsLabels (references ColumnSettings), SettingsDropdownLimitCount, SettingsDropdownLimitSelect

ColumnSettings Temporary Table Columns

DELETE

You can delete entries by specifying the following columns:

Id, BoardId

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

Columns

Pseudo-Columns

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

Retrieves metadata about custom activities in the Email and Activities timeline for enhanced activity tracking.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• Name supports the '=' comparison operator.
• IconId supports the '=' comparison operator.
• Color supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM CustomActivities WHERE Id ='a91e9318-798a-44a6-80a4-49a14e23c015'
  SELECT * FROM CustomActivities WHERE Name = 'TestName'
  SELECT * FROM CustomActivities WHERE IconId = 'ASCENDING'
  SELECT * FROM CustomActivities WHERE Color = 'BRINK_PINK'

INSERT

The following columns can be used to create a new record:

Name, IconId, Color

INSERT INTO CustomActivities (Name, IconId, Color) values ('CActivity', 'CAMERA', 'MEDIUM_TURQUOISE')

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM CustomActivities WHERE Id='a91e9318-798a-44a6-80a4-49a14e23c015'

Columns

Fetches content blocks within documents associated with workspaces.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• DocId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM DocBlocks WHERE DocId = '9014425'
  SELECT * FROM DocBlocks WHERE DocId IN ('9014425','9014490')'

INSERT

The following columns can be used to create a new record:

ParentBlockId, DocId, Content, Type

The following pseudo-column can be used to create a new record:

AfterBlockId

INSERT INTO DocBlocks (DocId,Type,Content,AfterBlockId) VALUES ('9180448','code','{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"Test"}]}','53ab947f-226f-49f5-8d43-1021f9f36431')

UPDATE

The following column can be updated:

Content

UPDATE DocBlocks SET Content = '{"alignment":"left","direction":"ltr","deltaFormat":[{"insert":"NewValue"}]}' WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM DocBlocks WHERE Id = '9b24043b-6ea9-46b0-9f0a-1ec226f12d21'

Columns

Pseudo-Columns

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

Retrieves a collection of documents from workspaces, including their metadata.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

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

For example, the following queries are processed server-side:

  SELECT * FROM Docs WHERE Id = '9014425'
  SELECT * FROM Docs WHERE Id IN ('9014425','9014490')
  SELECT * FROM Docs WHERE ObjectId = '5499548740'
  SELECT * FROM Docs WHERE ObjectId IN ('5499548740','5499563743')
  SELECT * FROM Docs WHERE WorkspaceId = '3578971'

INSERT

The following columns can be used to create a new record:

WorkspaceId, DocKind, Name

INSERT INTO Docs (WorkspaceId,DocKind,Name) VALUES ('3820334','public','CreatedDoc')

UPDATE

The following column can be updated:

Name

DELETE

You can delete entries by specifying the following column:

Id

Columns

Retrieve a user's favorites data via the API.

Table-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM Favorites

INSERT

The following columns can be used to create a new record:

ObjectId, ObjectType

The following pseudo-columns can be used to create a new record:

Name, NextObjectId, NextObjectType, PrevObjectId, PrevObjectType

UPDATE

The following column can be updated:

FolderId

The following pseudo-columns can be used to update a record:

NextObjectId, NextObjectType, PrevObjectId, PrevObjectType

DELETE

You can delete entries by specifying the following columns:

ObjectId, ObjectType

Columns

Pseudo-Columns

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

Retrieves a collection of folders within workspaces. Excludes folders in closed workspaces unless you are subscribed to them.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Folders WHERE Id = '12622355'
  SELECT * FROM Folders WHERE WorkspaceId = '3578971'

INSERT

The following columns can be used to create a new record:

ParentId, WorkspaceId, Color, Name

INSERT INTO Folders (WorkspaceId,Name,Color) VALUES ('3578971','TestFolder','BRIGHT_BLUE')

UPDATE

The following columns can be updated:

ParentId, WorkspaceId, Color, Name

The following pseudo-columns can be used to update a record:

AccountProductId, PositionIsAfter, PositionObjectId, PositionObjectType

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM Folders WHERE Id='12678064'

Columns

Pseudo-Columns

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

Retrieves the visible groups for a specified board, providing a structured view of grouped items.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Groups WHERE Id = 'topics'
  SELECT * FROM Groups WHERE Id IN ('topics', 'group_title')
  SELECT * FROM Groups WHERE BoardId IN ('2182296646', '21822966')
  SELECT * FROM Groups WHERE BoardId = '2182296646' AND Id = 'topics'

INSERT

The following columns can be used to create a new record:

BoardId, Color, Title

The following pseudo-columns can be used to create a new record:

RelativeTo, PositionRelativeMethod

INSERT INTO Groups (BoardId,Title,Color,RelativeTo,PositionRelativeMethod) VALUES ('5525287714','NewGroup','#9CD326','testgroup','after_at')

UPDATE

The following columns can be updated:

Archived, Color, Title

The following pseudo-columns can be used to update a record:

RelativePositionAfter, RelativePositionBefore

UPDATE Groups SET Color = '#9CD326' WHERE BoardId = '5525287714' AND Id = 'newgroup'
UPDATE Groups SET Archived = 'true' WHERE BoardId='5525287714' AND Id = 'newgroup'

DELETE

You can delete entries by specifying the following columns:

Id, BoardId

DELETE FROM Groups WHERE BoardId = '5525287714' AND Id = 'testgroup'

Columns

Pseudo-Columns

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

Your accounts managed columns.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• State supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM ManagedColumns WHERE Id = '124423723'
  SELECT * FROM ManagedColumns WHERE State = 'active'

INSERT

The following columns can be used to create a new record:

Title, Description

The following pseudo-column can be used to create a new record:

Settings (references ColumnSettings)

ColumnSettings Temporary Table Columns

UPDATE

The following columns can be updated:

Title, Description, State, Revision

The following pseudo-column can be used to update a record:

Settings (references ColumnSettings)

ColumnSettings Temporary Table Columns

DELETE

You can delete entries by specifying the following column:

Id

Columns

Pseudo-Columns

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

Get metadata for a collection of objects.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• PrivacyKind supports the '=' comparison operator.
• State supports the '=' comparison operator.
• WorkspaceId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Objects WHERE Id = '121246772'
  SELECT * FROM Objects WHERE PrivacyKind = 'PRIVATE'
  SELECT * FROM Objects WHERE State = 'ACTIVE'
  SELECT * FROM Objects WHERE WorkspaceId = '12885370'

INSERT

The following columns can be used to create a new record:

Description, FolderId, Name, OwnerIds, PrivacyKind, SubscriberIds, WorkspaceId

The following pseudo-columns can be used to create a new record:

ObjectTypeUniqueKey, OwnerTeamIds, SubscriberTeamIds, Payload

UPDATE

The following columns can be updated:

Description, Name, OwnerIds, PrivacyKind, State, SubscriberIds

The following pseudo-column can be used to update a record:

Kind

DELETE

You can delete entries by specifying the following column:

Id

Columns

Pseudo-Columns

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

Retrieves a collection of tags used to categorize and filter items across boards.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• IsPrivate supports the '=' comparison operator.
• BoardId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Tags WHERE IsPrivate = true
  SELECT * FROM Tags WHERE Id = '13327214'
  SELECT * FROM Tags WHERE Id IN ('13327214', '13327217')

INSERT

The following columns can be used to create a new record:

Name, BoardId

INSERT INTO Tags (Name) VALUES ('TestTagName')

Columns

Get a collection of teams.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

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

For example, the following queries are processed server-side:

  SELECT * FROM Teams WHERE Id = '565332'
  SELECT * FROM Teams WHERE Id IN ('565332, 565333')

INSERT

The following columns can be used to create a new record:

Name, IsGuestTeam

The following pseudo-columns can be used to create a new record:

ParentTeamId, TeamSubscriberIds, AllowEmptyTeam

DELETE

You can delete entries by specifying the following column:

Id

Columns

Pseudo-Columns

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

Get a team's users.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• TeamId supports the '=','IN' comparison operators.
• Kind supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM TeamUsers WHERE TeamId = 'Val1'
  SELECT * FROM TeamUsers WHERE Kind = 'member'

INSERT

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

The following columns can be used to create a new record:

Id, TeamId

INSERT INTO TeamUsers (Id, TeamId) VALUES ('57410919', '1127299')

UPDATE

The following column can be updated:

Kind

DELETE

Note: API limitations may cause affected row counts to be reported inaccurately when attempting to delete relationships between entities that are not related.

You can delete entries by specifying the following columns:

Id, TeamId

DELETE FROM TeamUsers WHERE Id = '51688059' AND TeamId = '3820334'

Columns

Get metadata about items in the Email and Activities timeline.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• ItemId supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM TimelineItems WHERE Id ='2b748808-9311-4f76-80de-49baac5609e1'
  SELECT * FROM TimelineItems WHERE ItemId ='9016504235'

INSERT

The following columns can be used to create a new record:

Title, CustomActivityId, Content, Timestamp, ItemId

The following pseudo-columns can be used to create a new record:

Summary, Location, Phone, Url, TimeRangeStartTimestamp, TimeRangeEndTimestamp

INSERT INTO TimelineItems(ItemId, CustomActivityId, Location, Title, Summary, Content, Timestamp, TimeRangeStartTimestamp, TimeRangeEndTimestamp, phone, url) VALUES ( '7832826517', '8baadd0b-5b64-4ecb-a035-1f5824507f98', 'X', 'Migrated Timeline', 'Works summary', 'Test', '2024-06-06T18:00:30Z', '2024-04-06T15:00:30Z', '2024-05-06T19:00:30Z', '1234-5678', 'https://www.test.com');

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM TimelineItems WHERE Id='2b748808-9311-4f76-80de-49baac5609e1'

Columns

Pseudo-Columns

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

Fetches a collection of updates, including user comments, status changes, and other activity logs.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• ItemId supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operators.
• BoardUpdatesOnly supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM Updates WHERE Id = '173981152'
  SELECT * FROM Updates WHERE Id IN ('173981152','173981153')
  SELECT * FROM Updates WHERE ItemId = '1388002886'
  SELECT * FROM Updates WHERE ItemId IN ('1388002886','123923141')
  SELECT * FROM Updates WHERE BoardId = '1388002765'
  SELECT * FROM Updates WHERE BoardUpdatesOnly = true

INSERT

The following columns can be used to create a new record:

Body, CreatedAt, ItemId

The following pseudo-columns can be used to create a new record:

ParentId, MentionsList (references UpdateMention), UseAppInfo

UpdateMention Temporary Table Columns

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM Updates WHERE Id = '2553512994'

Columns

Pseudo-Columns

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

Retrieves a collection of users, including their details and roles.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• TeamsIds supports the '=','IN' comparison operators.
• Email supports the '=','IN' comparison operators.
• IsGuest supports the '=' comparison operator.
• IsPending supports the '=' comparison operator.
• NonActive supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM Users ORDER BY CreatedAt DESC
  SELECT * FROM Users WHERE IsPending = true
  SELECT * FROM Users WHERE IsGuest = true
  SELECT * FROM Users WHERE Id = '27278379'
  SELECT * FROM Users WHERE Id IN ('27278379', '27278377')
  SELECT * FROM Users WHERE Email = '[email protected]'
  SELECT * FROM Users WHERE Email IN ('[email protected]', '[email protected]')
  SELECT * FROM Users WHERE TeamsIds = '915408'
  SELECT * FROM Users WHERE NonActive = true

UPDATE

The following columns can be updated:

Name, Phone, Birthday, Email, JoinDate, Location, MobilePhone, Title

The following pseudo-columns can be used to update a record:

Department, BypassConfirmationForClaimedDomains, RoleName, RoleId

UPDATE Users SET Name = 'AnotherName' WHERE Id = '5549166043'
UPDATE Users SET RoleName = 'ADMIN' WHERE Id = '5549166043'

Columns

Pseudo-Columns

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

Fetches a collection of webhooks, including their configuration and associated events.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• BoardId supports the '=','IN' comparison operators.
• AppWebhooksOnly supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM Webhooks WHERE BoardId = '5574930939'
  SELECT * FROM Webhooks WHERE AppWebhooksOnly = true

INSERT

The following columns can be used to create a new record:

BoardId, Config, Event

The following pseudo-column can be used to create a new record:

Url

INSERT INTO Webhooks (BoardId,Config,Event,Url) VALUES ('5574930939','{\"columnId\":\"status\", \"columnValue\":{\"$any$\":true}}','change_status_column_value','https://test.com/')

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM Webhooks WHERE Id = '242031214'

Columns

Pseudo-Columns

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

Get a collection of question for the specified formToken.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

• Token supports the '=' comparison operator.

For example, the following query is processed server-side:

  SELECT * FROM WorkformQuestions WHERE Token = 'Val1'

INSERT

The following columns can be used to create a new record:

Token, Description, Options, Required, Title, Type, Visible, SettingsCheckedByDefault, SettingsDefaultCurrentDate, SettingsDisplay, SettingsIncludeTime, SettingsLimit, SettingsLocationAutofilled, SettingsOptionsOrder, SettingsPrefillEnabled, SettingsPrefillLookup, SettingsPrefillSource, SettingsPrefixAutofilled, SettingsPrefixPredefinedEnabled, SettingsPrefixPredefinedPrefix, SettingsSkipValidation

UPDATE

The following columns can be updated:

Description, Required, Title, Type, Visible, SettingsCheckedByDefault, SettingsDefaultCurrentDate, SettingsDisplay, SettingsIncludeTime, SettingsLimit, SettingsLocationAutofilled, SettingsOptionsOrder, SettingsPrefillEnabled, SettingsPrefillLookup, SettingsPrefillSource, SettingsPrefixAutofilled, SettingsPrefixPredefinedEnabled, SettingsPrefixPredefinedPrefix, SettingsSkipValidation

DELETE

You can delete entries by specifying the following columns:

Id, Token

Columns

Get a collection of forms.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

• Token supports the '=' comparison operator.

For example, the following query is processed server-side:

  SELECT * FROM Workforms WHERE Token = 'Val1'

INSERT

The following column can be used to create a new record:

The following pseudo-columns can be used to create a new record:

BoardKind, BoardOwnerIds, BoardOwnerTeamIds, BoardSubscriberIds, BoardSubscriberTeamsIds, DestinationFolderId, DestinationFolderName, DestinationName, DestinationWorkspaceId

UPDATE

The following columns can be updated:

AccessibilityLanguage, AccessibilityLogoAltText, Description, Title, AppearanceHideBranding, AppearancePrimaryColor, AppearanceShowProgressBar, AppearanceSubmitButton, AppearanceTextColor, AppearanceTextFont, AppearanceTextSize, AppearanceBackgroundType, AppearanceBackgroundValue, AppearanceLayoutAlignment, AppearanceLayoutDirection, AppearanceLayoutFormFormat, AppearanceFormLogoPosition, AppearanceFormLogoSize, FeaturesDraftSubmissionEnabled, FeaturesIsInternal, FeaturesPasswordEnabled, FeaturesReCaptchaChallenge, FeaturesAfterSubmissionViewAllowEditSubmission, FeaturesAfterSubmissionViewAllowResubmit, FeaturesAfterSubmissionViewAllowViewSubmission, FeaturesAfterSubmissionViewDescription, FeaturesAfterSubmissionViewRedirectAfterSubmissionEnabled, FeaturesAfterSubmissionViewRedirectAfterSubmissionRedirectURL, FeaturesAfterSubmissionViewShowSuccessImage, FeaturesAfterSubmissionViewTitle, FeaturesCloseDate, FeaturesCloseDateEnabled, FeaturesMondayIncludeNameQuestion, FeaturesMondayIncludeUpdateQuestion, FeaturesMondayItemGroupId, FeaturesMondaySyncQuestionAndColumnsTitles, FeaturesPreSubmissionViewDescription, FeaturesPreSubmissionViewEnabled, FeaturesPreSubmissionViewStartButton, FeaturesPreSubmissionViewTitle, FeaturesRequireLoginEnabled, FeaturesRequireLoginRedirectToLogin, FeaturesResponseLimit, FeaturesResponseLimitEnabled, FeaturesShortenedLinkEnabled, FeaturesShortenedLinkURL

The following pseudo-columns can be used to update a record:

Questions, Password

Columns

Pseudo-Columns

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

Get a collection of tags for the specified formToken.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process WHERE clause conditions built with the following column and operator. The Sync App processes other filters client-side within the Sync App.

• Token supports the '=' comparison operator.

For example, the following query is processed server-side:

  SELECT * FROM WorkformTags WHERE Token = 'Val1'

INSERT

The following columns can be used to create a new record:

Token, Name, Value

UPDATE

The following column can be updated:

Value

DELETE

You can delete entries by specifying the following columns:

Id, Token

Columns

Pseudo-Columns

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

Retrieves a collection of workspaces, including their names and details.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Id supports the '=','IN' comparison operators.
• Kind supports the '=' comparison operator.
• State supports the '=' comparison operator.

For example, the following queries are processed server-side:

  SELECT * FROM Workspaces WHERE Id = '3578971'
  SELECT * FROM Workspaces WHERE Id IN ('3578971','3578972')
  SELECT * FROM Workspaces WHERE Kind = 'open'
  SELECT * FROM Workspaces WHERE State = 'active'

INSERT

The following columns can be used to create a new record:

Description, Kind, Name, AccountProductId

INSERT INTO Workspaces (Name,Kind,Description,AccountProductId) VALUES ('New Workspace','open','This is my new workspace.','1244553456')

UPDATE

The following columns can be updated:

Description, Kind, Name, AccountProductId

UPDATE Workspaces SET Description = 'testDescription', Name = 'testName', Kind = 'open', AccountProductId='1244553456' WHERE Id = '3819431'

DELETE

You can delete entries by specifying the following column:

Id

DELETE FROM Workspaces WHERE Id = '3819431'

Columns

Retrieves the list of teams subscribed to a specific workspace.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• WorkspaceId supports the '=','IN' comparison operators.
• Kind supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM WorkspaceTeams WHERE WorkspaceId = '3820334'
  SELECT * FROM WorkspaceTeams WHERE Kind = 'owner'

INSERT

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

The following columns can be used to create a new record:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','subscriber')
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','owner')

DELETE

You can delete entries by specifying the following columns:

Id, WorkspaceId

DELETE FROM WorkspaceTeams WHERE Id = '961021' AND WorkspaceId = '3820334'

Columns

Fetches the list of users subscribed to a specific workspace.

Table-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• WorkspaceId supports the '=','IN' comparison operators.
• Kind supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM WorkspaceUsers WHERE WorkspaceId = '3578971'
  SELECT * FROM WorkspaceUsers WHERE Kind = 'owner'

INSERT

This table supports BATCH INSERT. The following columns can be used to create a new record:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceUsers (Id, WorkspaceId, Kind) VALUES ('51688059', '3820334', 'subscriber')

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

DELETE

This table supports BATCH DELETE. You can delete entries by specifying the following columns:

Id, WorkspaceId

DELETE FROM WorkspaceUsers WHERE Id = '51688059' AND WorkspaceId = '3820334'
DELETE FROM WorkspaceUsers WHERE EXISTS SELECT Id, WorkspaceId FROM WorkspaceUsers#TEMP

Columns

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Monday Connector for CData Sync ビュー

Retrieve information about the account's active products.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM AccountProducts

Columns

Retrieve metadata about an account's default and custom user roles.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM AccountRoles

Columns

Fetches the activity log events associated with a specific board, detailing recent updates and actions.

View-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• BoardId supports the '=','IN' comparison operators.
• UserId supports the '=','IN' comparison operators.
• CreatedAt supports the '<','<=','>','>=' comparison operators.
• ColumnId supports the '=','IN' comparison operators.
• GroupId supports the '=','IN' comparison operators.
• ItemId supports the '=','IN' comparison operators.

SELECT * FROM ActivityLogs WHERE BoardId IN ('2307103055', '2182296646')
SELECT * FROM ActivityLogs WHERE UserId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ColumnId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE GroupId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE ItemId IN ('27278379', '28087608')
SELECT * FROM ActivityLogs WHERE CreatedAt > '2022-02-17 05:12:04.419' AND CreatedAt < '2022-02-17 05:12:04.861'
SELECT * FROM ActivityLogs WHERE CreatedAt >= '2022-02-17 05:12:04.419' AND CreatedAt <= '2022-02-17 05:12:04.861'

Columns

Get all app collaborators.

View-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• AppId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM AppCollaborators WHERE AppId = '10483971'
  SELECT * FROM AppCollaborators WHERE AppId IN ('10483971', '10483972')

Columns

Retrieves a collection of assets based on provided asset IDs, such as files or media associated with items.

View-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

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

For example, the following query is processed server-side:

  SELECT * FROM Assets WHERE Id = 'Val1'

Columns

Get a list of all supported audit log events.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM AuditEventCatalogues

Columns

The schema for a specific column type.

View-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• Type supports the '=','IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM ColumnTypeSchema WHERE Type = 'auto_number'
  SELECT * FROM ColumnTypeSchema WHERE Type IN ('auto_number','board-relation')

Columns

Breakdown of API usage for the top six apps over the past 14 days. This table is available only with a Monday Enterprise account.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM PlatformUsageByApp

Columns

Breakdown of API usage per day over the past 14 days. This table is available only with a Monday Enterprise account.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM PlatformUsageByDay

Columns

Breakdown of API usage for the top six users over the past 14 days. This table is available only with a Monday Enterprise account.

View-Specific Information

SELECT

The Sync App processes all filters client-side within the Sync App. The following query is the only one processed server-side:

  SELECT * FROM PlatformUsageByUser

Columns

Retrieves the viewers associated with updates.

View-Specific Information

SELECT

The Sync App uses the Monday API to process some of the filters. The Sync App processes other filters client-side within the Sync App.

• UpdateId supports the '=','IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM UpdateViewers WHERE UpdateId = '3578971'
  SELECT * FROM UpdateViewers WHERE UpdateId IN ('173981152','173981153')

Columns

ストアドプロシージャはファンクションライクなインターフェースで、Monday の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずSync App の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMonday から関連するレスポンスデータを返します。

Monday Connector for CData Sync ストアドプロシージャ

Adds markdown content to an existing document by converting it into document blocks.

Input

Result Set Columns

Attaches a file to a specific column value in a board, enhancing item detail management.

Input

Result Set Columns

Uploads and associates a file with a specific update in Monday.

Input

Result Set Columns