JDBC Driver for Smartsheet

Build 22.0.8462

Info_Shares

Query the Sharing operations of Reports, Sheets, and Workspaces.

Table Specific Information

Select

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'

Columns

Name Type References Description
Id [KEY] String The unique identifier of this share.
Type String The type of this share. Possible values: USER or GROUP.
UserId String The user Id for a user share.
GroupId String The group Id of a group share.
Email String The email address for a user share.
Name String The full name for a user share where the user is also a contact. The group name for a group share.
AccessLevel String The access level for the user or group on the shared object.
Subject String The subject of the email that will optionally be sent to notify the recipient.
Message String The message to be included in the body of the email that will optionally be sent to the recipient.
CcMe Boolean Whether or not to send a copy of the email to the sharer of the sheet.
WorkspaceId String The Id of the workspace.
SheetId String The Id of the sheet.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462