Better yet, is there a way to call a jQuery function after the json call, but before the grid renders the data so that I can convert the json to the proper format expected by jqGrid???

See docs.

 

Your json have two data tags, which is a little bit confused. Correct this and maybe you will get the data rigth.

 

Regards

{"SUCCESS":true,"ERRORS":[],"DATA":{"COLUMNS":["COL_ID","COL_NAME"],"DATA":[["B5E34D73-955D-AB23-9D0D-3BF6C4FF4505","Test Name 1"],["D9A3A435-EACE-073F-1ABC-050BD038D23C","Test Name 2"]]}}

 

So I tried this:

"jsonReader":{root:"DATA","repeatitems":false,"subgrid":{"repeatitems":false}},

"colModel":[{"name":"","index":"1","jsonmap":"data","sorttype":"text","width":80,"editable":true}],

 

I suspect that the problem is that my column names and data are separated in the json response -- how do I handle this in jqGrid?

 

OR

 

Better yet, is there a way to call a jQuery function after the json call, but before the grid renders the data so that I can convert the json to the proper format expected by jqGrid???