how to retrieve JSON object from the JSON array

Question

I am having the below JSON. Inside this JSON I am having "ticketDetails" as JSON array. From this array I want to retrieve the value of ticketPrice inside the json object "amount". How can I do that?

{
    "ticketDetails": [{
        "seq": 1,
        "qty": 2,
        "amount": {
            "ticketPrice": 120,
            "bookingFee": 50
        },
        "session": {
            "id": 1001,
            "date": "2013, 9, 15",
            "time": "1300"
        },
        "venue": {
            "id": "MTRG",
            "name": "Adlabs Manipur",
            "companyCode": "ADLB"
        },
        "event": {
            "id": "ET00000001123",
            "name": "Chennai Express",
            "producerCode": "YRF"
        },
        "category": {
            "ttypeCode": "00012",
            "areaCatCode": "2414",
            "type": "Gold",
            "price": 270
        }
    }]
}

Any suggestion will helpful...

Which programming language do you use? JavaScript? By the way, the enter code here makes your JSON invalid. — sebastian_oe
– sebastian_oe, Commented Oct 21, 2013 at 7:56
Is there a reason ticketDetails is an array? If you want an extremely modular, object oriented solution, you could check out the GSON library. It may be overkill, but it's worth a quick gander. You would essentially deserialize the json into its respective java objects and then use getters to retrieve the data you want. — Franklin
– Franklin, Commented Oct 22, 2013 at 5:47

NamingException · Accepted Answer · 2013-10-22 05:19:30Z

2

Below is the sample code for retrieving the ticketPrice from the given JSONObject:

JSONObject objData = (JSONObject)JSONSerializer.toJSON(data);
JSONArray objTicketDetailsJsonArr = objData.getJSONArray("ticketDetails");
for(int nSize=0; nSize < objTicketDetailsJsonArr.size(); nSize++){
    String ticketPrice = "";
    ticketPrice = objTicketDetailsJsonArr.getString("ticketPrice");
}

Below are the imports for the above code:

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JSONSerializer;

source of JAR: http://json-lib.sourceforge.net/

edited Oct 22, 2013 at 5:19

answered Oct 21, 2013 at 9:38

NamingException

2,4041 gold badge20 silver badges42 bronze badges

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

Comments

Mohamed Ali JAMAOUI · Accepted Answer · 2013-10-21 09:24:11Z

1

you store your data within a variable

  data = {...}

then you access it this way:

data.ticketDetails[0].amount.ticketPrice

if the ticketDetails have more than one element

you can loop over the ticketDetails array and store all the ticketPrice values within an other array, ticketPriceArray

the following would work fine in JavaScript:

var ticketPriceArray = data.ticketDetails.map(function(k){
 return k.amount.ticketPrice;
});

if you are using another programming language a general loop would work fine also

for ( i; i< ticketDetails.length ; i++){
    ticketPriceArray[i] = data.ticketDetails.amount.ticketPrice[i];
}

For Java check this tutorial: http://answers.oreilly.com/topic/257-how-to-parse-json-in-java/

edited Oct 21, 2013 at 9:24

answered Oct 21, 2013 at 7:58

Mohamed Ali JAMAOUI

14.8k14 gold badges79 silver badges124 bronze badges

Comments

Shyam B R · Accepted Answer · 2013-10-22 06:16:53Z

0

you can try this code:

JsonObject transactiondata = (JsonObject)Offer.get("transData");
JsonObject ticketdata = (JsonObject)transactiondata.get("tickets");
JsonObject offerData = (JsonObject)Offer.get("offerData");
JsonObject offerData1 = (JsonObject)offerData.get("offerconfig");

JsonArray jsonarr= (JsonArray)ticketdata.get("ticketDetails");

double ticketPrice = Double.parseDouble(jsonarr.get(0).getAsJsonObject().get("amount").getAsJsonObject().get("ticketPrice").getAsString());
System.out.println("ticketPrice:"+ticketPrice);

answered Oct 22, 2013 at 6:16

Shyam B R

661 silver badge4 bronze badges

Collectives™ on Stack Overflow

how to retrieve JSON object from the JSON array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related