Low-level function to execute a Sheets API 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.
List. Holds the components for an HTTP request, presumably created
Optional arguments passed through to the HTTP method.
If the body is a named list, how should it be encoded? This has
the same meaning as
make_request() is a very thin wrapper around
only adding the googlesheets4 user agent. Typically the input has been
gargle::request_build() and the output
is processed with
gargle::request_retry() retries requests that error with
429 RESOURCE_EXHAUSTED. Its basic scheme is exponential backoff, with one tweak
that is very specific to the Sheets API, which has documented usage limits:
"a limit of 500 requests per 100 seconds per project and 100 requests per 100 seconds per user"
Note that the "project" here means everyone using googlesheets4 who hasn't configured their own OAuth app. This is potentially a lot of users, all acting independently.
If you hit the "100 requests per 100 seconds per user" limit (which really does mean YOU), the first wait time is a bit more than 100 seconds, then we revert to exponential backoff.
If you experience lots of retries, especially with 100 second delays, it
means your use of googlesheets4 is more than casual and it's time for you
to get your own OAuth app or use a service account token. This is explained
in the gargle vignette
vignette("get-api-credentials", package = "gargle").
Object of class
response from httr.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.