Class BatchGetValuesByDataFilterRequest

The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters.

Inheritance

System.Object

BatchGetValuesByDataFilterRequest

Implements

IDirectResponseSchema

Inherited Members

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.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class BatchGetValuesByDataFilterRequest : IDirectResponseSchema

Properties

DataFilters

The data filters used to match the ranges of values to retrieve. Ranges that match any of the specified data filters will be included in the response.

Declaration

[JsonProperty("dataFilters")]
public virtual IList<DataFilter> DataFilters { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<DataFilter>

DateTimeRenderOption

How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].

Declaration

[JsonProperty("dateTimeRenderOption")]
public virtual string DateTimeRenderOption { get; set; }

Property Value

Type	Description
System.String

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

MajorDimension

The major dimension that results should use.

For example, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then a request that selects that range and sets majorDimension=ROWS will return [[1,2],[3,4]], whereas a request that sets majorDimension=COLUMNS will return [[1,3],[2,4]].

Declaration

[JsonProperty("majorDimension")]
public virtual string MajorDimension { get; set; }

Property Value

Type	Description
System.String

ValueRenderOption

How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE.

Declaration

[JsonProperty("valueRenderOption")]
public virtual string ValueRenderOption { get; set; }

Property Value

Type	Description
System.String

Implements

IDirectResponseSchema