TDV Adapter for Monday

Build 24.0.9060

Docs

Get a collection of docs from workspaces.

Table-Specific Information

SELECT

The adapter uses the Monday API to process some of the filters. The adapter processes other filters client-side within the adapter. 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.
  • 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 inputs can be used in INSERT statements:

WorkspaceId, DocKind, Name

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

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The document's unique identifier.

DocFolderId String False

Folders.Id

The document's folder unique identifier (null for first level).

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).

The allowed values are 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.

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