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. |