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

Table-specific Information

The RootFolderId pseudo-column and the CreatedAt, ModifiedAt columns are NOT present when UseLegacyAPI is enabled.

When UseLegacyAPI is disabled, the driver is not able to retrieve the data for the deprecated columns (NULL values for every record).

SELECT

Retrieve all templates.

SELECT * FROM Info_Templates

The following functionality should be used only when UseLegacyAPI is enabled. This feature is deprecated and will be removed in the next major release.

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. DEPRECATED, to be removed in the next major release.
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. DEPRECATED, to be removed in the next major release. 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'. DEPRECATED, to be removed in the next major release.
Categories	String		Indicates whether the template is blank. Only applicable to public templates. DEPRECATED, to be removed in the next major release.
Tags	String		List of search tags for this template. Only applicable to non-blank public templates. DEPRECATED, to be removed in the next major release.
Locale	String		Indicates the language and region settings for the template, such as 'en-US' or 'fr-FR'. DEPRECATED, to be removed in the next major release.
Blank	Boolean		Indicates whether the template is blank. Only applicable to public templates. DEPRECATED, to be removed in the next major release.
GlobalTemplate	String		Type of global template. Only applicable to blank public templates. Possible values: 'BLANK_SHEET', 'PROJECT_SHEET', 'TASK_LIST'. DEPRECATED, to be removed in the next major release.
Image	String		The URL pointing to an image representing the template, often used in visual displays or previews. DEPRECATED, to be removed in the next major release.
LargeImage	String		URL to the large preview image for this template. Only applicable to non-blank public templates. DEPRECATED, to be removed in the next major release.
CreatedAt	Datetime		The time when the template was created.
ModifiedAt	Datetime		The time when the template was last modified.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data 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.