Explore detailed metadata and structure of Smartsheet sheets, including their components like columns, rows, and attachments.

Table Specific Information

The RootFolderId pseudo-column is NOT present when UseLegacyAPI is enabled.

Select

Retrieve all Sheets.

SELECT * FROM Info_Sheets

Retrieve Sheets located in a specific Folder.

SELECT * FROM Info_Sheets WHERE FolderId = '2928085806875091'

Retrieve Sheets located in a specific Workspace.

SELECT * FROM Info_Sheets WHERE WorkspaceId = '1928085806875098'

Retrieve Sheets which are located beneath the folder specified in the folder hierarchy. Only simple criteria like the ones below can be processed for this pseudo-column, otherwise the condition will just be ignored:

SELECT * FROM Info_Sheets WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Sheets WHERE RootFolderId = '993868452784004' AND Name = 'MySheet';

Columns

Name	Type	References	Description
Id [KEY]	String		A unique identifier assigned to the sheet, used for referencing it programmatically or in APIs.
Name	String		The descriptive name of the sheet, visible to users in the Smartsheet interface.
Owner	String		The email address of the user who owns the sheet and has primary control over its permissions and content.
OwnerId	String		The unique identifier of the user who owns the sheet, used for internal user management.
Permalink	String		A permanent, shareable URL that provides direct access to the sheet in Smartsheet.
SourceId	String		The unique identifier of the original sheet or template from which this sheet was created, useful for tracing its origin.
SourceType	String		Indicates whether the source object for this sheet was a 'sheet' or a 'template', helping to categorize its origin.
CreatedAt	Datetime		The timestamp indicating when the sheet was first created in Smartsheet.
ModifiedAt	Datetime		The timestamp of the most recent modification made to the sheet's content or properties.
Version	Long		A revision number incremented with each change made to the sheet, useful for tracking updates.
TotalRowCount	Long		The total number of rows currently present in the sheet, reflecting its data capacity or usage. Values for this column are retrieved only when filtering with the Id column.
AccessLevel	String		The permission level of the current user for this sheet, such as 'viewer', 'editor', or 'admin'.
ReadOnly	Boolean		Indicates if the sheet is in read-only mode, typically due to an expired trial or restricted permissions.
GanttEnabled	Boolean		Specifies whether the Gantt chart feature is enabled for this sheet, allowing project timelines to be visualized.
DependenciesEnabled	Boolean		Shows if dependency tracking is active, used for managing task relationships and schedules.
ResourceManagementEnabled	Boolean		Indicates if resource management tools are enabled, supporting workload and capacity planning.
Favorite	Boolean		Indicates whether the user has marked this sheet as a favorite, making it easier to locate in their Home tab.
ShowParentRowsForFilters	Boolean		Specifies if the 'Show Parent Rows' option is enabled for filtering, helping to display hierarchical context.
FromId	String		The unique identifier of the template from which the sheet was originally created, used for template-based organization.
WorkspaceId	String		The unique identifier of the workspace where the sheet is stored, aiding in categorization and collaboration.
FolderId	String		The unique identifier of the folder containing the sheet, for better organization within Smartsheet.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
RootFolderId	String		The Id of the root folder in which the object resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy.