SpagoBI 5.2 REST DataSets with JSON Data

Introduction SpagoBI 5.2 introduces a new dataset type :  RESTful web service datasets . This allows SpagoBI to report on data from sources other than databases with JDBC drivers. What follows is an end-to-end demonstration of creating and using a REST (JSON) Dataset in SpagoBI 5.2. External documentation Description URL SpagoBI 5.2  NGSI usage of REST Data Sets https://spagobi.readthedocs.io/en/latest/user/NGSI/README/index.html SpagoBI 5.2 Documentation https://spagobi.readthedocs.io/en/latest/index.html SpagoBI 5.2 Release Notes https://wiki.spagobi.org/xwiki/bin/view/spagobi_server/release_notes_5_2 JSON Path https://github.com/jayway/JsonPath Limitations in REST Data Sets The response of the REST service must

Read more

SpagoBI DataSet REST Webservice via Groovy

SpagoBI DataSet REST Webservice via Groovy UPDATE: THIS IS A GREAT IDEA, EXCEPT IT DOESN’T WORK IN THE FINAL STEP.  Per SpagoBI Support, Groovy cannot be used in a script-based Dataset to provide rows of data. According to the last support ticket, there is no intent to make that work. Groovy Data Set to make RESTful web service call and return IP Address related information in SpagoBI’s XML format Prerequisites : Upgrade Groovy in SpagoBI and Drop in a copy of the WSLite library

Read more