Views

Views are similar to tables in the way that data is represented; however, views do not support updates. Data sources that are represented as views are typically read-only data sources. 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. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

Name	Description
Sheets	Returns a list of a user's sheets and their relevant information.
Spreadsheets	Returns a list of a user's spreadsheets and their relevant information.

Name	Type	Description
SpreadsheetId	String	The assigned Id of the spreadsheet.
SpreadsheetName	String	The name of the spreadsheet.
SheetId	String	A short description of the spreadsheet.
SheetName	String	The name of the sheet.
SheetIndex	Integer	The index of the sheet within the spreadsheet.
SheetType	String	The type of sheet. Defaults to GRID.
RowCount	Integer	The number of rows in the grid.
ColumnCount	Integer	The number of columns in the grid.
FrozenRowCount	Integer	The number of rows that are frozen in the grid.
FrozenColumnCount	Integer	The number of columns that are frozen in the grid.

Name	Type	Description
Id [KEY]	String	The assigned Id of the spreadsheet.
Name	String	The name of the spreadsheet.
Description	String	A short description of the spreadsheet.
Owners	String	The owners of the spreadsheet.
ModifiedTime	Datetime	The last updated date and time of this spreadsheet.
CreatedTime	Datetime	The created date and time of this spreadsheet.
Trashed	Boolean	Whether the spreadsheet has been trashed.
Starred	Boolean	Whether the user has starred the spreadsheet.
Hidden	Boolean	Whether the spreadsheet is hidden.
Viewed	Boolean	Whether the user has viewed the spreadsheet.