Is there a way to find a JSON response element value based on another element value?

Question

Using the below method i could get the "id" element(first element in first list) value. i need to get that element value but based on the condition of another element "gifts.nameEn"

Response response = request.post("/pop/transaction/inquiry");
JsonPath jsonPathEvaluator = response.jsonPath();

List<HashMap> activeCampaignsList = jsonPathEvaluator.getList("");
for(int i=0; i< activeCampaignsList.size(); i++)
{
        offerId = activeCampaignsList.get(i).get("id").toString();
        break;
}

And Here's the response snippet so you would be aware of what exactly i'm looking for:

[ { "**id**": 1222, "type": "WITHIN_TRANSACTION", "gifts": [ { "startDate": "2019-06-26", "endDate": "2019-06-26", "id": 26130, "nameAr": "abcd201957261140057", "nameEn": "*abcd201957261140057*",

what do you mean with 'based on another element value'? What are you trying to accomplish? — arnonuem, Jul 01 '19 at 09:42
the response i'm getting has multiple "gifts" and each one has "**id**" i need to get the value of "**id**" for that specific "gifts.nameEn" note i already have the value of "gifts.nameEn" and i can't send it in request — Tareq Shams, Jul 01 '19 at 09:48
@TareqShams Check out my answer. I was able to get ID based on `gifts.nameEn` — Fenio, Jul 01 '19 at 09:56
@Fenio it's working like a charm and i accepted your answer, Thanks Again :) — Tareq Shams, Jul 01 '19 at 11:15

Fenio · Accepted Answer · 2019-07-01T10:08:14.007

RestAssured allows you use JsonPath which has a strong utility in JSON processing. Instead of working with paths, you can convert JSON to Java Objects and I will show you exactly how to do it.

So, your JSON starts with an array of elements. Each of the element is JSON Object. Each of the JSON Object contains nested JSON Array gifts with JSON Objects in it. Let me explain further.

We have to process the array first, the start of your JSON [. In order to do that we can create a class representing this Array like this:

public class ElementObject { //this name is irrelevant. You can call it whatever you want
    public String id; //the names of the variables are relevant
    public String type; //each of variable name corresponds to the type and name in the JSON
    public List<GiftObject> gifts; //here we handle the nested JSON Array of JSON Objects
}

Now, we require an object to handle gifts. That will require another class:

public class GiftObject { //irrelevant name
    public String startDate; //relevant name
    public String endDate;
    public String id;
    public String nameAr;
    public String nameEn;
}

Now, all we have to do is call 1 method from JsonPath to parse whole JSON into Java classes. Like this:

response.jsonPath().getObject("", ElementObject[].class);

That's mostly it. Starting from the top:

[  
   {  
      "id":1222,
      "type":"WITHIN_TRANSACTION",

We have an JSON Array with JSON Objects. 1 JSON Object equals 1 instance of ElementObject class. All of the objects from the Array will be parsed into ElementObject[].class and JsonPath will create an instance using Java Reflection (You don't have to worry about that).

"gifts": [ { "startDate": "2019-06-26", "endDate": "2019-06-26", "id": 26130, "nameAr": "abcd201957261140057", "nameEn": "abcd201957261140057",

Each of the gifts will be parsed into new instance of GiftObject and storred in List<GiftObject> in ElementObject class.

All we have to do now is work on our Java classes.

To fully answer your question - you need ID value based on gifts.nameEn

for (ElementObject element : elements) {
            for (GiftObject gift : element.gifts) {
                if (gift.nameEn.equals("abcd201957261140057")) {
                    System.out.println(element.id);
                }
            }
        }

The above for loop can be easily replaced with a method, or Java Streams. Whatever suits you the most.

Given the above code the results will be:

Hope it helps!

EDIT: If you get the Exception like this Cannot deserialize object because of no JSON deserializer found in classpath. Please put either Jackson (Databind) or Gson in the classpath. all you have to do is add jackson-databind to Maven. Rest Assured is able to use Gson or Jackson databind to transform JSON into Java classes. All you need is the dependency, and you are all set.

        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.9</version>
        </dependency>

@TareqShams Accept my answer please :) See [how](https://stackoverflow.com/help/someone-answers) — Fenio, Jul 01 '19 at 10:58

Is there a way to find a JSON response element value based on another element value?

1 Answers1