convert json string to json array - android java

Question

first of all, I've read a ton of similar questions on this site and none has solved my problem so
I have this json file that I create using php :

{
"done":true,
"data":"[
{\"id\":\"5099\",\"user_id\":\"892\"},
{\"id\":\"5100\",\"user_id\":\"892\"}
....
]"}

now in java android I want to parse it but it gives me this error: JSON.TypeMismatch
this is my android code to parse the json file:

//class from which I get the json in a JSONObject - works fine so far
JSONObject httpResult = itemHttpRequest.get("/fetch?currentList=&sort=recent&extra=");
        try {
            JSONArray httpData = httpResult.getJSONArray("data");
        } catch (JSONException e) {
            e.printStackTrace();
        }

but it keeps giving me error.
is it because the data array in my json file is surrounded by quotes?
please help

wintenbb · Accepted Answer · 2014-12-18 08:59:53Z

4

For sure, data is a String (character surrounded by quotes), it can't be read as a JSONArray.

If you can't make your php to generate a JSON array, what you can do on Android size, is to get the data string with :

String data = httpResult.getString("data");

then you can create a JSONARRAY with :

JSONArray constructor

JSONArray dataArray = new JSONArray(data)

edited Dec 18, 2014 at 8:59

answered Dec 18, 2014 at 8:54

wintenbb

4,1663 gold badges32 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohsen Shakiba Over a year ago

you sir are a life savor, I wish I could kiss you or something :*

Suvitruf - Andrei Apanasik · Accepted Answer · 2014-12-18 08:54:57Z

2

"data":"[
{\"id\":\"5099\",\"user_id\":\"892\"},
{\"id\":\"5100\",\"user_id\":\"892\"}
....
]"

is a string

But

"data":[
{"id":"5099","user_id":"892"},
{"id":"5100","user_id":"892"}
....
]

is array

answered Dec 18, 2014 at 8:54

Suvitruf - Andrei Apanasik

5,7029 gold badges53 silver badges91 bronze badges

1 Comment

Suvitruf - Andrei Apanasik Over a year ago

@user3425760 where are you from take this json?

sol4me · Accepted Answer · 2014-12-18 08:56:14Z

2

You are supplying invalid JSON. You need to correct your JSON by removing extra quotes. You can always use some validator to spot these types of problem E.g.

{
    "done": true,
    "data": [
        {
            "id": "5099",
            "user_id": "892"
        },
        {
            "id": "5100",
            "user_id": "892"
        }
    ]
}

answered Dec 18, 2014 at 8:56

sol4me

15.8k6 gold badges37 silver badges35 bronze badges

1 Comment

wintenbb Over a year ago

yes, i deleted my comment, but the invalid JSON can also comes from \n in the data String

Jotiram Chavan · Accepted Answer · 2014-12-18 12:25:33Z

Use this to convert JSON array to string

private String convertStreamToString(InputStream is) {
        /*
         * To convert the InputStream to String we use the
         * BufferedReader.readLine() method. We iterate until the
         * BufferedReader return null which means there's no more data to
         * read. Each line will appended to a StringBuilder and returned as
         * String.
         */
        BufferedReader reader = new BufferedReader(
                new InputStreamReader(is));
        StringBuilder sb = new StringBuilder();

        String line = null;
        try {
            while ((line = reader.readLine()) != null) {
                sb.append(line + "\n");
            }
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                is.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return sb.toString();
    }

ayesh don · Accepted Answer · 2014-12-18 09:32:06Z

0

Try with this

  JsonArray array = new  JsonArray(value)

value :- Should have proper jsonarray format. otherwise it will throw a JsonException

answered Dec 18, 2014 at 9:32

ayesh don

1,1611 gold badge16 silver badges26 bronze badges

Collectives™ on Stack Overflow

convert json string to json array - android java

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related