* Karam Qubsi (karamqu...@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@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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
