Tabledata: list

Retrieves table data from a specified set of rows. Try it now .

Data is returned in a JSON object that can be accessed in JavaScript, where the cell data is stored in the 'v' property of a two dimensional array, accessible like this:

cellVal = returnedJson[row][column].v;

Required ACLs: To call this method, you must have one of the following rights:

Dataset READ
Dataset WRITE
Dataset OWNER

Request

HTTP request

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

Parameters

Parameter name	Value	Description
Path parameters
`datasetId`	`string`	Dataset ID of the table to read
`projectId`	`string`	Project ID of the table to read
`tableId`	`string`	Table ID of the table to read
Optional query parameters
`maxResults`	`unsigned integer`	Maximum number of results to return
`pageToken`	`string`	Page token, returned by a previous call, identifying the result set
`startIndex`	`unsigned long`	Zero-based index of the starting row to read

Authorization

This request requires authorization with at least one of the following scopes ( read more about authentication and authorization ).

Scope
`https://www.googleapis.com/auth/bigquery`
`https://www.googleapis.com/auth/cloud-platform`

Request body

Do not supply a request body with this method.

Response

If successful, this method returns a response body with the following structure:

JSON

{
  "kind": "bigquery#tableDataList",
  "etag": etag,
  "totalRows": long,
  "pageToken": string,
  "rows": [
    {
      "f": [
        {
          "v": (value),
          "v": string,
          "v": string,
          "v": string,
          "v": string,
          "v": string,
          "v": string,
          "v": string,
          "v": string,
          "v": [
            (TableCell)
          ],
          "v": (TableRow)
        }
      ]
    }
  ]
}

Property name	Value	Description
`kind`	`bigquery#tableDataList`	The resource type of the response.
`etag`	`etag`	A hash of this page of results.
`totalRows`	`long`	The total number of rows in the complete table.
`rows[]`	`list`	Rows of results.
`rows[]. f[]`	`list`
`rows[].f[]. v`	`nested object`
`pageToken`	`string`	A token used for paging results. Providing this token instead of the startIndex parameter can help you retrieve stable results when an underlying table is changing.

CSV

(Invalid CSV Format: Need at least a header array and item array)

Property name	Value	Description	Notes

Try it!

Use the APIs Explorer below to call this method on live data and see the response.

Google BigQuery