batchUpdate method

Future<BatchUpdateValuesResponse> batchUpdate(
  1. BatchUpdateValuesRequest request,
  2. String spreadsheetId, {
  3. String? $fields,
})

Sets values in one or more ranges of a spreadsheet.

The caller must specify the spreadsheet ID, a valueInputOption, and one or more ValueRanges.

request - The metadata request object.

Request parameters:

spreadsheetId - The ID of the spreadsheet to update.

$fields - Selector specifying which fields to include in a partial response.

Completes with a BatchUpdateValuesResponse.

Completes with a commons.ApiRequestError if the API endpoint returned an error.

If the used http.Client completes with an error when making a REST call, this method will complete with the same error.

Implementation

async.Future<BatchUpdateValuesResponse> batchUpdate(
  BatchUpdateValuesRequest request,
  core.String spreadsheetId, {
  core.String? $fields,
}) async {
  final body_ = convert.json.encode(request);
  final queryParams_ = <core.String, core.List<core.String>>{
    if ($fields != null) 'fields': [$fields],
  };

  final url_ = 'v4/spreadsheets/' +
      commons.escapeVariable('$spreadsheetId') +
      '/values:batchUpdate';

  final response_ = await _requester.request(
    url_,
    'POST',
    body: body_,
    queryParams: queryParams_,
  );
  return BatchUpdateValuesResponse.fromJson(
      response_ as core.Map<core.String, core.dynamic>);
}