Execute R Script from C# for Core .NET GET API

Question

We are trying to execute an R script from C# for .NET core GET API in visual studio and are not able to return any status from R script (as execution status). Below is what we have tried. Versions - .NET Core 3.1, R 4.2

C# Code:

[HttpGet]
public IActionResult RunRScript()
{
    try
    {
        var rpath = @"C:\Users\AppData\Local\Programs\R\R-4.2.0\bin\Rscript.exe";
        string FilePath = Directory.GetCurrentDirectory() 
            + "\\RScripts\\Sample.R";
        var output = RFromCmd(rpath, FilePath, "");
        return Ok(output);
    }
    catch (Exception e)
    {
        return BadRequest(e.Message.ToString());
    }
}
public static string RFromCmd(string rScriptExecutablePath,
     string rCodeFilePath, string args)
{
    string result = string.Empty;
    try
    {
        var info = new ProcessStartInfo();
        info.FileName = rScriptExecutablePath;
        info.WorkingDirectory = Path.GetDirectoryName(rScriptExecutablePath);
        info.Arguments = rCodeFilePath;



        info.RedirectStandardInput = false;
        info.RedirectStandardOutput = true;
        info.UseShellExecute = false;
        info.CreateNoWindow = true;



        using (var proc = new Process())
        {
            proc.StartInfo = info;
            proc.Start();
        }
    }
}

Sample.R

getwd()
#Dummy data
sample <- data.frame(Date = seq(as.Date("2000/1/1"), by = "month",
length.out = 200), Volume = rnorm(200))

summary(sample)
#To save the Data in csv format
write.csv(sample, "Sample_data.csv")
View(summary(sample))

#Trying to include return statement
end_of_script <- function() {
  x = 1 #also tried string "complete"
  return(x)
}
end_of_script()

Please let me know what we are missing or doing wrong. The R script is a test script, based on the success of this we will be running different R Scripts using this method.

saicharan kr · Accepted Answer · 2022-05-09 06:46:33Z

1

Instead of running it like this you can build the restapi with one endpoint using R ,and can call the endpoint in c#

Reference for building APIs in r . https://www.google.com/amp/s/www.geeksforgeeks.org/building-rest-api-using-r-programming/amp/

answered May 9, 2022 at 6:46

saicharan kr

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Execute R Script from C# for Core .NET GET API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related