Info_Shares

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

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		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.