Docs
Get a collection of docs.
View-Specific Information
SELECT
The add-in uses the Monday API to process some of the filters. The add-in processes other filters client-side within the add-in. 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.
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. |