Jira data in Power BI

Often, project or work related data exists in Jira and there is value in reporting/visualizing it in Power BI. Perhaps the reporting capabilities within Jira are not sufficient, there is value in extracting it to use in Power BI, or there is desire to combine the data from Jira with other data sources. The are commercial Jira plugins available for Power BI, but I’m going to roll our own. For this technique, you’ll need basic understanding of JIRA, JQL, Power

Read more

JIRA API Archeology and Zombies. Guidance for perplexed developers

Samples of API JIRA Nuances and Gotchas The JIRA REST API is a great tool for synchronizing data into downstream systems but is not without Zombies, Land Minds, and other gotchas. Sources of Zombie data in downstream systems Deletes and Archives will not be communicated through the REST APIs. Moving an issue from one to another Changing the issuetype of an issue Moving the issue to another project with a different issue type Possible solutions Use webhooks and stream all

Read more

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