Get a collection of docs from workspaces.

Table-Specific Information

SELECT

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