Info_Templates
Retrieve Smartsheet template information to streamline the creation of standardized sheets.
Table-specific Information
SELECT
Retrieve all templates.
SELECT * FROM Info_Templates
Retrieve templates located directly on a specific folder, or set of folders. Unlike RootFolderId below, this does not return templates nested in subfolders.
SELECT * FROM Info_Templates WHERE FolderId = '2928085806875091'
SELECT * FROM Info_Templates WHERE FolderId IN ('2928085806875091', '2928085806875092')
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 | The unique identifier of the template. | |
| Name | String | The template name. | |
| AccessLevel | String | The permission level of the current user for this template, such as 'viewer', 'editor', or 'admin'. | |
| Permalink | String | URL that represents a direct link to the template in Smartsheet. | |
| FolderId | String |
Info_Folders.Id | The unique identifier of the folder where the template is stored, helping to organize templates. Filtering on this column returns only the templates directly within the specified folder(s), unlike RootFolderId which also returns templates in nested subfolders. |
| WorkspaceId | String | The unique identifier of the workspace containing the template, useful for multi-user collaboration. | |
| CreatedAt | Datetime | The time when the template was created. | |
| ModifiedAt | Datetime | The time when the template was last modified. |
Pseudocolumns
Pseudocolumn 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 template resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy. |