Google Sheets R API Versions Save

Google Spreadsheets R API

v0.3.0

5 years ago

The motivation for this release is to avoid a warning on R-devel that occurs if a package is referenced in the tests (in this case, tibble) that is not a direct dependency. We now use an equivalent function from the imported package dplyr.

v0.2.2

7 years ago

The motivation for this release is for compatibility with the about-to-be released purrr 0.2.2.1.

  • Update ggplot2 usage to clear warnings about use of deprecated arguments.
  • Remove all uses of purrr::dmap() and friends, which have been removed from purrr.
  • gs_upload() now has an overwrite argument. (#285 @omgjens)
  • Add vignette to show interactive authentication in a non-default browser.

v0.2.1

7 years ago
  • XML is no longer a dependency.
  • Automatic retries for Internal Server Error (HTTP 500). On or around 2016-03-11, there was a huge increase in the frequency of this error on Google Drive API calls.
    • Remedy: all HTTP GET calls in the package are automatically retried up to 5 times, with exponential backoff, for statuses 500 and higher.
  • Functions prefixed with gd_ refer to Google Drive and might eventually migrate into a separate Google Drive package. Generally there is a synonym with the gs_ prefix.
  • gd_token() is a new function to expose information about the current Google token. Some of this was migrated out of gd_user() and into gd_token(). New information includes scopes and cache path.
  • gd_user() now returns an S3 object of class drive_user, but it's really just a list with a nice print method. It exposes information about the current Google user. New information includes user's Drive permissionId and rootFolderId.

v0.2.0

8 years ago

googlesheets 0.2.0

  • Added a NEWS.md file to track changes to the package.
  • httr v1.1.0: to become compatible with this version, we now require it.
  • Dependency changes:
    • plyr is no longer required (#204)
    • purrr is a new dependency
  • gs_browse() is a new function to visit a Google Sheet in the browser.
  • gs_rename() is a new function to rename an existing Sheet (#145).
  • gs_add_row() now works for two-dimensional input, by calling itself once per row of input (#188, @jimhester).
  • Updated the scope for the Drive API. It is possible that new/updated Drive functions will require a token obtained with the new scope. This could mean that tokens stored and loaded from file in a non-interactive environment will need to be remade.
  • gs_read_listfeed() now supports parameters to manipulate data in the API call itself: reverse inverts row order, orderby selects a column to sort on, sq accepts a structured query to filter rows. (#17)
  • gs_read_listfeed() doesn't return API-mangled column names anymore. They should now be the same as those from the other read functions and what you see in the browser.
  • readr-style data ingest: We explicitly try to match the interface of readr::read_csv(). The read functions gs_read(), gs_read_csv(), and gs_read_listfeed() and the reshaper gs_reshape_cellfeed() should all return the same data frame when operating on the same worksheet. And this should match what readr::read_csv() would return on a .csv file exported from that worksheet. The type conversion arguments for gs_simplify_cellfeed() have also changed accordingly.
    • The header argument is no longer accepted. Use col_names.
    • If you're not happy with the defaults, take control via the ... arguments of gs_read* or reshape/simplify functions. Specify column_types, col_names, locale, na, trim_ws, etc. here.
    • See the sections "Controlling data ingest, theory and practice" in the the basic usage vignette for details and examples.
    • readr exception #1: variables that consist entirely of missing values will be NA of the logical type, not NA_character_.
    • readr exception #2: googlesheets will never return a data frame with NA as a variable name. Instead, it will create a dummy variable name, like X5.
    • readr exception #3: All read/reshape functions accept check.names, in the spirit of utils::read.table(), which defaults to FALSE. If TRUE, variable names will be run through make.names(..., unique = TRUE). (#208)
  • gs_read_cellfeed() now returns all possible definitions of cell contents:
    • value: The variable previously known as cell_text. What you see in the browser and what Sheets API returns by default.
    • input_value: What you would have typed into the cell. Will give unevaluated formulas. (#18, #19, #152)
    • numeric_value: An actual number, if such exists, unmangled by rounding or other numeric formatting. (#152, #178)
  • New argument literal = FALSE available in reading/reshaping functions that call the cell feed. Tries to be clever about using different definitions of cell contents.
  • gs_deauth() is a newly exported function that allows you to suspend the current token and, optionally, disable the .httr-oauth token cache file by renaming it to .httr-oauth-SUSPENDED.

Here is the actual .tar.gz that was submitted to CRAN (prepared in a CRAN submission branch, due to vignette issues that need to be finessed.)

googlesheets_0.2.0.tar.gz

v0.1.0.9000

8 years ago

Zenodo seems to require a new release to start working with a GitHub repo. That is the only reason for this "release".

v0.1.0

8 years ago

v0.0.0.9003

8 years ago

Requires v1.0.0 or later of cellranger

v0.0.0.9002

8 years ago

Completes the major user-facing changes planned at this point.

v0.0.0.9001

9 years ago

v0.0.0.9000

9 years ago