Parse nested json in jquery and display in HTML page

Question

I need to parse the below json and display in a html page.

Display COLA, COLB, COLC in a dropdownlist
display the values of type and index in a html table.

JSON

{
  "mydb1": {
    "mappings": {
      "TAB1": {
        "properties": {
          "COLA": {
            "type": "string",
            "index": "not_analyzed"
          },
          "COLB": {
            "type": "string",
            "index": "not_analyzed"
          },
          "COLC": {
            "type": "string",
            "index": "not_analyzed"
          }
        }
      }
    }
  }
}

did you try researching?

Bhojendra Rauniyar
– Bhojendra Rauniyar

2015-11-16 10:44:37 +00:00
Commented Nov 16, 2015 at 10:44 — Bhojendra Rauniyar
– Bhojendra Rauniyar, Commented Nov 16, 2015 at 10:44

Goran Stoyanov · Accepted Answer · 2020-01-09 14:55:37Z

1

Try this:

<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<div id="dropDown"></div>
<table id='tableVal' border='1'></table>
<script>
  $(document).ready(function() {
    var jsonStr = '{\
            "mydb1": {\
                "mappings": {\
                    "TAB1": {\
                        "properties": {\
                            "COLA": {\
                                "type": "string",\
                                "index": "not_analyzed"\
                            },\
                            "COLB": {\
                                "type": "string",\
                                "index": "not_analyzed"\
                            },\
                            "COLC": {\
                                "type": "string",\
                                "index": "not_analyzed"\
                            }\
                        }\
                    }\
                }\
            }\
        }';
    var jsonObj = JSON.parse(jsonStr);
    var drpDwn = '<select>',
      tabData = '';
    //console.log(jsonObj.mydb1.mappings.TAB1.properties);
    var temp = jsonObj.mydb1.mappings.TAB1.properties;
    $.each(temp, function(str, value) {
      drpDwn += '<option>' + str + '</option>';
      console.log(value.index);
      tabData += '<tr><td>' + value.type + '</td><td>' + value.index + '</td></tr>';
    });
    drpDwn += '</select>';
    $('#dropDown').html(drpDwn);
    $('#tableVal').html(tabData);
    //$.each(jsonObj.)
  });
</script>

edited Jan 9, 2020 at 14:55

Goran Stoyanov

2,3111 gold badge22 silver badges32 bronze badges

answered Nov 16, 2015 at 11:03

Sanjay Kumar N S

4,7595 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3570620 Over a year ago

Very helpful. Thanks a lot Sanjay Kumar N S

Collectives™ on Stack Overflow

Parse nested json in jquery and display in HTML page

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related