Info_Workspaces

Read and write workspace data in your Smartsheet account.

Table-specific Information

Retrieve all workspaces.

SELECT * FROM Info_Workspaces

Retrieve details for a specific workspace.

SELECT * FROM Info_Workspaces WHERE Id = '2928085806875091'

You can create a workspace by providing the Name column as shown in the example query below.

INSERT INTO Info_Workspaces (Name) VALUES ('My Workspace 1')

You can update workspace data by specifying the Id column in the criteria as shown in the example query below.

UPDATE Info_Workspaces SET Name = 'My Test Workspace 1' WHERE Id = '2928085806875091'

You can delete a workspace by specifying the Id column in the criteria as shown in the example query below.

DELETE FROM Info_Workspaces WHERE Id = '2928085806875091'


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique identifier (GUID) for the workspace, used to distinguish it from other workspaces.
Name	String	False		The user-defined name of the workspace, used for organization and identification.
Favorite	Boolean	True		Indicates whether the workspace has been marked as a favorite by the user for quick access.
AccessLevel	String	True		Specifies the permissions level assigned to the user for this workspace, such as Viewer, Editor, or Admin.
Permalink	String	True		A permanent URL that provides a direct link to access the workspace within Smartsheet.