how to get json data in to a table

Question

{  
   "status":"POST",
   "extrabed_cost":600,
   "grand_total":"24982.86",
   "total_tax":"3988.86"
}

Add this json datas in to table

Loop through the data and create your table while doing it. – Damien Oct 23 '17 at 15:28 — Damien, Oct 23 '17 at 15:28

score 1 · Accepted Answer · answered Oct 24 '17 at 02:05

If I understood your purpose correctly, this fiddle can help you.

Create table dynamically

var objFromHttp = {
    "extrabed_cost": 600,
    "grand_total": "24982.86",
    "price_breakup": {
        "2017 - 10 - 23": 2599,
        "2017 - 10 - 25": 2599,
        "2017 - 10 - 24": 2599,
        "2017 - 10 - 27": 2599,
        "2017 - 10 - 26": 2599
    },
    "room_cost": 2299,
    "status": "POST",
    "tax_percent": 19,
    "total": 20994,
    "total_days": 8,
    "total_tax": "3988.86"
};

It's difficult to validate your json, so I cooked your json a little.

Is this what you want??

score 0 · Answer 2 · answered Oct 23 '17 at 15:42

This json is not a well formatted one. Beside this, if you are using java, you can deserialize it in an object, use a transformer to transfer it to an object(or more objects) that maps (use hibernate) to your database.

how to get json data in to a table

2 Answers2