help with R and mongo_db connection

gianpaolo

hello community

i'm trying to connect on MongoDb through R interface by JSL script

i need to pass this strings

Names Default To Here( 1 );

RConnection = R Connect();

rc = RConnection << Submit("

library(mongolite)

m <- mongo(collection = "Param", db = "DbParam", url = "mongodb://ailyxxxx01a:27017/DbParam")

d <- m$find('{"\"FLDLOT" : "\""xxxxxx.000\""}')

;

but i got sintax errors 

how i can pass red strings correcty into code?

 

 

 

thanks in advance

Gianpaolo

gianpaolo

I solved it by myself:

the issue was related to sintax error introduced by "  into R code

need to use escape characters because  to substitute  " with  \!"   

R Init( );　

R Submit( " 

library(mongolite)

m <- mongo(collection = \!"ColParamLot\!", db = \!"DbaLfoundryParam\!", url = \!"mongodb://ailymsmdb01a:27017/DbaLfoundryParam\!")

d <- m$find('{\!"FLDLOT\!" : \!"8588679.009\!"}')

");

R Term();