Monday Minutes: JSON Reports

by Jessie Zairo on Apr 21, 2025

In this week's Monday Minutes, Nick and Jessie show off how to use JSON with Koha's report.

Koha implements a JSON reports service for every report saved using the Guided Reports wizard or Report from SQL features.

By default, reports will be non-public and only accessible by authenticated users. If a report is explicitly set to public, it will be accessible without anyone's authentication.

This feature should only be used when the data can be shared safely not containing any patron information.

Reports Module

Creating a report and setting it as a public report.

• Navigate to the Reports Module
• Click the link to ‘Create from SQL’
• Add the report name and group
• Report is public: By changing to yes, staff can create a public report that can be accessed using the JSON reports services by anyone and without authentication.
• Add SQL
• Click Save Report

Once a report is saved, you do not have to recreate it, it will appear on the ‘Saved reports’ page with all other saved reports. There, you will see a JSON URL column that links directly to the JSON output

Transparency Through Public Reports

Here is a video highlight what the JSON and Koha reports can accomplish. The Terrific Every-Other-Thursday Training Videos are hosted by koha-US and George Williams and Christopher Brannon.

Additional Resources

JSON Reports - Koha Community Manual