Docs

Retrieves a collection of documents from workspaces, including their metadata.

Table-Specific Information

SELECT

The server uses the Monday API to process some of the filters. The server processes other filters client-side within the server.

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 columns can be used to create a new record:

WorkspaceId, DocKind, Name

INSERT INTO Docs (WorkspaceId,DocKind,Name) VALUES ('3820334','public','CreatedDoc')

UPDATE

The following column can be updated:

Name

DELETE

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A unique identifier assigned to the document, used to reference and distinguish the document in the system.
DocFolderId	String	True	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	True		The unique identifier of the object associated with the document, allowing linkage between the document and the corresponding object in the system.
WorkspaceId	String	True	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	True	Users.Id	The unique identifier of the user who created the document, linking it to the creator's profile for tracking purposes.
DocKind	String	True		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	True		The relative URL path of the document, which can be used to access it within the web application's context.
Settings	String	True		Stores configuration settings or preferences associated with the document, such as display or security settings.
Url	String	True		The direct, fully qualified URL that provides access to the document, usable for linking or direct access via a browser.
CreatedAt	Date	True		The timestamp representing when the document was created, useful for auditing and sorting documents chronologically.