Styjun

At which point can a system be compromised when downloading archived data from an untrusted source?

Was Jacobi the first to notice the ambiguity in the partial derivatives notation? And did anyone object to his fix?

Does the Intel 8085 CPU use real memory addresses?

Is it ethical for a company to ask its employees to move furniture on a weekend?

Why is Katakana not pronounced Katagana?

Why don't commercial aircraft adopt a slightly more seaplane-like design to allow safer ditching in case of emergency?

Can you perfectly wrap a cube with this blocky shape?

Do dragons smell of lilacs?

Does this sentence I constructed with my junior high school latin work? I write online advertising and want to come off as snobby as possible

Why does FFmpeg choose 10+20+20 ms instead of an even 16 ms for 60 fps GIF images?

Vienna To Graz By Rail

What "fuel more powerful than anything the West (had) in stock" put Laika in orbit aboard Sputnik 2?

What is the point of a constraint expression on a non-templated function?

Coverting list of string into integers and reshaping the original list

Wordplay subtraction paradox

How can I help our ranger feel special about her beast companion?

My credit card has no magnetic stripe. Is this a problem in the USA?

Wordplay addition paradox

Is passive Investigation essentially truesight against illusions?

Where are the rest of the Dwarves of Nidavellir?

Is this Android phone Android 9.0 or Android 6.0?

What happens if there is no space for entry stamp in the passport for US visa?

Cauchy reals and Dedekind reals satisfy "the same mathematical theorems"

Which GPUs to get for Mathematical Optimization (if any...)?

Receive csv using plumber through a POST request

Sending json file in curl and receiving it in R using plumberGet file through API call (R & plumber)Plumber - mounted routersPlumber R package - post request not workingServe arbitrary image files through plumberServe downloadable files with plumberR Plumber posting a PDFaccept nested json using post in plumber and accepts few arguments plumberUsing 'new' in Plumberellipsis usage with plumber

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am looking to send a csv file to a database as someone posts the file using their VBA code (VBA has a 80 character limit for their api calls, so they need to upload a csv to the server for me to parse and check)

To do this, I aim to use plumber and a POST request. My knowledge is a bit limited on how to structure the api to do this. Below is a rough example of how I see it happening. Is this even possible to do with plumber?

# api_main.R

library(plumber)

#* @awesomeAPI Simple API to upload csv

#* Return status on received csv
#* @param req
#* @post /upload
function(req) 
 df <- read.csv(req$body)
 if(all(c("A", "B", "C", "D") %in% names(df)))
 return(data.frame(msg = "Not all columns available", status = 418))
 else 
 # upload data to DB here
 return(data.frame(msg = "OK", status = 200))
 

Start the service:

plumber::plumb("api_main.R")$run(port = 5762)

r plumber

share|improve this question

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Should work with req$postBody c.f. stackoverflow.com/a/51945300/8416610
  
  – Ralf Stubner
  Mar 26 at 12:56
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You probably need to convert req$postBody from json format to normal.
  
  – Rushabh
  Mar 26 at 14:08
  

  
  
  
  

add a comment | 

0

I am looking to send a csv file to a database as someone posts the file using their VBA code (VBA has a 80 character limit for their api calls, so they need to upload a csv to the server for me to parse and check)

To do this, I aim to use plumber and a POST request. My knowledge is a bit limited on how to structure the api to do this. Below is a rough example of how I see it happening. Is this even possible to do with plumber?

# api_main.R

library(plumber)

#* @awesomeAPI Simple API to upload csv

#* Return status on received csv
#* @param req
#* @post /upload
function(req) 
 df <- read.csv(req$body)
 if(all(c("A", "B", "C", "D") %in% names(df)))
 return(data.frame(msg = "Not all columns available", status = 418))
 else 
 # upload data to DB here
 return(data.frame(msg = "OK", status = 200))
 

Start the service:

plumber::plumb("api_main.R")$run(port = 5762)

r plumber

share|improve this question

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Should work with req$postBody c.f. stackoverflow.com/a/51945300/8416610
  
  – Ralf Stubner
  Mar 26 at 12:56
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You probably need to convert req$postBody from json format to normal.
  
  – Rushabh
  Mar 26 at 14:08
  

  
  
  
  

add a comment | 

I am looking to send a csv file to a database as someone posts the file using their VBA code (VBA has a 80 character limit for their api calls, so they need to upload a csv to the server for me to parse and check)

To do this, I aim to use plumber and a POST request. My knowledge is a bit limited on how to structure the api to do this. Below is a rough example of how I see it happening. Is this even possible to do with plumber?

# api_main.R

library(plumber)

#* @awesomeAPI Simple API to upload csv

#* Return status on received csv
#* @param req
#* @post /upload
function(req) 
 df <- read.csv(req$body)
 if(all(c("A", "B", "C", "D") %in% names(df)))
 return(data.frame(msg = "Not all columns available", status = 418))
 else 
 # upload data to DB here
 return(data.frame(msg = "OK", status = 200))
 

Start the service:

plumber::plumb("api_main.R")$run(port = 5762)

r plumber

share|improve this question

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

# api_main.R

library(plumber)

#* @awesomeAPI Simple API to upload csv

#* Return status on received csv
#* @param req
#* @post /upload
function(req) 
 df <- read.csv(req$body)
 if(all(c("A", "B", "C", "D") %in% names(df)))
 return(data.frame(msg = "Not all columns available", status = 418))
 else 
 # upload data to DB here
 return(data.frame(msg = "OK", status = 200))
 

plumber::plumb("api_main.R")$run(port = 5762)

share|improve this question

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

share|improve this question

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges

asked Mar 26 at 9:14

Hanjo Jo'burg OdendaalHanjo Jo'burg Odendaal

81311 gold badge77 silver badges2323 bronze badges