How to retrieve data from a json array

Question

this is how my json response looks like

{
    "id": "fe4a69ef-8b8b-42ad-9c5c-9e0c3e449441",
    "createTime": "2014-04-09T11:29:26Z",
    "updateTime": "2014-04-09T11:29:26Z",
    "status": "Created",
    "transaction": {
        "amount": {
            "currencyCode": "GPP",
            "total": 122
        },
        "qrcode": "1f0e3dad99908345f7439f8ffabdfiop",
        "description": "This is the payment transaction description."
    }
}

when I try to extract values from each parameter upto status I could extract it but when I try to extract the currencyCode it shows No value for currencyCode

I saw this post and modified my code but no use yet

my code

JSONObject jObject = new JSONObject(toReturn);

         if(jObject.has("error")){               
             RES_STATUS     =   AppConstants.FAIL;
         }
         else{               
             AppVariables.id                    =   jObject.getString(AppVariables.id_);
             AppVariables.createTime            =   jObject.getString(AppVariables.createTime_);
             AppVariables.updateTime            =   jObject.getString(AppVariables.updateTime_);
             AppVariables.status                =   jObject.getString(AppVariables.status_);
             JSONArray jArray = jObject.getJSONArray("transaction");


             for (int i=0; i < jArray.length(); i++)
             {
                 try {
                     JSONObject oneObject = jArray.getJSONObject(i);
                     // Pulling items from the array
                     String oneObjectsItem = oneObject.getString("total");
                     String oneObjectsItem2 = oneObject.getString("currencyCode");
                     Log.e("oneObjectsItem", oneObjectsItem);
                     Log.e("oneObjectsItem2", oneObjectsItem2);
                 } catch (JSONException e) {
                     // Oops
                     Log.e("OOps", e.toString());
                 }
             }


             AppVariables.total                 =   String.valueOf(jObject.getInt(AppVariables.total_));
             AppVariables.qrcode                =   jObject.getString(AppVariables.qrcode_);

Hariharan · Accepted Answer · 2014-04-11 04:20:50Z

4

Try this..

"transaction": {        //this is JSONObject not array

Remove below lines

         JSONArray jArray = jObject.getJSONArray("transaction");
         for (int i=0; i < jArray.length(); i++)
         {
             try {
                 JSONObject oneObject = jArray.getJSONObject(i);
                 // Pulling items from the array
                 String oneObjectsItem = oneObject.getString("total");
                 String oneObjectsItem2 = oneObject.getString("currencyCode");
                 Log.e("oneObjectsItem", oneObjectsItem);
                 Log.e("oneObjectsItem2", oneObjectsItem2);
             } catch (JSONException e) {
                 // Oops
                 Log.e("OOps", e.toString());
             }
         }

And add below lines

        JSONObject transaction_obj = jObject.getJSONObject("transaction");
        JSONObject oneObject = transaction_obj.getJSONObject("amount");
        String oneObjectsItem = oneObject.getString("total");
        String oneObjectsItem2 = oneObject.getString("currencyCode");
        Log.e("oneObjectsItem", oneObjectsItem);
        Log.e("oneObjectsItem2", oneObjectsItem2);
        AppVariables.qrcode = transaction_ob.getString("qrcode");

edited Apr 11, 2014 at 4:20

answered Apr 9, 2014 at 12:27

Hariharan

24.9k6 gold badges52 silver badges56 bronze badges

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

2 Comments

suja Over a year ago

It worked but now am getting No value for total. I tried AppVariables.total=jObject.getJSONObject("total").toString(); AppVariables.qrcode=jObject.getJSONObject(AppVariables.qrcode_).toString(); but doesnt seems to work

Hariharan Over a year ago

@suja you have to get like AppVariables.total=jObject.getString("total")).

Weibo · Accepted Answer · 2014-04-09 12:35:11Z

0

gson is another perfect solution for json resolving.

answered Apr 9, 2014 at 12:35

Weibo

1,0428 silver badges18 bronze badges

Comments

Finder · Accepted Answer · 2014-04-09 12:40:27Z

0

transaction is not an JsonArray. That is JsonObject.Try following code. I hope this will help you

JSONObject objTransaction= jObject.getJSONObject("transaction");
String strQrcode=objTransaction.getString("qrcode");
String strDescription=objTransaction.getString("description");
JSonObject objAmount=objTransaction.getJSONObject("amount");

String strTotal=objAmount.getString("total");
String strCurrencyCode = objAmount.getString("currencyCode");

answered Apr 9, 2014 at 12:40

Finder

1,2175 gold badges18 silver badges46 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from a json array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related