Store SFTP Zip Files as an Object to create Pin in R Studio Connect

General
1

The goal is to store an object that can then be stored as a pin on R Studio Connect. I would prefer not to download the file on my local machine as this is a manual step. I want to automate the pulling of the data using the SFTP connection.

I currently am able to download files from my SFTP connection using the sftp package in r. After some research, I was able to create an object using this code:

connection <- sftp::sftp_connect(
  server   = "host_server.com",
  folder   = "/file/folder",
  username = "user_name",
  password = "password",
  protocol = "sftp://",
  port     = 22,
  timeout = 30)

fileurl <- paste0(connection$url, "/", "filename.csv.zip")
port    <- as.integer(connection$port)
userpwd <- connection$userpass
timeout <- connection$timeout

test <- RCurl::getBinaryURL(url = fileurl,
                            port = port,
                            userpwd = userpwd,
                            connecttimeout = timeout,
                            .opts = list(),
                            dirlistonly = FALSE)

At the moment, I'm stuck on how to then transfer this object to something that can be read by humans. Is there a step that I'm missing in between since the file that I'm trying to retrieve is a zip file?

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.