Generate a request, using knowledge of the Sheets API from its Discovery Document. Use
request_make() to execute the request. Most users should, instead, use
higher-level wrappers that facilitate common tasks, such as reading or
writing worksheets or cell ranges. The functions here are intended for
internal use and for programming around the Sheets API.
request_generate() lets you provide the bare minimum of input.
It takes a nickname for an endpoint and:
Uses the API spec to look up the
params for validity and completeness with respect to the
params for URL endpoint substitution and separates
remaining parameters into those destined for the body versus the query.
Adds an API key to the query if and only if
token = NULL.
request_generate( endpoint = character(), params = list(), key = NULL, token = gs4_token() )
Character. Nickname for one of the selected Sheets API v4
endpoints built into googlesheets4. Learn more in
Named list. Parameters destined for endpoint URL substitution, the query, or the body.
API key. Needed for requests that don't contain a token. The need
for an API key in the absence of a token is explained in Google's document
Credentials, access, security, and identity.
In order of precedence, these sources are consulted: the formal
req <- request_generate( "sheets.spreadsheets.get", list(spreadsheetId = gs4_example("deaths")), token = NULL ) req#> $method #>  "GET" #> #> $url #>  "https://sheets.googleapis.com/v4/spreadsheets/1VTJjWoP1nshbyxmL9JqXgdVsimaYty21LGxxs018H2Y?key=AIzaSyDKRsnYs5G4c8y4BMlXLKTKMTheNXrsNEM" #> #> $body #> named list() #> #> $token #> NULL #>