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/tW8CsfTt

    Showcases 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.


Log in to reply
 

Looks like your connection to jsreport forum was lost, please wait while we try to reconnect.