I need to parse the below json with jquery and display in a html table.
display the values of "key" and "doc_count" in a html table.
Help is appreciated. see json below:
{ "key": "A", "count": 100 }, { "key": "AB", "count": 800 }
6
-
so what you tried for that ?Shailendra Sharma– Shailendra Sharma2015-11-20 10:47:52 +00:00Commented Nov 20, 2015 at 10:47
-
See datatables, that's what I use and it works perfectlyLaurence Nicolaou– Laurence Nicolaou2015-11-20 10:50:08 +00:00Commented Nov 20, 2015 at 10:50
-
.aggregations.2.buckets not working?user3570620– user35706202015-11-20 10:52:49 +00:00Commented Nov 20, 2015 at 10:52
-
dynatable.comonline Thomas– online Thomas2015-11-20 10:54:09 +00:00Commented Nov 20, 2015 at 10:54
-
any idea how to do this with jquery?user3570620– user35706202015-11-20 11:07:09 +00:00Commented Nov 20, 2015 at 11:07
|
Show 1 more comment
1 Answer
Try This code:
Use any Template Engine(Handlebars or Underscore) to process HTML. I am assuming data is in the form of Static Json.
Make a table and append to HTML page:
var Table=$("<table class='json_data'>");
$('body').append(Table);
Then iterate whole Json to get the desired value.Like this:
$.each(parse_json.aggregations[2].buckets,function(index,value){
$('.json_data').append("<tr><td>"+value.key+"</td><td>"+value.doc_count+"</td></tr>");
})
JSFiddle Link: https://jsfiddle.net/Dee0565/17u4xs3s/
