Hi there,

Usually I'm using JDBC for my reports, now I have to use the scriptable datasources. Can someone help me to get a better understanding of how to do this?

I'd like to use a Scriptable-Datasource to access a REST-Service I've created (which generates Random Data in JSON-Fromat).

[{"date1":7218658108310136372,
"date2":-223898262147215167,
"integer1":629359313,
"integer2":173945722,
"bigDecimal1":1675396003.42,
"bigDecimal2":292767199.42,
"largeString":"guf29S8PBZjaJpgR9hs3uibAGardLWvq27y0t4ahZX9Sr2RWy4CJffDzR52LACsuLhdkF6S044USYz0OL8GVg8cZoJVoFtbyqoHR",
"string1":"A78ppFyXZ8",
"string2":"MWAEOCCOhc",},
{"date1":-4334458495930330729,
"date2":-3725522510203197817,
"integer1":241914275,
"integer2":1215176614,
"bigDecimal1":682883173.42,
"bigDecimal2":382566866.42,
"largeString":"6JlKDuPNWp8X046ENwItogP8SKbljyK5g4RDxt5Tcif7VVLU51P68xzSaAktbtevzC6t8o29ACSwfO6Un1tApR91n3vp2sE7BAXG",
"string1":"VN3pOjkJna",
"string2":"VJdx4Q7QbJ",
}]

and so on...

I'd like to use the url I have for my server to get this data in the required format (http://localhost:8080/api/random?count=2).

Can someone please recommend me how to do this? Should I better use beanshell, groovy or javascript? Which is workling better for pentaho and how should I proceed to get results?

Thanks a lot in advance!

Regards

Jen