CP_JSON_formatting_issue

JSON formatting issue?

by bryiantan

HTML

<table id= "incentive" border="1">
<thead>
        <th>Rank</th>
        <th>Name</th>
        <th>March</th>
        <th>April</th>
        <th>May</th>
        <th>Highest Rank</th>
        <th>Team Volume</th>
    </thead>
  <tbody>

   </tbody>
</table>

JavaScript

var dmJSON = { "affiliate": [{ "rank": 1, "name": "Sally", "march_rank": "Gold", "april_rank": "Silver", "may_rank": "Silver", "highest_rank": "Silver", "team_volume": 12345 }, { "rank": 2, "name": "Zelda", "march_rank": "Gold", "april_rank": "Bronze", "may_rank": "Silver", "highest_rank": "Gold", "team_volume": 12345 }] };
           dmJSON = JSON.parse('[' +  JSON.stringify(dmJSON) + ']');

            $.each(dmJSON, function (i, item) {
             
                var ords = item.affiliate;
              
                 $.each(ords, function (i, f) {
                    //alert(ork.rank);

                    var tblRow = "<tr>" + "<td>" + f.rank + "</td>" + "<td>" + f.name + "</td>" + "<td>" + f.march_rank + "</td>" + "<td> " + f.april_rank + "</td>" + "<td>" + f.may_rank + "</td><td>" + f.highest_rank + "</td><td>" + f.team_volume + "</td>" + "</tr>"
                    $(tblRow).appendTo("#incentive tbody");

                });
            });