Docs
Retrieves a collection of documents from workspaces, including their metadata.
Table-Specific Information
SELECT
The cmdlet uses the Monday API to process some of the filters. The cmdlet processes other filters client-side within the cmdlet.
- 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. |