Exception in saving JSON

Question

I am trying to save the response from server but I am getting exception.. This is the response:

   [ 
    {
    "MediEazyInvoiceitemsList": [
        {
            "Id": 1,
            "MediEazyInvoiceId": 1,
            "ProductId": 1,
            "ManufacturerId": null,
            "ProductName": "Crocef (500 mg)",
            "ScheduleType": "H",
            "Quantity": 2,
            "Dosage": "1-0-1"
        },
        {
            "Id": 2,
            "MediEazyInvoiceId": 1,
            "ProductId": 1,
            "ManufacturerId": null,
            "ProductName": "Dispar (300 mg)",
            "ScheduleType": "H",
            "Quantity": 5,
            "Dosage": "1-0-1"
        }
    ],
    "Id": 1,
    "CustomerId": 5,
    "PharmacyId": 1,
    "Customer": null,
    "DeliveryAddress": "sfh, ghh",
    "CustomerLatitude": "24.9876",
    "CustomerLongitude": "72.0987",
    "OrderStatus": 0,
    "Remarks": null,
    "Comments": null,
    "Instructions": "Testing",
    "Prescription": null,
    "PrescriptionPath": ""
},
{
    "MediEazyInvoiceitemsList": [
        {
            "Id": 3,
            "MediEazyInvoiceId": 2,
            "ProductId": 1,
            "ManufacturerId": null,
            "ProductName": "Crocin (15 ml)",
            "ScheduleType": "H",
            "Quantity": 1,
            "Dosage": "1-0-1"
        },
        {
            "Id": 4,
            "MediEazyInvoiceId": 2,
            "ProductId": 1,
            "ManufacturerId": null,
            "ProductName": "Dispar (300 mg)",
            "ScheduleType": "H",
            "Quantity": 5,
            "Dosage": "1-0-1"
        }
    ],
    "Id": 2,
    "CustomerId": 5,
    "PharmacyId": 1,
    "Customer": null,
    "DeliveryAddress": "sfh, ghh",
    "CustomerLatitude": "24.9876",
    "CustomerLongitude": "72.0987",
    "OrderStatus": 0,
    "Remarks": null,
    "Comments": null,
    "Instructions": "Testing",
    "Prescription": null,
    "PrescriptionPath": ""
}]

I can't save this. What I am trying is:

String result = Utils.convertInputStreamToString(inputStream);

            //Printing server response
            System.out.println("server response is :" + result + "\n" + inputStream);


            try {
                JSONObject jsonObject=new JSONObject();
                JSONObject jo=jsonObject.getJSONObject("");
                ja=jo.getJSONArray("MediEazyInvoiceitemsList");

                // checking if server response is successful


            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();

            }

This is the error I am getting:

05-29 17:53:51.714: W/System.err(8891): org.json.JSONException: No value for MediEazyInvoiceItemsList

I am really confused with so many arrays and objects please help, thnxx

JSONObject jsonObject=new JSONObject(); should be JSONObject jsonObject=new JSONObject(myStringVariableWithJSONData); — Ungureanu Liviu, May 29 '15 at 12:27
@MD response is the HttpResponse and it says undefined for the type httpresponse — Prakhar, May 29 '15 at 12:32
First clear your question with some more details or you should go [How to ask](http://stackoverflow.com/help/how-to-ask) — M D, May 29 '15 at 12:34
Look again at the answers: you still don't pass the response from server to JSONObject's constructor (like JSONObject jsonObject=new JSONObject(result); ) — Ungureanu Liviu, May 29 '15 at 12:47

Meenal · Answer 1 · 2015-05-29T12:46:28.920

1

try this

JSONArray jsonArray=new JSONArray(result);
JSONObject jObject=jsonArray.getJSONObject(0);
JSONArray jsonResponse = jsonObject.getJSONArray("MediEazyInvoiceItemsList");

edited May 29 '15 at 12:46

answered May 29 '15 at 12:39

Meenal

2,879
5
19
43

in your code you are not passing any index and also response in JSONARRAY..is that your final code – Meenal May 29 '15 at 12:45
also..your main object is JSONArray not JSONObject – Meenal May 29 '15 at 12:45

snachmsm · Answer 2 · 2015-05-29T12:34:55.720

0

this is inproperly formated JSON, keys shouldn't be in inverted commas, like "MediEazyInvoiceitemsList"

proper JSON in your case should look smth like that:

[ //JSONArray
    { //JSONObject, first
    MediEazyInvoiceitemsList: [
        {
            Id: 1,
            MediEazyInvoiceId: 1,
            ProductId: 1,
            ManufacturerId: null,
            ProductName: "Crocef (500 mg)",
... etc.

edited May 29 '15 at 12:34

answered May 29 '15 at 12:27

snachmsm

17,866
3
32
74

score 0 · Accepted Answer · answered May 29 '15 at 12:39

Your JSON structure is one array containing two objects, each with one "MediEazyInvoiceitemsList" key. Two things go wrong: 1) you are not passing in the JSON string and 2) you are trying to retrieve the "MediEazyInvoiceItemsList" key where it is not located.

First pass in the JSON string. For example, if the server response is in a String named jsonString:

JSONArray jsonArray = new JSONArray(jsonString);

Then loop it and retrieve the objects or arrays you need. Your structure is not that complicated, but you have to make sure you correctly use JSONArray or JSONObject. For instance, to directly get the first list of items:

// Retrieve the first object.
JSONObject firstObject = jsonArray[0];

// Retrieve the property that holds the first list of items.
JSONArray firstListOfItems = firstObject.getJSONArray("MediEazyInvoiceitemsList");

score 0 · Answer 4 · answered May 29 '15 at 12:41

0

     try {
                JSONArray jsonArray=new JSONArray(response);
                JSONObject jsonObject=jsonArray.getJSONObject(0);
                JSONArray jsArry=jsonObject.getJSONArray("MediEazyInvoiceitemsList");
                ....
            } catch (JSONException e) {
                e.printStackTrace();
            }

answered May 29 '15 at 12:41

Krishna V

1,801
1
14
16

post that log, which method it is. – Krishna V May 29 '15 at 12:48

score 0 · Answer 5 · answered May 29 '15 at 12:49

[]=Json array and and {} = Json Object. You can read json object by its key like 'CustomerId' , 'Id', 'DeliveryAddress'... try this

    try {
        JSONArray responseArray = new JSONArray(yourRequestResponse);
        for (int i = 0; i < responseArray.length(); i++) {
            JSONObject object = responseArray.getJSONObject(i);
            String customerId=object.getString("CustomerId"); //product details

            //reading items details (ie array)
            JSONArray mediInvcList = object.getJSONArray("MediEazyInvoiceitemsList");
            for (int j = 0; j < mediInvcList.length(); j++) {
                JSONObject item=mediInvcList.getJSONObject(j);
                        int id=item.getInt("Id");
                        //same for others
            }
        }
    } catch (JSONException e) {
        e.printStackTrace();
    }

Suggest you to use library like GSON

Exception in saving JSON

5 Answers5