Forum Discussion
Standard output as data source?
Is there a way to run an executable, receive its standard output and use it as a data source?
Following Greg_Deckler advice here is an R based solution.
let
dummyInput = #table(null,{{1}}),
RScript = R.Execute("output <- dataset#(lf)output$system <- system2(""whoami"", stdout=TRUE)",[dataset=dummyInput ]),
output = RScript{[Name="output"]}[Value]
in
output
Nice. Have you tried that in conjunction with an on-premises gateway? Just curious if it would work. Obviously, the cloud gateway is not going to support any random executable but would be interesting if the on-premises gateways did.