Dynamic json or xml data sources
-
I'm looking for an alternative to a hugely cumbersome BI tool that requires considerable hardware resource and technical management, which has been imposed upon my team. What we actually need is a relatively lightweight reporting tool with flexible graphic representations that can do everything from heavily text based listings to presenting live dashboards with drill-able subsets. jsreport looks like a likely candidate but before downloading, experimenting and going into battle with management, I would like to establish one thing.
Our data is accessed through a series of API endpoints, which can be formatted as xml or json. The output is dynamic depending on the user requesting it and the permissions applied in the main applications. My question here is how easy is it to consume this kind of endpoint and where do I look for examples if similar techniques are already handled?
(I have developer experience but am a little ring rusty. I will be happy to download and test once I know I am not heading down a dead end street, so I will be grateful for pointers to save me time getting started before handing over to the dev team.)
Many thanks
Neill
-
What we actually need is a relatively lightweight reporting tool with flexible graphic representations that can do everything from heavily text based listings to presenting live dashboards with drill-able subsets.
jsreport shines primarily in static documents generation. Pdf, excel, docx... It can produce also live dashboards with drill-down capabilities, however that is just about html/js capabilities of the developer. jsreport doesn't provide any extra feature for this use cases.
See the example for live dashboard here
https://playground.jsreport.net/w/admin/tW8CsfTtShowcases for the static documents generation can be found here
https://jsreport.net/showcases/Our data is accessed through a series of API endpoints, which can be formatted as xml or json.
jsreport can programmatically fetch any endpoint using a custom script which runs before the report generation.
https://jsreport.net/learn/scripts
-
Excellent, that is the pointer I needed.
Thank you Jan, I will download and start experimenting.
