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. DEPRECATED, to be removed in the next major release.
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.