Class DataSourceTable

A data source table, which allows the user to import a static table of data from the DataSource into Sheets. This is also known as "Extract" in the Sheets editor.

Inheritance

System.Object

DataSourceTable

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 DataSourceTable : IDirectResponseSchema

Properties

Columns

Columns selected for the data source table. The column_selection_type must be SELECTED.

Declaration

[JsonProperty("columns")]
public virtual IList<DataSourceColumnReference> Columns { get; set; }

Property Value

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

ColumnSelectionType

The type to select columns for the data source table. Defaults to SELECTED.

Declaration

[JsonProperty("columnSelectionType")]
public virtual string ColumnSelectionType { get; set; }

Property Value

Type	Description
System.String

DataExecutionStatus

Output only. The data execution status.

Declaration

[JsonProperty("dataExecutionStatus")]
public virtual DataExecutionStatus DataExecutionStatus { get; set; }

Property Value

Type	Description
DataExecutionStatus

DataSourceId

The ID of the data source the data source table is associated with.

Declaration

[JsonProperty("dataSourceId")]
public virtual string DataSourceId { 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

FilterSpecs

Filter specifications in the data source table.

Declaration

[JsonProperty("filterSpecs")]
public virtual IList<FilterSpec> FilterSpecs { get; set; }

Property Value

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

RowLimit

The limit of rows to return. If not set, a default limit is applied. Please refer to the Sheets editor for the default and max limit.

Declaration

[JsonProperty("rowLimit")]
public virtual int? RowLimit { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

SortSpecs

Sort specifications in the data source table. The result of the data source table is sorted based on the sort specifications in order.

Declaration

[JsonProperty("sortSpecs")]
public virtual IList<SortSpec> SortSpecs { get; set; }

Property Value

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

Implements

IDirectResponseSchema