Class SpreadsheetsResource.ValuesResource.UpdateRequest

Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.

Inheritance
System.Object
Google.Apis.Requests.ClientServiceRequest
Google.Apis.Requests.ClientServiceRequest<UpdateValuesResponse>
SheetsBaseServiceRequest<UpdateValuesResponse>
SpreadsheetsResource.ValuesResource.UpdateRequest
Implements
Google.Apis.Requests.IClientServiceRequest<UpdateValuesResponse>
Google.Apis.Requests.IClientServiceRequest
Inherited Members
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.Execute()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ExecuteAsStream()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ExecuteAsync()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ExecuteAsync(System.Threading.CancellationToken)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ExecuteAsStreamAsync()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ExecuteAsStreamAsync(System.Threading.CancellationToken)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.CreateRequest(System.Nullable<System.Boolean>)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.GenerateRequestUri()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.GetDefaultETagAction(System.String)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ETagAction
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ModifyRequest
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.ValidateParameters
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.RequestParameters
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.Service
Google.Apis.Requests.ClientServiceRequest._unsuccessfulResponseHandlers
Google.Apis.Requests.ClientServiceRequest._exceptionHandlers
Google.Apis.Requests.ClientServiceRequest._executeInterceptors
Google.Apis.Requests.ClientServiceRequest.AddUnsuccessfulResponseHandler(Google.Apis.Http.IHttpUnsuccessfulResponseHandler)
Google.Apis.Requests.ClientServiceRequest.AddExceptionHandler(Google.Apis.Http.IHttpExceptionHandler)
Google.Apis.Requests.ClientServiceRequest.AddExecuteInterceptor(Google.Apis.Http.IHttpExecuteInterceptor)
Google.Apis.Requests.ClientServiceRequest.Credential
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Google.Apis.Sheets.v4
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class UpdateRequest : SheetsBaseServiceRequest<UpdateValuesResponse>, IClientServiceRequest<UpdateValuesResponse>, IClientServiceRequest

Constructors

UpdateRequest(IClientService, ValueRange, String, String)

Constructs a new Update request.

Declaration
public UpdateRequest(IClientService service, ValueRange body, string spreadsheetId, string range)
Parameters
Type Name Description
Google.Apis.Services.IClientService service
ValueRange body
System.String spreadsheetId
System.String range

Properties

HttpMethod

Gets the HTTP method.

Declaration
public override string HttpMethod { get; }
Property Value
Type Description
System.String
Overrides
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.HttpMethod

IncludeValuesInResponse

Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than the range actually written, the response includes all values in the requested range (excluding trailing empty rows and columns).

Declaration
[RequestParameter("includeValuesInResponse", RequestParameterType.Query)]
public virtual bool? IncludeValuesInResponse { get; set; }
Property Value
Type Description
System.Nullable<System.Boolean>

MethodName

Gets the method name.

Declaration
public override string MethodName { get; }
Property Value
Type Description
System.String
Overrides
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.MethodName

Range

The A1 notation of the values to update.

Declaration
[RequestParameter("range", RequestParameterType.Path)]
public virtual string Range { get; }
Property Value
Type Description
System.String

ResponseDateTimeRenderOption

Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

Declaration
[RequestParameter("responseDateTimeRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.UpdateRequest.ResponseDateTimeRenderOptionEnum? ResponseDateTimeRenderOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.UpdateRequest.ResponseDateTimeRenderOptionEnum>

ResponseValueRenderOption

Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.

Declaration
[RequestParameter("responseValueRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.UpdateRequest.ResponseValueRenderOptionEnum? ResponseValueRenderOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.UpdateRequest.ResponseValueRenderOptionEnum>

RestPath

Gets the REST path.

Declaration
public override string RestPath { get; }
Property Value
Type Description
System.String
Overrides
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.RestPath

SpreadsheetId

The ID of the spreadsheet to update.

Declaration
[RequestParameter("spreadsheetId", RequestParameterType.Path)]
public virtual string SpreadsheetId { get; }
Property Value
Type Description
System.String

ValueInputOption

How the input data should be interpreted.

Declaration
[RequestParameter("valueInputOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum? ValueInputOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum>

Methods

GetBody()

Returns the body of the request.

Declaration
protected override object GetBody()
Returns
Type Description
System.Object
Overrides
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.GetBody()

InitParameters()

Initializes Update parameter list.

Declaration
protected override void InitParameters()
Overrides
Google.Apis.Sheets.v4.SheetsBaseServiceRequest<Google.Apis.Sheets.v4.Data.UpdateValuesResponse>.InitParameters()

Implements

Google.Apis.Requests.IClientServiceRequest<TResponse>
Google.Apis.Requests.IClientServiceRequest