ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData JDBC Driver for Smartsheet ビュー
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. |