Info_Shares

Retrieve sharing configurations for Smartsheet reports, sheets, and workspaces to manage access controls.

Table Specific Information

This view returns a list of Shares. Either the SheetId or WorkspaceId parameter is always required.

Retrieve all Shares related to a Sheet.

SELECT * FROM Info_Shares WHERE SheetId = '2940085806098308'

Retrieve all Shares related to a Workspace.

SELECT * FROM Info_Shares WHERE WorkspaceId = '1630085806098114'

Retrieve details of a Share related to a specified Sheet.

SELECT * FROM Info_Shares WHERE SheetId = '2940085806098308' AND Id = '1928085806875098'

Retrieve details of a Share related to a specified Workspace.

SELECT * FROM Info_Shares WHERE WorkspaceId = '1630085806098114' AND Id = '2928085806875091'


Name	Type	References	Description
Id [KEY]	String		A unique identifier assigned to this share, used to differentiate it from other shares.
Type	String		Specifies whether the share is for an individual user (USER) or a group (GROUP).
UserId	String		The unique identifier of the user associated with this share when the share type is USER.
GroupId	String		The unique identifier of the group associated with this share when the share type is GROUP.
Email	String		The email address of the user receiving the share, used for sending notifications and identifying the user.
Name	String		The full name of the user or the name of the group associated with the share. For users, this is shown if they are also a contact.
AccessLevel	String		Defines the level of access granted to the user or group, such as Viewer, Editor, or Admin, on the shared object.
Subject	String		The subject line of the optional email notification sent to inform the recipient about the share.
Message	String		The body text of the optional email notification sent to provide details or context about the share.
CcMe	Boolean		Indicates whether the sharer should receive a copy of the notification email sent to the recipient. True if enabled.
WorkspaceId	String		The unique identifier of the workspace that is shared.
SheetId	String		The unique identifier of the sheet that is shared within the workspace.