Retrieves table data from a specified set of rows. Requires the READER dataset role.
Arguments
Parameters | |
---|---|
datasetId |
Required. Dataset ID of the table to read
|
projectId |
Required. Project ID of the table to read
|
tableId |
Required. Table ID of the table to read
|
maxResults |
Maximum number of results to return
|
pageToken |
Page token, returned by a previous call, identifying the result set
|
selectedFields |
List of fields to return (comma-separated). If unspecified, all fields are returned
|
startIndex |
Zero-based index of the starting row to read
|
Raised exceptions
Exceptions | |
---|---|
ConnectionError |
In case of a network problem (such as DNS failure or refused connection). |
HttpError |
If the response status is >= 400 (excluding 429 and 503). |
TimeoutError |
If a long-running operation takes longer to finish than the specified timeout limit. |
TypeError |
If an operation or function receives an argument of the wrong type. |
ValueError |
If an operation or function receives an argument of the right type but an inappropriate value. For example, a negative timeout. |
Response
If successful, the response contains an instance of TableDataList
.
Subworkflow snippet
Some fields might be optional or required. To identify required fields, refer to the API documentation.
YAML
- list: call: googleapis.bigquery.v2.tabledata.list args: datasetId: ... projectId: ... tableId: ... maxResults: ... pageToken: ... selectedFields: ... startIndex: ... result: listResult
JSON
[ { "list": { "call": "googleapis.bigquery.v2.tabledata.list", "args": { "datasetId": "...", "projectId": "...", "tableId": "...", "maxResults": "...", "pageToken": "...", "selectedFields": "...", "startIndex": "..." }, "result": "listResult" } } ]