class Google::Apis::SheetsV4::SheetsService

def batch_get_spreadsheet_values(spreadsheet_id, date_time_render_option: nil, major_dimension: nil, ranges: nil, value_render_option: nil, fields: nil, quota_user: nil, options: nil, &block)

Raises:
  • (Google::Apis::AuthorizationError) - Authorization is required
  • (Google::Apis::ClientError) - The request is invalid and should not be retried without modification
  • (Google::Apis::ServerError) - An error occurred on the server and the request can be retried

Returns:
  • (Google::Apis::SheetsV4::BatchGetValuesResponse) -

Other tags:
    Yieldparam: err - error object if request failed
    Yieldparam: result - parsed result object

Other tags:
    Yield: - Result & error if block supplied

Parameters:
  • options (Google::Apis::RequestOptions) --
  • quota_user (String) --
  • fields (String) --
  • value_render_option (String) --
  • ranges (Array, String) --
  • major_dimension (String) --
  • date_time_render_option (String) --
  • spreadsheet_id (String) --
def batch_get_spreadsheet_values(spreadsheet_id, date_time_render_option: nil, major_dimension: nil, ranges: nil, value_render_option: nil, fields: nil, quota_user: nil, options: nil, &block)
  command = make_simple_command(:get, 'v4/spreadsheets/{spreadsheetId}/values:batchGet', options)
  command.response_representation = Google::Apis::SheetsV4::BatchGetValuesResponse::Representation
  command.response_class = Google::Apis::SheetsV4::BatchGetValuesResponse
  command.params['spreadsheetId'] = spreadsheet_id unless spreadsheet_id.nil?
  command.query['dateTimeRenderOption'] = date_time_render_option unless date_time_render_option.nil?
  command.query['majorDimension'] = major_dimension unless major_dimension.nil?
  command.query['ranges'] = ranges unless ranges.nil?
  command.query['valueRenderOption'] = value_render_option unless value_render_option.nil?
  command.query['fields'] = fields unless fields.nil?
  command.query['quotaUser'] = quota_user unless quota_user.nil?
  execute_or_queue_command(command, &block)
end