I created a simple test solution and tried using "SendEvent" to run an R Script, but that seems to open R to run it in the foreground. Not what I want.
What I want to do instead is "capture" the result and have the R function run in the background, invisibly, if possible.
For example, if I run the simplest R script (R < Hello.R),
Now, how do I get FileMaker to execute that command without R coming up in the foreground? If I can get that working, then importing the data with the data file commands will be easy.
I had already implemented RServe (an R TCP server) with a REST front-end previously (totally free), but that implementation does not work well on Windows due to Windows' inability to parallelize R processes. Client is looking for something simpler.
Thanks for your suggestion, however.