cannot convert Json string to JSONObject or JSONArray

Question

i have created a rest wcf web service and hosted in local iis, the json string is converted with JsonConvert.SerializeObject(object) of Newtonsoft package.

the output of the web service is

"[{\"companyId\":2,\"companyName\":\"A\"},
{\"companyId\":8,\"companyName\":\"B\"}]"

this web service is consume by android apps, i tried with JSONArray and JSONObject but it keep on throwing exception

org.json.JSONException: Expected literal value at character 2 of   
[{\"companyId\":2,\"companyName\":\"A\"},{\"companyId\":8,\"companyName\":\"B\"}]
org.json.JSONException: Expected literal value at character 2 of 
"[{\"companyId\":2,\"companyName\":\"A\"},    
{\"companyId\":8,\"companyName\":\"B\"}]"
org.json.JSONException: Value [{"companyId":2,"companyName":"A"},
{"companyId":8,"companyName":"B"}] of type java.lang.String cannot be 
converted to JSONArray

this is the code in android class

public JSONArray RequestWebService(URL urlToRequest) {
urlConnection = (HttpURLConnection) urlToRequest.openConnection();
        urlConnection.setConnectTimeout(CONNECTION_TIMEOUT);
        urlConnection.setReadTimeout(RETRIEVE_TIMEOUT);
        urlConnection.setRequestMethod("GET");
        urlConnection.connect();

int statusCode = urlConnection.getResponseCode();

        if (statusCode == HttpURLConnection.HTTP_OK) {
            InputStream in = new BufferedInputStream(
                    urlConnection.getInputStream());
            String result = getResponseText(in);
            //result = result.substring(1, result.length() - 1);
            //result = result.replace("/\\/g", "");
            JSONArray j = new JSONArray(result);
            return j
        }
    return null;
}

private String getResponseText(InputStream inStream) throws IOException {
    StringBuilder sb = new StringBuilder();
    BufferedReader rd = null;
    try{
        rd = new BufferedReader(new InputStreamReader(inStream));
        String line;
        while ((line = rd.readLine()) != null) {
            sb.append(line);
        }
    }finally {
        if (rd != null) {
            rd.close();
        }
    }

    return sb.toString();
}

Share your code how you tried to consume this json and show us the error message. — croxy, Jan 28 '16 at 08:27
All those backslashes: are they an artifact of your development environment (e.g. the Visual Studio debugger displays it like this) or are they really part of the transmitted data? If the latter is the case, then that's the problem. — Codo, Jan 28 '16 at 08:34
It seems that you have a double encoding: first you encode the data as JSON and then its encoded again somehow where the backslashes are inserted. Remove that second encoding, i.e. prevent the backslashes from being generated in the first place. — Codo, Jan 28 '16 at 08:35
try use ``sb.append(line + "\n");`` instead of ``sb.append(line);`` , it will make you json string clearly. — Danh DC, Jan 28 '16 at 08:38
I have converted your json String after some modification, its working here is json String : [ { "companyId": 2, "companyName": "A" }, { "companyId": 8, "companyName": "B" } ] — Sandeep Tiwari, Jan 28 '16 at 08:39
i tried to valid the json, some json web site is valid, and then i found that for RFC 7159 standard it is valid — Yu Yenkan, Jan 28 '16 at 08:42

Vishal Patoliya ツ · Answer 1 · 2016-01-28T08:50:38.693

0

String response = "Your Response";
try{    
    JsonArray jAry = new JsonArray(response);
        JsonObjct jObj;

        for(int i=0;i<jAry.length;i++){
            jObj = JAry.getJsonObject(i);

  // You can get your string from object jobj and also use it by store it value in arraylist.
        }
  } catch(Exception e){

}

edited Jan 28 '16 at 08:50

answered Jan 28 '16 at 08:37

Vishal Patoliya ツ

3,170
4
24
45

when i put my response in JSONArray, it throw an exception – Yu Yenkan Jan 28 '16 at 08:39
Please use try-catch block when you parse json array. – Vishal Patoliya ツ Jan 28 '16 at 08:49
ya, then the string will be null – Yu Yenkan Jan 28 '16 at 08:51
If you want to get "companyId than simply you can get by jsonobj i.e jObj.optString("companyId "); – Vishal Patoliya ツ Jan 28 '16 at 08:55
you don get what i mean lol, i cant even parse my response to jsonarray now. – Yu Yenkan Jan 28 '16 at 09:07
put here your response which you get in string. – Vishal Patoliya ツ Jan 28 '16 at 09:08
"[{\"companyId\":2,\"companyName\":\"A\"}, {\"companyId\":8,\"companyName\":\"B\"}]" – Yu Yenkan Jan 28 '16 at 09:12
1

Remove \ symbol before you convert it from your webservice response – Vishal Patoliya ツ Jan 28 '16 at 09:17

cannot convert Json string to JSONObject or JSONArray

1 Answers1