[Koha] Help with JSON and public reports

[Chris Cormack]

* Karam Qubsi (karamqubsi at gmail.com) wrote:
> Hi ,

Hi Karam

> First I'm very new with JSON . I'd like to ask :
> as I understood from JSON documentation that the output data in JSON format
> must look like something like to this :
>  [ { "Name" : "Alfreds Futterkiste", "City" : "Berlin", "Country" :
> "Germany" }, { "Name" : "Berglunds snabbköp", "City" : "Luleå", "Country" :
> "Sweden" }, { "Name" : "Centro comercial Moctezuma", "City" : "México
> D.F.", "Country" : "Mexico" }, { "Name" : "Ernst Handel", "City" : "Graz",
> "Country" : "Austria" } ]
> 
> but in Koha the output for Public reports  is like this :
> 
> [["23-12-2014","maisara","6"],["23-12-2014","nadia","10"],["22-12-2014","hakkar","17"],["22-12-2014","nadia","3"],["22-12-2014","abdramaneg","21"]]
> 
> the field names is not in the output , and I realized ( & maybe I'm
> wrong) that to handle JSON text you must have id for each field ) to
> handle it with your script .

That isn't true, what is above is an array of arrays, represented in
JSON, you can hndle that just fine in whatever you have that is
consuming the JSON 

> 
> so is this a correct output from Koha ? and can be handled in some
> advanced methods with JSON ?
> 
> or do I have to write my SQL report in a way to CONCAT the field name
> with the field data in every data cell ?
> 

If you want the data instead as an array of hashes (in perl speak)
like your first example of JSON is describing all you need to do is add

&annotated=1 

To the url, (at least in 3.16.0 or older)

Chris


> thanks :) .
> 
> -- 
> 
> *Karam Qubsi <https://www.linkedin.com/in/kqubsi>*
> 
> *Shah Alam , Malaysia . *
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand