Class SpreadsheetsResource.ValuesResource.AppendRequest

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 and sample code 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.

Inheritance
System.Object
Google.Apis.Requests.ClientServiceRequest
Google.Apis.Requests.ClientServiceRequest<AppendValuesResponse>
SheetsBaseServiceRequest<AppendValuesResponse>
SpreadsheetsResource.ValuesResource.AppendRequest
Implements
Google.Apis.Requests.IClientServiceRequest<AppendValuesResponse>
Google.Apis.Requests.IClientServiceRequest
Inherited Members
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.Execute()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ExecuteAsStream()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ExecuteAsync()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ExecuteAsync(System.Threading.CancellationToken)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ExecuteAsStreamAsync()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ExecuteAsStreamAsync(System.Threading.CancellationToken)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.CreateRequest(System.Nullable<System.Boolean>)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.GenerateRequestUri()
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.GetDefaultETagAction(System.String)
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ETagAction
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.ModifyRequest
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.RequestParameters
Google.Apis.Requests.ClientServiceRequest<Google.Apis.Sheets.v4.Data.AppendValuesResponse>.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 AppendRequest : SheetsBaseServiceRequest<AppendValuesResponse>, IClientServiceRequest<AppendValuesResponse>, IClientServiceRequest

Constructors

AppendRequest(IClientService, ValueRange, String, String)

Constructs a new Append request.

Declaration
public AppendRequest(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.AppendValuesResponse>.HttpMethod

IncludeValuesInResponse

Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.

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

InsertDataOption

How the input data should be inserted.

Declaration
[RequestParameter("insertDataOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum? InsertDataOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.AppendRequest.InsertDataOptionEnum>

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.AppendValuesResponse>.MethodName

Range

The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table.

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 [DateTimeRenderOption.SERIAL_NUMBER].

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

ResponseValueRenderOption

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

Declaration
[RequestParameter("responseValueRenderOption", RequestParameterType.Query)]
public virtual SpreadsheetsResource.ValuesResource.AppendRequest.ResponseValueRenderOptionEnum? ResponseValueRenderOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.AppendRequest.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.AppendValuesResponse>.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.AppendRequest.ValueInputOptionEnum? ValueInputOption { get; set; }
Property Value
Type Description
System.Nullable<SpreadsheetsResource.ValuesResource.AppendRequest.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.AppendValuesResponse>.GetBody()

InitParameters()

Initializes Append parameter list.

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

Implements

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