Sign in

v1

latestOpenAPI 3.0.0Creative Commons Attribution 3.02026-07-1342224376.9 KB
tabledata

List the content of a table in rows. # IAM Permissions Requires the bigquery.tables.getData permission on the table.

get/projects/{+projectId}/datasets/{+datasetId}/tables/{+tableId}/data

Path parameters

projectIdstring required

Required. Project id of the table to list.

datasetIdstring required

Required. Dataset id of the table to list.

tableIdstring required

Required. Table id of the table to list.

Query parameters

formatOptions.timestampOutputFormat'TIMESTAMP_OUTPUT_FORMAT_UNSPECIFIED' | 'FLOAT64' | 'INT64' | 'ISO8601_STRING'

Optional. The API output format for a timestamp. This offers more explicit control over the timestamp output format as compared to the existing use_int64_timestamp option.

formatOptions.useInt64Timestampboolean

Optional. Output timestamp as usec int64. Default is false.

maxResultsinteger

Row limit of the table.

pageTokenstring

To retrieve the next page of table data, set this field to the string provided in the pageToken field of the response body from your previous call to tabledata.list.

selectedFieldsstring

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

startIndexstring

Start row index of the table.

Response

Successful response