The following: json_object ( 'data', json_group_array( json_object( 'type', type, 'id', notebook_id, 'attributes', json_object( 'book', book, 'total_notes', total_notes ), ...etc
results in: {"data":"[{\"type\":\"notebook\",\"id\":2,\"attributes\":{\"book\":\"brew\",\... etc the array is a string? besides manually constructing with: || json_quotes('data') || ":[" || group_concat( json_object( ) ) how should it be done properly in one go? TIA, ingo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users