class Google::Apis::SheetsV4::DataSourceTable
A data source table, which allows the user to import a static table of data from the DataSource
into Sheets. This is also known as “Extract” in the Sheets editor.
Attributes
The type to select columns for the data source table. Defaults to SELECTED. Corresponds to the JSON property `columnSelectionType` @return [String]
Columns selected for the data source table. The column_selection_type
must be SELECTED. Corresponds to the JSON property `columns` @return [Array<Google::Apis::SheetsV4::DataSourceColumnReference>]
The data execution status. A data execution is created to sync a data source object with the latest data from a DataSource
. It is usually scheduled to run at background, you can check its state to tell if an execution completes There are several scenarios where a data execution is triggered to run: * Adding a data source creates an associated data source sheet as well as a data execution to sync the data from the data source to the sheet. * Updating a data source creates a data execution to refresh the associated data source sheet similarly. * You can send refresh request to explicitly refresh one or multiple data source objects. Corresponds to the JSON property `dataExecutionStatus` @return [Google::Apis::SheetsV4::DataExecutionStatus]
The ID of the data source the data source table is associated with. Corresponds to the JSON property `dataSourceId` @return [String]
Filter specifications in the data source table. Corresponds to the JSON property `filterSpecs` @return [Array<Google::Apis::SheetsV4::FilterSpec>]
The limit of rows to return. If not set, a default limit is applied. Please refer to the Sheets editor for the default and max limit. Corresponds to the JSON property `rowLimit` @return [Fixnum]
Sort specifications in the data source table. The result of the data source table is sorted based on the sort specifications in order. Corresponds to the JSON property `sortSpecs` @return [Array<Google::Apis::SheetsV4::SortSpec>]
Public Class Methods
# File lib/google/apis/sheets_v4/classes.rb, line 4299 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File lib/google/apis/sheets_v4/classes.rb, line 4304 def update!(**args) @column_selection_type = args[:column_selection_type] if args.key?(:column_selection_type) @columns = args[:columns] if args.key?(:columns) @data_execution_status = args[:data_execution_status] if args.key?(:data_execution_status) @data_source_id = args[:data_source_id] if args.key?(:data_source_id) @filter_specs = args[:filter_specs] if args.key?(:filter_specs) @row_limit = args[:row_limit] if args.key?(:row_limit) @sort_specs = args[:sort_specs] if args.key?(:sort_specs) end