rdrop2

rDrop: Dropbox interface via R

This package provides a programmatic interface to Dropbox from the R environment. The package is complete and fully working but waiting on a dependency to be updated on CRAN before it can be submitted.

Disclaimer: This package is fairly new and likely to contain bugs so please use discretion and report any issues here on github

Important: This package relies on ROAuth 0.92 and the version currently available on CRAN does not play so well with rDrop. Install the version on Duncan's github:

library(devtools)
install_github("duncantl/ROAuth")

Without the newest ROAuth rDrop WILL NOT WORK!

Installing

library(devtools)
install_github("karthik/rDrop")

Initial setup

To begin, create an App on Dropbox from the Dropbox developer site. You will need to log in with your Dropbox username and password.Then, click Create An App.

Next, provide a unique (in the universe of Dropbox apps) name to your personal app. Dropbox branding guidelines prohibit the use of the word "Dropbox" or names that begin with "Drop". We recommend that you name the app "Your_first_name_last_name_rDrop" to avoid naming conflicts but feel free to call it whatever you like. You won't have to deal with the app name after this step.

Once you click create, be sure to copy your App key and App secret and store it somewhere safe. If you forget it, you can always find it here (Just click on options next to your App name). If you use your .rprofile and no one else uses your computer, then we recommend you save your keys there by adding the following lines:

options(DropboxKey = "Your_App_key")
options(DropboxSecret = "Your_App_Secret")

If you prefer not to specify keys in a .rprofile (especially if you are on a public computer/cluster/the cloud), you can specify both keys in the dropbox_auth() function directly (more on this below). Note that once you have authorized an app, there is no need to call this function again. You can just use your saved credential file to access your Dropbox. If for any reason, the credential file becomes compromised, just revoke access from your list of authorized apps and start over.

Authorizing your app

library(rDrop)
# If you have Dropbox keys in your .rprofile, simply run:
 dropbox_credentials <- dropbox_auth()
# Otherwise:
 dropbox_credentials <- dropbox_auth("Your_consumer_key", "Your_consumer_secret")

If you entered valid keys, you will be directed to a secure Dropbox page on your browser asking you to authorize the app you just created. Click authorize to add this to your approved app list and return to R. This is a one time authorization. Once you have completed these steps, return to R. There is no need to run dropbox_auth() for each subsequent run. Simply save your credentials file to disk and load as needed:

 save(dropbox_credentials, file="/path/to/my_dropbox_credentials.rdata")

Credentials will remain valid until you revoke them from your Dropbox Apps page by clicking the x next to your App's name.

Quick User Guide

This package essentially provides standard Dropbox file operation functions (create/copy/move/restore/share) from within R.

To load a previously validated Dropbox credential file:

load('/path/to/my_dropbox_credentials.rdata')
# or once again run,
dropbox_credentials <- dropbox_auth('Your_consumer_key', 'Your_consumer_secret')

Summary of your Dropbox Account

dropbox_acc_info(dropbox_credentials)
# will return a list with your display name, email, quota, referral URL, and country.

Directory listing

dropbox_dir(dropbox_credentials)
# To list files and folders in your Dropbox root.
dropbox_dir(dropbox_credentials, pattern=".rdata")
# To list files and folders matching a pattern. Any regex should work.
dropbox_dir(dropbox_credentials, verbose = TRUE)
# for a complete listing (filename, revision, thumb, bytes, modified, path, and is_dir) with detailed information.
dropbox_dir(dropbox_credentials, path = 'folder_name')
# To see contents of a specified path.
dropbox_dir(dropbox_credentials, path = 'folder_name', verbose = TRUE)
# For verbose content listing for a specified path (relative to Dropbox root).

Download files from your Dropbox account to R

# Reading text files
file <- dropbox_get(dropbox_credentials, 'my_data.csv')
data <- read.csv(textConnection(file))

# Reading CSV files (a wrapper around dropbox_get specific to csv files)
my_data <- db.read.csv(dropbox_credentials, 'my_data.csv', header = TRUE)



# Reading .rdata files
df <- data.frame(x=1:10, y=rnorm(10))
dropbox_save(dropbox_credentials, df, file="df.rdata")
# Now let's download this file back into R
rm(df)
downloaded_df <- unserialize(dropbox_get(dropbox_credentials, "df.rdata"))
# Another quick/dirty way to read private content from your Dropbox into R is using the dropbox_media() function.
# Example:
source <- dropbox_media(cred, 'test_works/move.txt')
read.csv(source$url)

Upload R objects to your Dropbox

# ext default is .rda.
a = 1:4
b = letters[1:3]
dropbox_save(dropbox_credentials, list(a,b), "duncan", verbose = TRUE, ext = ".rda")

Moving files within Dropobx

# Note that all paths are relative to your dropbox root. Leave blank or use / for root.
dropbox_move(dropbox_credentials, from_path, to_path)
# from_path can be a folder or file. to_path has to be a folder.

Copying files within Dropbox

# Note that all paths are relative to your dropbox root. Leave blank or use / for root.
dropbox_copy(dropbox_credentials, from_path, to_path)
# To overwrite existing file/folder in destination, add overwrite = TRUE.

Creating a public share for any Dropbox file or folder

share <- dropbox_share(dropbox_credentials, file)
# returns a list of two elements (url and expires)
share$url # returns a URL to the share
share$expires # shows when the link will expire
# File/folder to share. Returns share URL with expiration information.
# Link goes directly to files. Folder are automatically zipped up.

Reference: Complete Dropbox API Reference.