Tabledata: list

Requires authorization

Retrieves table data from a specified set of rows. Requires the READER dataset role.

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;

Integers are represented as strings in the JSON object due to the precision difference between BigQuery and JSON.

Access control: For more information, see access control.


HTTP request



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
selectedFields string List of fields to return (comma-separated). If unspecified, all fields are returned
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 Represents a single row in the result set, consisting of one or more fields.
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.

Try it!

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