{"query":{"ROWCOUNT":4,"COLUMNS":["TYPEID","TYPE"],"DATA":{"TYPEID":[1,2,3,4],"TYPE":["Program Office","SDM","Non Technical","Technical"]}},"totalcount":4}
same code in xml returns which looks fine.
<?xml version="1.0" encoding="UTF-8"?>
<struct>
<query>
<query rowCount="4" fieldNames="type,typeID">
<row>
<type>Program Office</type>
<typeid>1</typeid>
</row>
<row>
<type>SDM</type>
<typeid>2</typeid>
</row>
<row>
<type>Non Technical</type>
<typeid>3</typeid>
</row>
<row>
<type>Technical</type>
<typeid>4</typeid>
</row>
</query>
</query>
<totalcount>4</totalcount>
</struct>
Just not sure what is the problem that json is not returning 4 rows.
Any help would be appreciated.