JDBC Driver for Smartsheet

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Smartsheet Views

Name Description
Info_CellHistory Query the available CellHistory of a Cell in Smartsheet.
Info_Cells Query Smartsheet Cells. A collection of Cells comprises each Row in a Sheet.
Info_Contacts Query Smartsheet Contacts. A Contact is the personal contact of a User in Smartsheet.
Info_Favorites Query Smartsheet Favorites.
Info_Folders Query Smartsheet Folders in the Sheets Folder for the User, in another Folder, or in a Workspace.
Info_Groups Query Smartsheet Groups.
Info_Home Query objects on the Home tab in Smartsheet. The Home tab shows all objects a User has access to.
Info_Reports Query Smartsheet Reports.
Info_Rows Query Rows in a Sheet or Report. Each Row is composed of a collection of Cells, and may optionally contain Discussions and Attachments.
Info_ServerInformation Query Smartsheet Server Information including application constants.
Info_Shares Query the Sharing operations of Reports, Sheets, and Workspaces.
Info_Sheets Query Smartsheets Sheets. A Sheet can exist in the Sheets folder for the user (Home), in a Folder, or in a Workspace. It is comprised of Columns, Rows, and Cells, and may optionally contain Attachments and Discussions.
Info_Templates Query Smartsheet Templates.
Info_Users Query the Users in the organization.
Info_Workspaces Query Smartsheet Workspaces.

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