boxr: A high-level R interface for the box.com API

tl;dr

If you have access to client_id and client_secret for a Box-app, you can use box_auth() to authenticate:

box_auth(client_id = "your_client_id", client_secret = "your_client_secret")

This will kick off a process that, all being well, will keep you authenticated for the rest of the R session. By saving this information to your .Renviron file, at your next R session you can use:

box_auth()

If you don’t have access to client_id and client_secret for a Box-app, read on.

More information

There are two different types of apps, as described in this overview article, or in these specific articles:

• Interactive-App: for interactive use on your local computer, this should be the first choice for most situations.
• Service-App: for unattended use, e.g. running scheduled reports.

Directories

Directories are identified using a dir_id:

We should note that the words “directory” and “folder” are used interchangeably, which can be confusing. Box uses the term “folder”, while the R world seems to favor the term “directory”. We assume that you have more familiarity with R than with Box; thus we also favor the term “directory” to name functions and arguments. We also recognize that we are not fully consistent in our implementation.

These functions all take (or return) a dir_id:

• box_setwd(), box_getwd(): set and get the default working directory on Box.
• box_dir_create(): create a Box directory.
• box_ls(): list the files in a Box directory.

Cloud storage services can complement version control systems for code, which aren’t well suited to large binary files (e.g. databases, .RData, or heaps of pdfs). Box explicitly versions binary files, keeping old ones, and making it easy fall back to an older copy.

boxr provides git style facilities to upload, download, and synchronize the contents of entire local and remote directories. The Box API does not support this directly, so boxr loops recursively through directory structures.

• box_push(): update your Box directory with new/changed local files.
• box_fetch(): update your local directory with new/changed Box files.

For these functions, be sure to pay attention to these arguments:

• overwrite, default FALSE.
• delete, default FALSE.
• recursive, default TRUE.

Disclaimer: Box is not a replacement for a VCS/remote-database, and familiar verbs are no guarantee of expected behavior! Do check the function documentation before jumping in.

Files

Files are identified using a file_id:

The main functions that operate on files are:

• box_dl(), box_ul(): download or upload individual files from/to Box.
• box_version_history(): get the history of a Box file.

Interacting with Box files

• box_collab_create(), box_collab_get(), box_collab_delete(): share file or directory on Box.
• box_comment_create(), box_comment_get(): comment on a Box file.
• box_add_description(): add description to a Box file.

Interacting with R Session

• box_read_rds(), box_save_rds(): read or save an RDS file from/to Box.
• box_read(), box_write(): read or write a file serialized by {rio} from/to Box.
• box_load(), box_save(): load or save an R workspace from/to Box.
• box_browse(): open to browser page for a Box file or directory.

Using Box trash

• box_delete_folder(), box_restore_folder(): delete or restore a Box directory.
• box_delete_file(), box_restore_file(): delete or restore a Box file.

Piping

boxr’s functions have been designed to be ‘pipeable’. Here’s a little example:

library(boxr)
library(dplyr)

# 'nycflights13.json' is the same as nycflights13::flights, if you want to
# follow along at home

box_auth()

box_search("nycflights13.json") %>%                # Find a remote file
  box_read() %>%                                   # Download it as a data.frame
    group_by(origin, dest, month) %>%              #   Do some, er, cutting edge
    summarise(mu = mean(arr_delay), n = n()) %>%   #   analysis with dplyr!
  box_write("delay_summary.xlsx") %>%              # Convert to .xlsx, upload
  box_add_description("Check out these averages!") # Add a description to your file!