How can I import JSON data from a REST API into BIRT?

I am trying to design a report that gets JSON data from a RESTful resource. Is it possible with a scripted datasource?
 
Thanks

Find more posts tagged with

Comments

pricher

Hi,
 
Maybe this <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php/blog/45/entry-471-use-json-as-a-scripted-data-set/'>devshare </a>will help.
 
P.

micajblock

and this blog - <a data-ipb='nomediaparse' href='http://blogs.opentext.com/use-json-as-a-scripted-data-set/'>http://blogs.opentext.com/use-json-as-a-scripted-data-set/</a>

Jhonatan Alarcon

Hi pricher!
It's possible to call this Rest service <a data-ipb='nomediaparse' href='http://localhost:8000/myapp/webresources/myservice'>http://localhost:8000/myapp/webresources/myservice</a>from a scripted datasource?
Thanks

Clement Wong

Yes, it's possible to call any REST data source via a Scripted Data Source / Data Set. Here is another example in the DevShare:
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1128-querying-elasticsearch-with-birt-using-a-scripted-data-set/'>http://developer.actuate.com/community/forum/index.php?/files/file/1128-querying-elasticsearch-with-birt-using-a-scripted-data-set/</a>
 
Also, as part of the OpenText Analytics Release 16, the commercial BIRT now includes a REST API data source. The screenshots show the user interface of this new out of the box ODA.