Info_Templates
Retrieve Smartsheet template information to streamline the creation of standardized sheets.
Table Specific Information
Select
By default this view returns all Templates created by the user. If the TemplateType 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 TemplateType = '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'
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. | |
| TemplateType | String | Specifies the type or category of the template, such as 'project plan' or 'budget sheet'.
The allowed values are public, user. | |
| 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. | |
| Image | String | The URL pointing to an image representing the template, often used in visual displays or previews. | |
| Locale | String | Indicates the language and region settings for the template, such as 'en-US' or 'fr-FR'. | |
| 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. |