json object to html table conversion using json2html

Question

I am having a problem when using json2html https://github.com/eisenbraun/columns library . Is it possible to use this js library with Json object as below.

var jsonobj = [{
  "id": "31",
  "Mesial": {
    "disorder": "",
    "other": ""
  },
  "Facial": {
    "disorder": "DC-HP",
    "other": ""
  },
  "Distal": {
    "disorder": "",
    "other": ""
  },
  "Lingual": {
    "disorder": "",
    "other": ""
  },
  "Occlusal": {
    "disorder": "",
    "other": ""
  }
}, {
  "id": "37",
  "Mesial": {
    "disorder": "",
    "other": ""
  },
  "Facial": {
    "disorder": "RE-AR",
    "other": ""
  },
  "Distal": {
    "disorder": "",
    "other": ""
  },
  "Lingual": {
    "disorder": "",
    "other": ""
  },
  "Occlusal": {
    "disorder": "",
    "other": ""
  }
}]

I have used online tool Convert JSON to HTML Table, but unfortunately it's library is not available.

expected table output is

snap

You will need to flatten that array to match what you want shown in each column. It's not clear what expected table should look like. You can use Array#map() to map it to the needed structure — charlietfl
– charlietfl, Commented Nov 8, 2018 at 10:43
Please update the code you tried. Please check this for documentation michaeleisenbraun.com/columns — localroot
– localroot, Commented Nov 8, 2018 at 10:43
If you read the documentation you can see that the array needs to contain objects which define the columns, not further properties and subobjects: michaeleisenbraun.com/columns — Rory McCrossan
– Rory McCrossan, Commented Nov 8, 2018 at 10:43
Will try to implement a method to flatten the json object. so it may work — Arjuna Bandara
– Arjuna Bandara, Commented Nov 8, 2018 at 13:39

Alexandre Elshobokshy · Accepted Answer · 2018-11-08 10:42:40Z

2

No, your data format is incorrect.

Your format need to respect their data format of :

[{"col1":"row1", "col2":"row1", "col3":"row1"}, {"col1":"row2", "col2":"row2", "col3":"row2"}]

Having for each object a colX:rowY format.

So you can't have an object as a row entry.

answered Nov 8, 2018 at 10:42

Alexandre Elshobokshy

11k6 gold badges35 silver badges61 bronze badges

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

2 Comments

Arjuna Bandara Over a year ago

any suggestion to convert above json to flatten json?

Alexandre Elshobokshy Over a year ago

@ArjunaBandara it depends on which values you want to keep in your actual json before converting it, but that's another question :)

Collectives™ on Stack Overflow

json object to html table conversion using json2html

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related