JDBC Driver for Smartsheet

Build 22.0.8462

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.

The allowed values are 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462