Google BigQuery

Tabledata: list

Requires authorization

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;

Access control: For more information, see access control.


HTTP request

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


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


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


Request body

Do not supply a request body with this method.


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


  "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": [
          "v": (TableRow)
Property name Value Description Notes
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.


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