- HTTP request
- Path parameters
- Query parameters
- Request body
- Response body
- Authorization scopes
- Try it!
Lists all routines in the specified dataset. Requires the READER dataset role.
HTTP request
GET https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines
The URL uses gRPC Transcoding syntax.
Path parameters
Parameters | |
---|---|
project |
Required. Project ID of the routines to list |
dataset |
Required. Dataset ID of the routines to list |
Query parameters
Parameters | |
---|---|
max |
The maximum number of results to return in a single response page. Leverage the page tokens to iterate through the entire collection. |
page |
Page token, returned by a previous call, to request the next page of results |
read |
If set, then only the Routine fields in the field mask, as well as projectId, datasetId and routineId, are returned in the response. If unset, then the following Routine fields are returned: etag, projectId, datasetId, routineId, routineType, creationTime, lastModifiedTime, and language. This is a comma-separated list of fully qualified names of fields. Example: |
filter |
If set, then only the Routines matching this filter are returned. The supported format is |
Request body
The request body must be empty.
Response body
Describes the format of a single result page when listing routines.
If successful, the response body contains data with the following structure:
JSON representation |
---|
{
"routines": [
{
object ( |
Fields | |
---|---|
routines[] |
Routines in the requested dataset. Unless readMask is set in the request, only the following fields are populated: etag, projectId, datasetId, routineId, routineType, creationTime, lastModifiedTime, language, and remoteFunctionOptions. |
next |
A token to request the next page of results. |
Authorization scopes
Requires one of the following OAuth scopes:
https://www.googleapis.com/auth/bigquery
https://www.googleapis.com/auth/cloud-platform
https://www.googleapis.com/auth/bigquery.readonly
https://www.googleapis.com/auth/cloud-platform.read-only
For more information, see the Authentication Overview.