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 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 | 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. |
| 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. |
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 template resides. Can be used to query the data from only a specific folder (and its subfolders) in the Smartsheet hierarchy. |