Thanks for your feedback, appreciate it. I will explore the SPL script option.

Hi Jerry,

This is the problem I am trying to solve:

I have used Birt for years to create reports with different data sources (SQL Server, text files, etc)
I have the need of creating Birt reports to access data in one of our systems using Rest APIs , and the datasets are returned in JSON format.

I have never used Birt with Rest APIs, and after searching internet for quite a while I found the approach of using scripted data sources. And then I found the RaqForum where you and Andy gave posted some examples.

Initially I am trying to create a simple test report using a scripted data source. I have not tried to use esProc SPL script yet. I plan to later. By the way, I didn’t know about the esProc SPL scripts.

But even with the simple report with the scripted data source I am getting the error “JSON not defined”. I have tried different options putting the json jar files in the scriptlib folder in my local Birt 4.8 installation. Still the same error.

Please advise.
Do you have have any sample Birt report using REST APIs that you can share ?

Thanks for getting back to me. Much appreciated.

Regards,

Jorge