Method: tabledata.list

tabledata.list the content of a table in rows.

HTTP request

GET https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
projectId

string

Project id of the table to list.

datasetId

string

Dataset id of the table to list.

tableId

string

Table id of the table to list.

Query parameters

Parameters
startIndex

string

Start row index of the table.

maxResults

number (uint32 format)

Row limit of the table.

pageToken

string

Page token of the request. When this token is non-empty, it indicates additional results are available.

selectedFields

string

Subset of fields to return, supports select into sub fields. Example: selectedFields = "a,e.d.f";

Request body

The request body must be empty.

Response body

If successful, the response body contains data with the following structure:

JSON representation
{
  "kind": string,
  "etag": string,
  "totalRows": string,
  "pageToken": string,
  "rows": [
    {
      object
    }
  ]
}
Fields
kind

string

Will be set to "bigquery#tableDataList".

etag

string

Etag to the response.

totalRows

string

Total rows of the entire table. In order to show default value "0", we have to present it as string.

pageToken

string

A token indicates from where we should start the next read.

rows[]

object (Struct format)

Repeated rows as result. The REST-based representation of this data leverages a series of JSON f,v objects for indicating fields and values.

Authorization Scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigquery
  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/bigquery.readonly
  • https://www.googleapis.com/auth/cloud-platform.read-only

For more information, see the Authentication Overview.

Try it!

Bu sayfayı yararlı buldunuz mu? Lütfen görüşünüzü bildirin:

Şunun hakkında geri bildirim gönderin...