Android Question Parsing JSON string created with DBUtils.ExecuteJSON

[sivakrith]

Hello,
Created a JSON using DBUtils.ExecuteJSON by passing required parameters and then converted it into a string using toString method. Works fine. Verified that it's a valid JSON.

Now I want to parse this JSON and extract individual values. This generated JSON starts with root and I couldn't find a way to parse this string. The (sample) string that I get looks like this:
{"root":[{"field1":"M","field2":"1234567890","field3":1611920526063,"field4":"789","field5":"#Î@Í%Ì"}, "field1":"O","field2":"123","field3":1611930204138,"field4":"ed6bef4700dc7a4d1448a1ce862cef54","field5":"#Î@Í%Ì"}]}

Any code snippet to parse this string is really appreciated.

Happiness Always
BKR Sivaprakash

 

[Gabino A. de la Gala]

I think the json must be :

{"root":[{"field1":"M","field2":"1234567890","field3":1611920526063,"field4":"789","field5":"#Î@Í%Ì"}, {"field1":"O","field2":"123","field3":1611930204138,"field4":"ed6bef4700dc7a4d1448a1ce862cef54","field5":"#Î@Í%Ì"}]}

Try it here : http://basic4ppc.com:51042/json/index.html

 

[sivakrith]

Super.. Thanks Gabino.

http://basic4ppc.com:51042/json/index.html
Who did this excellent work ? Kudos to him.

Thanks.

 

[Gabino A. de la Gala]

Super.. Thanks Gabino.

http://basic4ppc.com:51042/json/index.html
Who did this excellent work ? Kudos to him.

Thanks.

@Erel

Erel

www.b4x.com

JsonTree - Tool to help with JSON parsing (B4A / B4J)

JsonTree is a tool that helps developers to parse and understand JSON strings. It shows the data structure in a TreeView and it also prints the code (B4J / B4A) required in order to extract the data from the string. Note that variables in the generated code are based on the JSON fields. It may...

www.b4x.com