Hi everyone - we are trying to load a json export of some particular records and want to use the Datatables jquery plugin. The problem we are running into is what seems to be a strange format of the json as compared to other json files we have worked with. I have pasted a sample below of 2 records - 

{

"response" : -{

"result" : -{

"CustomModule1" : -{

"row" : -[

-{

"no" : 1,

"FL" : -[

-{

"val" : CUSTOMMODULE1_ID,

"content" : 2300685000000121073

},

-{

"val" : ResortName,

"content" : Mayan Palace Acapulco

},

-{

"val" : Price,

"content" : 399

},

-{

"val" : City,

"content" : Acapulco

},

-{

"val" : State,

"content" : MX

},

-{

"val" : Unit Size,

"content" : Studio

},

-{

"val" : Sleeps,

"content" : 2

}

]

},

and so on........

What I would like is to either convert the json file to somewhat of a more standard json like this - any tips out there or has someone tried something similar? We are not totally set on datatables to show our html table, but do like the ability to sort the data in the table:

{

"response" : -{

"result" : -{

"CustomModule1" : -{

"row" : -[

{

"CUSTOMMODULE1_ID":"2300685000000121073"

},

{

"ResortName":"Acapulco Place"

},

{

"Price":"399"

},

{

"City":"Acapulco"

},

{

"State":"MX"

},

{

"Unit Size":"Studio"

},

{

"Sleeps":"2"

Thanks!