Docs
Retrieves a collection of documents from workspaces, including their metadata.
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.
- 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
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 |
A unique identifier assigned to the document, used to reference and distinguish the document in the system. | |
DocFolderId | String | False |
Folders.Id |
The identifier of the folder where the document is stored. If the document is at the first level (root), this value is null. |
ObjectId | String | False |
The unique identifier of the object associated with the document, allowing linkage between the document and the corresponding object in the system. | |
WorkspaceId | String | False |
Workspaces.Id |
The identifier for the workspace where the document is located. If the document is in the main workspace, this value is null. |
CreatedById | String | False |
Users.Id |
The unique identifier of the user who created the document, linking it to the creator's profile for tracking purposes. |
DocKind | String | False |
Specifies the document's classification: public (accessible to all), private (restricted access), or shared (accessible to specific users). The allowed values are public, private, share. | |
Name | String | False |
The name or title of the document, typically used to identify it within the system or user interface. | |
RelativeUrl | String | False |
The relative URL path of the document, which can be used to access it within the web application's context. | |
Settings | String | False |
Stores configuration settings or preferences associated with the document, such as display or security settings. | |
Url | String | False |
The direct, fully qualified URL that provides access to the document, usable for linking or direct access via a browser. | |
CreatedAt | Date | False |
The timestamp representing when the document was created, useful for auditing and sorting documents chronologically. |