Retrieve Smartsheet template information to streamline the creation of standardized sheets.

Table Specific Information

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

Select

By default this view returns all Templates created by the user. If the Scope filter is set to 'public' , the public templates will be returned.

Retrieve all Templates.

SELECT * FROM Info_Templates

Retrieve all other public Templates.

SELECT * FROM Info_Templates WHERE Scope = 'public'

Retrieve Templates located on a specific folder.

SELECT * FROM Info_Templates WHERE FolderId = '2928085806875091'

Retrieve Templates located on a specific Workspace.

SELECT * FROM Info_Templates WHERE WorkspaceId = '1928085806875098'

Retrieve Templates 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_Templates WHERE RootFolderId = '993868452784004';
SELECT * FROM Info_Templates WHERE RootFolderId = '993868452784004' AND Name = 'MyTemplate';

Columns

Name	Type	References	Description
Id [KEY]	String		A unique identifier assigned to each template, ensuring it can be distinctly referenced.
Name	String		The user-defined name of the template, used for display and identification purposes.
Description	String		A detailed overview or summary of the template's purpose and contents.
AccessLevel	String		Defines the level of user permissions on the template, such as 'read-only' or 'editor'.
Permalink	String		A permanent, unique URL linking directly to the template for easy sharing or access.
Scope	String		The scope of the template. Possible values: 'public' for templates accessible to all users, and 'user' for templates created and accessible only by the logged-in user. The allowed values are public, user.
FolderId	String		The unique identifier of the folder where the template is stored, helping to organize templates.
WorkspaceId	String		The unique identifier of the workspace containing the template, useful for multi-user collaboration.
TemplateType	String		Type of template. Only applicable to public templates. Possible values: 'report', 'sheet'.
Categories	String		Indicates whether the template is blank. Only applicable to public templates.
Tags	String		List of search tags for this template. Only applicable to non-blank public templates.
Locale	String		Indicates the language and region settings for the template, such as 'en-US' or 'fr-FR'.
Blank	Boolean		Indicates whether the template is blank. Only applicable to public templates.
GlobalTemplate	String		Type of global template. Only applicable to blank public templates. Possible values: 'BLANK_SHEET', 'PROJECT_SHEET', 'TASK_LIST'.
Image	String		The URL pointing to an image representing the template, often used in visual displays or previews.
LargeImage	String		URL to the large preview image for this template. Only applicable to non-blank public templates.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.