JSON to table - all variables

[wildjack]

Hello,

Is there a way to get a table with all JSON variables without creating the table with variables one by one ?

Like http://json2table.com/

Thanks

 

[nicanil]

You can use Data=>Processing JSON\XML action for this. First parse json string, then put data to table:

Спойлер

In example above I used this JSON:

[
  {
    "name": "Ram",
    "email": "[email protected]",
    "age": 23
  },
  {
    "name": "Shyam",
    "email": "[email protected]",
    "age": 28
  },
  {
    "name": "John",
    "email": "[email protected]",
    "age": 33
  },
  {
    "name": "Bob",
    "email": "[email protected]",
    "age": 41
  }
]

 

[wildjack]

thanks, that's what i use, but would like to know if the table can be create with all variables automatically

 

[nicanil]

You cannot do this using standard actions

 

[wildjack]

ok thanks a lot