generated/google/apis/sheets_v4/service.rb in google-api-client-0.9.11 vs generated/google/apis/sheets_v4/service.rb in google-api-client-0.9.12
- old
+ new
@@ -174,9 +174,64 @@
command.query['quotaUser'] = quota_user unless quota_user.nil?
command.query['fields'] = fields unless fields.nil?
execute_or_queue_command(command, &block)
end
+ # Appends values to a spreadsheet. The input range is used to search for
+ # existing data and find a "table" within that range. Values will be
+ # appended to the next row of the table, starting with the first column of
+ # the table. See the
+ # [guide](/sheets/guides/values#appending_values)
+ # and
+ # [sample code](/sheets/samples/writing#append_values)
+ # for specific details of how tables are detected and data is appended.
+ # The caller must specify the spreadsheet ID, range, and
+ # a valueInputOption. The `valueInputOption` only
+ # controls how the input data will be added to the sheet (column-wise or
+ # row-wise), it does not influence what cell the data starts being written
+ # to.
+ # @param [String] spreadsheet_id
+ # The ID of the spreadsheet to update.
+ # @param [String] range
+ # The A1 notation of a range to search for a logical table of data.
+ # Values will be appended after the last row of the table.
+ # @param [Google::Apis::SheetsV4::ValueRange] value_range_object
+ # @param [String] value_input_option
+ # How the input data should be interpreted.
+ # @param [String] insert_data_option
+ # How the input data should be inserted.
+ # @param [String] quota_user
+ # Available to use for quota purposes for server-side applications. Can be any
+ # arbitrary string assigned to a user, but should not exceed 40 characters.
+ # @param [String] fields
+ # Selector specifying which fields to include in a partial response.
+ # @param [Google::Apis::RequestOptions] options
+ # Request-specific options
+ #
+ # @yield [result, err] Result & error if block supplied
+ # @yieldparam result [Google::Apis::SheetsV4::AppendValuesResponse] parsed result object
+ # @yieldparam err [StandardError] error object if request failed
+ #
+ # @return [Google::Apis::SheetsV4::AppendValuesResponse]
+ #
+ # @raise [Google::Apis::ServerError] An error occurred on the server and the request can be retried
+ # @raise [Google::Apis::ClientError] The request is invalid and should not be retried without modification
+ # @raise [Google::Apis::AuthorizationError] Authorization is required
+ def append_spreadsheet_value(spreadsheet_id, range, value_range_object = nil, value_input_option: nil, insert_data_option: nil, quota_user: nil, fields: nil, options: nil, &block)
+ command = make_simple_command(:post, 'v4/spreadsheets/{spreadsheetId}/values/{range}:append', options)
+ command.request_representation = Google::Apis::SheetsV4::ValueRange::Representation
+ command.request_object = value_range_object
+ command.response_representation = Google::Apis::SheetsV4::AppendValuesResponse::Representation
+ command.response_class = Google::Apis::SheetsV4::AppendValuesResponse
+ command.params['spreadsheetId'] = spreadsheet_id unless spreadsheet_id.nil?
+ command.params['range'] = range unless range.nil?
+ command.query['valueInputOption'] = value_input_option unless value_input_option.nil?
+ command.query['insertDataOption'] = insert_data_option unless insert_data_option.nil?
+ command.query['quotaUser'] = quota_user unless quota_user.nil?
+ command.query['fields'] = fields unless fields.nil?
+ execute_or_queue_command(command, &block)
+ end
+
# Sets values in a range of a spreadsheet.
# The caller must specify the spreadsheet ID, range, and
# a valueInputOption.
# @param [String] spreadsheet_id
# The ID of the spreadsheet to update.