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