返回所选 Sheets API v4 端点的列表，这些端点存储在 googlesheets4 包中。此列表的名称(或 id 子元素)是可用于指定 request_generate() 中的端点的昵称。对于每个端点，我们存储其昵称或 id 、关联的 HTTP method 、 path 以及有关参数的详细信息。此列表以编程方式从 Sheets API v4 发现文档 (https://www.googleapis.com/discovery/v1/apis/sheets/v4/rest ) 派生。
例子
str(gs4_endpoints(), max.level = 2)
#> List of 17
#> $ sheets.spreadsheets.getByDataFilter :List of 9
#> ..$ id : chr "sheets.spreadsheets.getByDataFilter"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}:getByDataFilter"
#> ..$ parameters :List of 14
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. This method differs from G"| __truncated__
#> ..$ request : chr "GetSpreadsheetByDataFilterRequest"
#> ..$ response : chr "Spreadsheet"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.batchUpdate :List of 9
#> ..$ id : chr "sheets.spreadsheets.batchUpdate"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}:batchUpdate"
#> ..$ parameters :List of 16
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request "| __truncated__
#> ..$ request : chr "BatchUpdateSpreadsheetRequest"
#> ..$ response : chr "BatchUpdateSpreadsheetResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.create :List of 9
#> ..$ id : chr "sheets.spreadsheets.create"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets"
#> ..$ parameters :List of 19
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Creates a spreadsheet, returning the newly created spreadsheet."
#> ..$ request : chr "Spreadsheet"
#> ..$ response : chr "Spreadsheet"
#> ..$ parameterOrder: list()
#> $ sheets.spreadsheets.get :List of 8
#> ..$ id : chr "sheets.spreadsheets.get"
#> ..$ httpMethod : chr "GET"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}"
#> ..$ parameters :List of 14
#> ..$ scopes : chr "drive, drive.file, drive.readonly, spreadsheets, spreadsheets.readonly"
#> ..$ description : chr "Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within gr"| __truncated__
#> ..$ response : chr "Spreadsheet"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.batchUpdate :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.batchUpdate"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchUpdate"
#> ..$ parameters :List of 17
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOpt"| __truncated__
#> ..$ request : chr "BatchUpdateValuesRequest"
#> ..$ response : chr "BatchUpdateValuesResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.batchGetByDataFilter :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.batchGetByDataFilter"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter"
#> ..$ parameters :List of 16
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Returns one or more ranges of values that match the specified data filters. The caller must specify the spreads"| __truncated__
#> ..$ request : chr "BatchGetValuesByDataFilterRequest"
#> ..$ response : chr "BatchGetValuesByDataFilterResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.get :List of 8
#> ..$ id : chr "sheets.spreadsheets.values.get"
#> ..$ httpMethod : chr "GET"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values/{range}"
#> ..$ parameters :List of 16
#> ..$ scopes : chr "drive, drive.file, drive.readonly, spreadsheets, spreadsheets.readonly"
#> ..$ description : chr "Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range."
#> ..$ response : chr "ValueRange"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "range"
#> $ sheets.spreadsheets.values.clear :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.clear"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values/{range}:clear"
#> ..$ parameters :List of 13
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared"| __truncated__
#> ..$ request : chr "ClearValuesRequest"
#> ..$ response : chr "ClearValuesResponse"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "range"
#> $ sheets.spreadsheets.values.batchUpdateByDataFilter:List of 9
#> ..$ id : chr "sheets.spreadsheets.values.batchUpdateByDataFilter"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter"
#> ..$ parameters :List of 17
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOpt"| __truncated__
#> ..$ request : chr "BatchUpdateValuesByDataFilterRequest"
#> ..$ response : chr "BatchUpdateValuesByDataFilterResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.update :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.update"
#> ..$ httpMethod : chr "PUT"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values/{range}"
#> ..$ parameters :List of 20
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption."
#> ..$ request : chr "ValueRange"
#> ..$ response : chr "UpdateValuesResponse"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "range"
#> $ sheets.spreadsheets.values.append :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.append"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values/{range}:append"
#> ..$ parameters :List of 21
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Appends values to a spreadsheet. The input range is used to search for existing data and find a \"table\" withi"| __truncated__
#> ..$ request : chr "ValueRange"
#> ..$ response : chr "AppendValuesResponse"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "range"
#> $ sheets.spreadsheets.values.batchClearByDataFilter :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.batchClearByDataFilter"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter"
#> ..$ parameters :List of 13
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or m"| __truncated__
#> ..$ request : chr "BatchClearValuesByDataFilterRequest"
#> ..$ response : chr "BatchClearValuesByDataFilterResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.batchGet :List of 8
#> ..$ id : chr "sheets.spreadsheets.values.batchGet"
#> ..$ httpMethod : chr "GET"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchGet"
#> ..$ parameters :List of 16
#> ..$ scopes : chr "drive, drive.file, drive.readonly, spreadsheets, spreadsheets.readonly"
#> ..$ description : chr "Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges."
#> ..$ response : chr "BatchGetValuesResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.values.batchClear :List of 9
#> ..$ id : chr "sheets.spreadsheets.values.batchClear"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/values:batchClear"
#> ..$ parameters :List of 13
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or m"| __truncated__
#> ..$ request : chr "BatchClearValuesRequest"
#> ..$ response : chr "BatchClearValuesResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.sheets.copyTo :List of 9
#> ..$ id : chr "sheets.spreadsheets.sheets.copyTo"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo"
#> ..$ parameters :List of 14
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet."
#> ..$ request : chr "CopySheetToAnotherSpreadsheetRequest"
#> ..$ response : chr "SheetProperties"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "sheetId"
#> $ sheets.spreadsheets.developerMetadata.search :List of 9
#> ..$ id : chr "sheets.spreadsheets.developerMetadata.search"
#> ..$ httpMethod : chr "POST"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/developerMetadata:search"
#> ..$ parameters :List of 13
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a Devel"| __truncated__
#> ..$ request : chr "SearchDeveloperMetadataRequest"
#> ..$ response : chr "SearchDeveloperMetadataResponse"
#> ..$ parameterOrder: chr "spreadsheetId"
#> $ sheets.spreadsheets.developerMetadata.get :List of 8
#> ..$ id : chr "sheets.spreadsheets.developerMetadata.get"
#> ..$ httpMethod : chr "GET"
#> ..$ path : 'fs_path' chr "/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}"
#> ..$ parameters :List of 13
#> ..$ scopes : chr "drive, drive.file, spreadsheets"
#> ..$ description : chr "Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the develo"| __truncated__
#> ..$ response : chr "DeveloperMetadata"
#> ..$ parameterOrder: chr [1:2] "spreadsheetId" "metadataId"
gs4_endpoints("sheets.spreadsheets.values.get")
#> $sheets.spreadsheets.values.get
#> $sheets.spreadsheets.values.get$id
#> [1] "sheets.spreadsheets.values.get"
#>
#> $sheets.spreadsheets.values.get$httpMethod
#> [1] "GET"
#>
#> $sheets.spreadsheets.values.get$path
#> /v4/spreadsheets/{spreadsheetId}/values/{range}
#>
#> $sheets.spreadsheets.values.get$parameters
#> $sheets.spreadsheets.values.get$parameters$majorDimension
#> $sheets.spreadsheets.values.get$parameters$majorDimension$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$majorDimension$enum
#> [1] "DIMENSION_UNSPECIFIED" "ROWS"
#> [3] "COLUMNS"
#>
#> $sheets.spreadsheets.values.get$parameters$majorDimension$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$majorDimension$description
#> [1] "The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: `A1=1,B1=2,A2=3,B2=4`, then requesting `range=Sheet1!A1:B2?majorDimension=ROWS` returns `[[1,2],[3,4]]`, whereas requesting `range=Sheet1!A1:B2?majorDimension=COLUMNS` returns `[[1,3],[2,4]]`."
#>
#> $sheets.spreadsheets.values.get$parameters$majorDimension$enumDescriptions
#> [1] "The default value, do not use."
#> [2] "Operates on the rows of a sheet."
#> [3] "Operates on the columns of a sheet."
#>
#>
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption$description
#> [1] "How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER."
#>
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption$enum
#> [1] "SERIAL_NUMBER" "FORMATTED_STRING"
#>
#> $sheets.spreadsheets.values.get$parameters$dateTimeRenderOption$enumDescriptions
#> [1] "Instructs date, time, datetime, and duration fields to be output as doubles in \"serial number\" format, as popularized by Lotus 1-2-3. The whole number portion of the value (left of the decimal) counts the days since December 30th 1899. The fractional portion (right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5, 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3pm would be 33.625. This correctly treats the year 1900 as not a leap year."
#> [2] "Instructs date, time, datetime, and duration fields to be output as strings in their given number format (which depends on the spreadsheet locale)."
#>
#>
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption$enumDescriptions
#> [1] "Values will be calculated & formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` would return `\"$1.23\"`."
#> [2] "Values will be calculated, but not formatted in the reply. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then `A2` would return the number `1.23`."
#> [3] "Values will not be calculated. The reply will include the formulas. For example, if `A1` is `1.23` and `A2` is `=A1` and formatted as currency, then A2 would return `\"=A1\"`."
#>
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption$description
#> [1] "How values should be represented in the output. The default render option is FORMATTED_VALUE."
#>
#> $sheets.spreadsheets.values.get$parameters$valueRenderOption$enum
#> [1] "FORMATTED_VALUE" "UNFORMATTED_VALUE" "FORMULA"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$spreadsheetId
#> $sheets.spreadsheets.values.get$parameters$spreadsheetId$required
#> [1] TRUE
#>
#> $sheets.spreadsheets.values.get$parameters$spreadsheetId$location
#> [1] "path"
#>
#> $sheets.spreadsheets.values.get$parameters$spreadsheetId$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$spreadsheetId$description
#> [1] "The ID of the spreadsheet to retrieve data from."
#>
#>
#> $sheets.spreadsheets.values.get$parameters$range
#> $sheets.spreadsheets.values.get$parameters$range$required
#> [1] TRUE
#>
#> $sheets.spreadsheets.values.get$parameters$range$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$range$location
#> [1] "path"
#>
#> $sheets.spreadsheets.values.get$parameters$range$description
#> [1] "The [A1 notation or R1C1 notation](/sheets/api/guides/concepts#cell) of the range to retrieve values from."
#>
#>
#> $sheets.spreadsheets.values.get$parameters$uploadType
#> $sheets.spreadsheets.values.get$parameters$uploadType$description
#> [1] "Legacy upload protocol for media (e.g. \"media\", \"multipart\")."
#>
#> $sheets.spreadsheets.values.get$parameters$uploadType$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$uploadType$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$callback
#> $sheets.spreadsheets.values.get$parameters$callback$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$callback$description
#> [1] "JSONP"
#>
#> $sheets.spreadsheets.values.get$parameters$callback$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$fields
#> $sheets.spreadsheets.values.get$parameters$fields$description
#> [1] "Selector specifying which fields to include in a partial response."
#>
#> $sheets.spreadsheets.values.get$parameters$fields$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$fields$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`$description
#> [1] "V1 error format."
#>
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`$enumDescriptions
#> [1] "v1 error format" "v2 error format"
#>
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`$enum
#> [1] "1" "2"
#>
#> $sheets.spreadsheets.values.get$parameters$`$.xgafv`$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$upload_protocol
#> $sheets.spreadsheets.values.get$parameters$upload_protocol$description
#> [1] "Upload protocol for media (e.g. \"raw\", \"multipart\")."
#>
#> $sheets.spreadsheets.values.get$parameters$upload_protocol$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$upload_protocol$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$prettyPrint
#> $sheets.spreadsheets.values.get$parameters$prettyPrint$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$prettyPrint$description
#> [1] "Returns response with indentations and line breaks."
#>
#> $sheets.spreadsheets.values.get$parameters$prettyPrint$type
#> [1] "boolean"
#>
#> $sheets.spreadsheets.values.get$parameters$prettyPrint$default
#> [1] "true"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$quotaUser
#> $sheets.spreadsheets.values.get$parameters$quotaUser$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$quotaUser$description
#> [1] "Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters."
#>
#> $sheets.spreadsheets.values.get$parameters$quotaUser$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$alt
#> $sheets.spreadsheets.values.get$parameters$alt$description
#> [1] "Data format for response."
#>
#> $sheets.spreadsheets.values.get$parameters$alt$enumDescriptions
#> [1] "Responses with Content-Type of application/json"
#> [2] "Media download with context-dependent Content-Type"
#> [3] "Responses with Content-Type of application/x-protobuf"
#>
#> $sheets.spreadsheets.values.get$parameters$alt$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$alt$default
#> [1] "json"
#>
#> $sheets.spreadsheets.values.get$parameters$alt$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$alt$enum
#> [1] "json" "media" "proto"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$oauth_token
#> $sheets.spreadsheets.values.get$parameters$oauth_token$description
#> [1] "OAuth 2.0 token for the current user."
#>
#> $sheets.spreadsheets.values.get$parameters$oauth_token$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$oauth_token$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$key
#> $sheets.spreadsheets.values.get$parameters$key$description
#> [1] "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."
#>
#> $sheets.spreadsheets.values.get$parameters$key$type
#> [1] "string"
#>
#> $sheets.spreadsheets.values.get$parameters$key$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.values.get$parameters$access_token
#> $sheets.spreadsheets.values.get$parameters$access_token$location
#> [1] "query"
#>
#> $sheets.spreadsheets.values.get$parameters$access_token$description
#> [1] "OAuth access token."
#>
#> $sheets.spreadsheets.values.get$parameters$access_token$type
#> [1] "string"
#>
#>
#>
#> $sheets.spreadsheets.values.get$scopes
#> [1] "drive, drive.file, drive.readonly, spreadsheets, spreadsheets.readonly"
#>
#> $sheets.spreadsheets.values.get$description
#> [1] "Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range."
#>
#> $sheets.spreadsheets.values.get$response
#> [1] "ValueRange"
#>
#> $sheets.spreadsheets.values.get$parameterOrder
#> [1] "spreadsheetId" "range"
#>
#>
gs4_endpoints(4)
#> $sheets.spreadsheets.get
#> $sheets.spreadsheets.get$id
#> [1] "sheets.spreadsheets.get"
#>
#> $sheets.spreadsheets.get$httpMethod
#> [1] "GET"
#>
#> $sheets.spreadsheets.get$path
#> /v4/spreadsheets/{spreadsheetId}
#>
#> $sheets.spreadsheets.get$parameters
#> $sheets.spreadsheets.get$parameters$ranges
#> $sheets.spreadsheets.get$parameters$ranges$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$ranges$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$ranges$description
#> [1] "The ranges to retrieve from the spreadsheet."
#>
#> $sheets.spreadsheets.get$parameters$ranges$repeated
#> [1] TRUE
#>
#>
#> $sheets.spreadsheets.get$parameters$includeGridData
#> $sheets.spreadsheets.get$parameters$includeGridData$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$includeGridData$description
#> [1] "True if grid data should be returned. This parameter is ignored if a field mask was set in the request."
#>
#> $sheets.spreadsheets.get$parameters$includeGridData$type
#> [1] "boolean"
#>
#>
#> $sheets.spreadsheets.get$parameters$spreadsheetId
#> $sheets.spreadsheets.get$parameters$spreadsheetId$required
#> [1] TRUE
#>
#> $sheets.spreadsheets.get$parameters$spreadsheetId$description
#> [1] "The spreadsheet to request."
#>
#> $sheets.spreadsheets.get$parameters$spreadsheetId$location
#> [1] "path"
#>
#> $sheets.spreadsheets.get$parameters$spreadsheetId$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.get$parameters$uploadType
#> $sheets.spreadsheets.get$parameters$uploadType$description
#> [1] "Legacy upload protocol for media (e.g. \"media\", \"multipart\")."
#>
#> $sheets.spreadsheets.get$parameters$uploadType$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$uploadType$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.get$parameters$callback
#> $sheets.spreadsheets.get$parameters$callback$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$callback$description
#> [1] "JSONP"
#>
#> $sheets.spreadsheets.get$parameters$callback$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.get$parameters$fields
#> $sheets.spreadsheets.get$parameters$fields$description
#> [1] "Selector specifying which fields to include in a partial response."
#>
#> $sheets.spreadsheets.get$parameters$fields$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$fields$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.get$parameters$`$.xgafv`
#> $sheets.spreadsheets.get$parameters$`$.xgafv`$description
#> [1] "V1 error format."
#>
#> $sheets.spreadsheets.get$parameters$`$.xgafv`$enumDescriptions
#> [1] "v1 error format" "v2 error format"
#>
#> $sheets.spreadsheets.get$parameters$`$.xgafv`$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$`$.xgafv`$enum
#> [1] "1" "2"
#>
#> $sheets.spreadsheets.get$parameters$`$.xgafv`$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.get$parameters$upload_protocol
#> $sheets.spreadsheets.get$parameters$upload_protocol$description
#> [1] "Upload protocol for media (e.g. \"raw\", \"multipart\")."
#>
#> $sheets.spreadsheets.get$parameters$upload_protocol$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$upload_protocol$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.get$parameters$prettyPrint
#> $sheets.spreadsheets.get$parameters$prettyPrint$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$prettyPrint$description
#> [1] "Returns response with indentations and line breaks."
#>
#> $sheets.spreadsheets.get$parameters$prettyPrint$type
#> [1] "boolean"
#>
#> $sheets.spreadsheets.get$parameters$prettyPrint$default
#> [1] "true"
#>
#>
#> $sheets.spreadsheets.get$parameters$quotaUser
#> $sheets.spreadsheets.get$parameters$quotaUser$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$quotaUser$description
#> [1] "Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters."
#>
#> $sheets.spreadsheets.get$parameters$quotaUser$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.get$parameters$alt
#> $sheets.spreadsheets.get$parameters$alt$description
#> [1] "Data format for response."
#>
#> $sheets.spreadsheets.get$parameters$alt$enumDescriptions
#> [1] "Responses with Content-Type of application/json"
#> [2] "Media download with context-dependent Content-Type"
#> [3] "Responses with Content-Type of application/x-protobuf"
#>
#> $sheets.spreadsheets.get$parameters$alt$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$alt$default
#> [1] "json"
#>
#> $sheets.spreadsheets.get$parameters$alt$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$alt$enum
#> [1] "json" "media" "proto"
#>
#>
#> $sheets.spreadsheets.get$parameters$oauth_token
#> $sheets.spreadsheets.get$parameters$oauth_token$description
#> [1] "OAuth 2.0 token for the current user."
#>
#> $sheets.spreadsheets.get$parameters$oauth_token$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$oauth_token$type
#> [1] "string"
#>
#>
#> $sheets.spreadsheets.get$parameters$key
#> $sheets.spreadsheets.get$parameters$key$description
#> [1] "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."
#>
#> $sheets.spreadsheets.get$parameters$key$type
#> [1] "string"
#>
#> $sheets.spreadsheets.get$parameters$key$location
#> [1] "query"
#>
#>
#> $sheets.spreadsheets.get$parameters$access_token
#> $sheets.spreadsheets.get$parameters$access_token$location
#> [1] "query"
#>
#> $sheets.spreadsheets.get$parameters$access_token$description
#> [1] "OAuth access token."
#>
#> $sheets.spreadsheets.get$parameters$access_token$type
#> [1] "string"
#>
#>
#>
#> $sheets.spreadsheets.get$scopes
#> [1] "drive, drive.file, drive.readonly, spreadsheets, spreadsheets.readonly"
#>
#> $sheets.spreadsheets.get$description
#> [1] "Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a [field mask](https://developers.google.com/sheets/api/guides/field-masks) listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are specified using [A1 notation](/sheets/api/guides/concepts#cell). You can define a single cell (for example, `A1`) or multiple cells (for example, `A1:D5`). You can also get cells from other sheets within the same spreadsheet (for example, `Sheet2!A1:C4`) or retrieve multiple ranges at once (for example, `?ranges=A1:D5&ranges=Sheet2!A1:C4`). Limiting the range returns only the portions of the spreadsheet that intersect the requested ranges."
#>
#> $sheets.spreadsheets.get$response
#> [1] "Spreadsheet"
#>
#> $sheets.spreadsheets.get$parameterOrder
#> [1] "spreadsheetId"
#>
#>
相关用法
- R googlesheets4 gs4_examples 示例表
- R googlesheets4 gs4_token 生成配置的令牌
- R googlesheets4 gs4_formula Google 表格公式类
- R googlesheets4 gs4_random 生成随机工作表名称
- R googlesheets4 gs4_user 获取当前用户的信息
- R googlesheets4 gs4_auth_configure 编辑和查看身份验证配置
- R googlesheets4 gs4_fodder 创建有用的电子表格填充程序
- R googlesheets4 gs4_auth 授权 googlesheets4
- R googlesheets4 gs4_find 查找 Google 表格
- R googlesheets4 gs4_get 获取工作表元数据
- R googlesheets4 gs4_scopes 特定于 Sheets API 的生成范围
- R googlesheets4 gs4_has_token 手上有令牌吗？
- R googlesheets4 gs4_create 创建一个新工作表
- R googlesheets4 gs4_browse 在网络浏览器中访问工作表
- R googlesheets4 gs4_deauth 暂停授权
- R googlesheets4 googlesheets4-configuration 谷歌表4配置
- R googlesheets4 sheet_rename 重命名(工作)表
- R googlesheets4 sheet_delete 删除一张或多张(工作)表
- R googlesheets4 range_autofit 自动调整列或行以适应数据
- R googlesheets4 range_speedread 将工作表读取为 CSV
- R googlesheets4 range_read_cells 从工作表中读取单元格
- R googlesheets4 spread_sheet 将单元格 DataFrame 展开为电子表格形状
- R googlesheets4 sheet_properties 获取有关(工作)表的数据
- R googlesheets4 sheets_id Sheets_id 类
- R googlesheets4 sheet_append 将行附加到工作表
注：本文由纯净天空筛选整理自Jennifer Bryan等大神的英文原创作品 List Sheets endpoints。非经特殊声明，原始代码版权归原作者所有，本译文未经允许或授权，请勿转载或复制。