Android Question Multiple resultset handling with HttpUtils

[Felix Maria]

Hi,

I have a stored procedure that returns about 3 set of results. It is serialised and send back with the use of web services.
The following is the sample of the json string

(ArrayList) [{Value=[{REST_NAME=Lounge, TBLNAM=RESCOD, CODE=001}], Key=RESCOD},
{Value=[{SESSION_NAME=General, TBLNAM=SESSON, FROM_TIME=0.00}], Key=SESSON},
{Value=[{DESCRP=General, TBLNAM=RATSLB, RATSLB=1},
{DESCRP=Happy Hours, TBLNAM=RATSLB, RATSLB=2}], Key=RATSLB}]

The above data contains 3 arrays of values.
I need to split this string data and store it in to the respective global arrays in the program.
How do I do It?

I tried doing it the following way...But it throws and null exception error....

response = HttpUtils.GetString(SPURL)
parser.Initialize(response)
rows = parser.NextArray
Do While rows.Size <> 0
Dim Tbl As Map
Tbl = rows.Get(0)
Select Case Tbl.Get("TBLNAM")
Case "RESCOD"
GnResArray.Initialize
Case "SESSON"
GnResArray.Initialize
Case "RATSLB"
GnResArray.Initialize
End Select

Please guide me on the usage of nested json parsing. When I tried to use the NextObject.....it again gave me an error...

Thank You.

 

[Felix Maria]

Hi,

Can somebody guide me on the above post? I am helpless in getting the multiple resultset returned by the stored procedure..
Thank You!

 

[Erel]

0. Please use [ code ] [ /code ] tags (without spaces) when posting code.

1. You should use HttpUtils2 instead of HttpUtils.

2. You need to do something like:

For Each m1 As Map in Rows
 Dim value As List = m1.Get("Value")
 Dim m2 As Map = value.Get(0)
 Log(m2)
Next