Bigquery.tabledata.list

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

GET/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data

Use it in a workflow

Add a step and choose the BigQuery connector.
Pick the Bigquery.tabledata.list action (under tabledata).
Fill in the fields below, then reference the result from later steps as {{bigqueryTabledataList.response.data}}.

Request

Path parameters

projectIdstringrequired

Project ID of the table to read

datasetIdstringrequired

Dataset ID of the table to read

tableIdstringrequired

Table ID of the table to read

Query parameters

altstring

Data format for the response.

One ofjson

fieldsstring

Selector specifying which fields to include in a partial response.

keystring

API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.

oauth_tokenstring

OAuth 2.0 token for the current user.

prettyPrintboolean

Returns response with indentations and line breaks.

quotaUserstring

An opaque string that represents a user for quota purposes. Must not exceed 40 characters.

userIpstring

Deprecated. Please use quotaUser instead.

maxResultsinteger

Maximum number of results to return

pageTokenstring

Page token, returned by a previous call, identifying the result set

selectedFieldsstring

List of fields to return (comma-separated). If unspecified, all fields are returned

startIndexstring

Zero-based index of the starting row to read

Response

Returns 200 with an object. Read it in later steps with {{bigqueryTabledataList.response.data.<field>}}.

etagstring

A hash of this page of results.

kindstring

The resource type of the response.

Default "bigquery#tableDataList"

pageTokenstring

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.

rowsarray<object>

Rows of results.

farray<object>1 fields

Represents a single row in the result set, consisting of one or more fields.

totalRowsstring (int64)

The total number of rows in the complete table.

json

{
  "etag": "string",
  "kind": "bigquery#tableDataList",
  "pageToken": "string",
  "rows": [
    {
      "f": [
        {
          "v": null
        }
      ]
    }
  ],
  "totalRows": "string"
}

Need more? See the BigQuery guide for connection setup and behaviour shared by every action.

Was this page helpful?