List
|
|||||
|
|
||||
Retrieves table data from a specified set of rows. Requires the READER dataset role
Authorization
To use this building block you will have to grant access to at least one of the following scopes:
- View and manage your data in Google BigQuery
- View and manage your data across Google Cloud Platform services
- View your data across Google Cloud Platform services
Input
This building block consumes 7 input parameters
| Name | Format | Description |
|---|---|---|
projectId Required |
STRING |
Project ID of the table to read |
datasetId Required |
STRING |
Dataset ID of the table to read |
tableId Required |
STRING |
Table ID of the table to read |
selectedFields |
STRING |
List of fields to return (comma-separated). If unspecified, all fields are returned |
startIndex |
INTEGER |
Zero-based index of the starting row to read |
pageToken |
STRING |
Page token, returned by a previous call, identifying the result set |
maxResults |
INTEGER |
Maximum number of results to return |
= Parameter name
= Format
|
projectId STRING Required Project ID of the table to read |
|
datasetId STRING Required Dataset ID of the table to read |
|
tableId STRING Required Table ID of the table to read |
|
selectedFields STRING List of fields to return (comma-separated). If unspecified, all fields are returned |
|
startIndex INTEGER Zero-based index of the starting row to read |
|
pageToken STRING Page token, returned by a previous call, identifying the result set |
|
maxResults INTEGER Maximum number of results to return |
Output
This building block provides 7 output parameters
| Name | Format | Description |
|---|---|---|
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 |
kind |
STRING |
The resource type of the response |
totalRows |
INTEGER |
The total number of rows in the complete table |
etag |
STRING |
A hash of this page of results |
rows[] |
OBJECT |
|
rows[].f[] |
OBJECT |
|
rows[].f[].v |
ANY |
= Parameter name
= Format
|
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 |
|
kind STRING The resource type of the response |
|
totalRows INTEGER The total number of rows in the complete table |
|
etag STRING A hash of this page of results |
|
rows[] OBJECT |
|
rows[].f[] OBJECT |
|
rows[].f[].v ANY |