Error: 'request_retry' is not an exported object from 'namespace:gargle'

[mikegunn]

Hi there, read sheet is throwing up this error, i have tried to install and re-install gargle and i am also using the devtools package (devtools::install_github("tidyverse/googlesheets4",force=TRUE)) which looks to partly install gargle i believe?

EPL_CARDS<-read_sheet("17gxSsNCJ4nYTV3npmlXXXXXXXX", sheet = "EPL Players" ) (XXXX'd out so my sheet isn't public)
Error: 'request_retry' is not an exported object from 'namespace:gargle'

Sorry if this is vague, there isn't much more to put in the request.

[mikegunn]

re-installed googlesheets4 and now working!

[jennybc]

request_retry() is a gargle function that only exists in a pull request in the dev version of gargle, which is used by the dev version of googlesheets4.

As it seems you discovered (but perhaps not with full realization), you either need to install googlesheets4 from CRAN and use the official release or you need to do devtools::install_github("tidyverse/googlesheets4") in order to pick up the smarts re: installing gargle from a PR. This is a temporary dev situation that is useful to me.

[DannySmith111]

Hi Jenny, I was wondering if you could help me re-install googlesheets4. For some reason the sheets_write() function disappeared for me so I am trying to re-install, however I am having issues with the 'glue' package.

Error: Failed to install 'googlesheets4' from GitHub:
(converted from warning) cannot remove prior installation of package ‘glue’

It also looks like I am having the same for the 'fs' package.

Any idea what to do? I have tried removing the glue package but it says it does not seem to exist.
Thanks!

[jennybc]

I suspect you're on Windows and seeing some of its infamous package installation problems.

The problem is described in general here:
https://www.jimhester.com/post/2020-08-20-best-os-for-r/

And here's a thread where we talk about how we usually answer this question:
rstats-wtf/what-they-forgot#62

[pesavage]

request_retry() is a gargle function that only exists in a pull request in the dev version of gargle, which is used by the dev version of googlesheets4.

As it seems you discovered (but perhaps not with full realization), you either need to install googlesheets4 from CRAN and use the official release or you need to do devtools::install_github("tidyverse/googlesheets4") in order to pick up the smarts re: installing gargle from a PR. This is a temporary dev situation that is useful to me.

When I try to install this (OSX I get the following error message. This used to work for me back in 2020 but isn't working any more now in May 11 2021. I tried on both RStudio (Version 1.1.383) and base R (R 3.5.3) Any thoughts?

devtools::install_github("tidyverse/googlesheets4")
Error: Failed to install 'googlesheets4' from GitHub:
HTTP error 401.
Bad credentials

Rate limit remaining: 55/60
Rate limit reset at: 2021-05-11 08:54:22 UTC

[jennybc]

Bad credentials

I assume this means what it says. I.e. your are sending a personal access token that has become invalid. Historically, we often set these via an env var in .Renviron. More recently, we recommend that people use R packages that can manage this PAT via the Git credential store. Hopefully you can figure out which approach you have rigged, get rid of the old PAT, and configure a new and valid one.

https://usethis.r-lib.org/articles/articles/git-credentials.html

[pesavage]

Thanks!