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: "user.displayName,photo".
filter
string
If set, then only the Routines matching this filter are returned. The supported format is routineType:{RoutineType}, where {RoutineType} is a RoutineType enum. For example: routineType:SCALAR_FUNCTION.
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:
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[[["\u003cp\u003eThis API endpoint retrieves a list of routines within a specified dataset, requiring the READER dataset role.\u003c/p\u003e\n"],["\u003cp\u003eThe HTTP request is a GET request to a specific URL structure including \u003ccode\u003eprojectId\u003c/code\u003e and \u003ccode\u003edatasetId\u003c/code\u003e as mandatory path parameters.\u003c/p\u003e\n"],["\u003cp\u003eOptional query parameters such as \u003ccode\u003emaxResults\u003c/code\u003e, \u003ccode\u003epageToken\u003c/code\u003e, \u003ccode\u003ereadMask\u003c/code\u003e, and \u003ccode\u003efilter\u003c/code\u003e are available to refine the search criteria and pagination.\u003c/p\u003e\n"],["\u003cp\u003eThe request body must be empty, and the successful response includes an array of \u003ccode\u003eroutines\u003c/code\u003e and a \u003ccode\u003enextPageToken\u003c/code\u003e for pagination, represented in a JSON format.\u003c/p\u003e\n"],["\u003cp\u003eAuthorization for this operation requires one of the listed OAuth scopes, including \u003ccode\u003ehttps://www.googleapis.com/auth/bigquery\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Method: routines.list\n\n- [HTTP request](#body.HTTP_TEMPLATE)\n- [Path parameters](#body.PATH_PARAMETERS)\n- [Query parameters](#body.QUERY_PARAMETERS)\n- [Request body](#body.request_body)\n- [Response body](#body.response_body)\n - [JSON representation](#body.ListRoutinesResponse.SCHEMA_REPRESENTATION)\n- [Authorization scopes](#body.aspect)\n- [Try it!](#try-it)\n\nLists all routines in the specified dataset. Requires the READER dataset role.\n\n### HTTP request\n\n`GET https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines`\n\nThe URL uses [gRPC Transcoding](https://google.aip.dev/127) syntax.\n\n### Path parameters\n\n### Query parameters\n\n### Request body\n\nThe request body must be empty.\n\n### Response body\n\nDescribes the format of a single result page when listing routines.\n\nIf successful, the response body contains data with the following structure:\n\n### Authorization scopes\n\nRequires one of the following OAuth scopes:\n\n- `https://www.googleapis.com/auth/bigquery`\n- `https://www.googleapis.com/auth/cloud-platform`\n- `https://www.googleapis.com/auth/bigquery.readonly`\n- `https://www.googleapis.com/auth/cloud-platform.read-only`\n\nFor more information, see the [Authentication Overview](/docs/authentication#authorization-gcp)."]]
