JDBC Driver for Monday

Build 23.0.8839

Docs

Get a collection of docs.

View-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.
  • 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

INSERT statements are mapped to the 'create_doc' GraphQL mutation.

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

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 23.0.8839