Info_Templates
Query Smartsheet Templates.
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 | The unique identifier of the template. | |
| Name | String | The name of the template. | |
| Description | String | The description for the template. | |
| TemplateType | String | The template type.
使用できる値は次のとおりです。public, user | |
| AccessLevel | String | The user permissions on the template. | |
| Permalink | String | The permalink for the template. | |
| Image | String | The image link for the template. | |
| Locale | String | The locale for the template. | |
| FolderId | String | The Id of the folder the template is part of. | |
| WorkspaceId | String | The Id of the workspace the template is part of. |