how to get all values of a key from a nested json

user_3369042 0
Viewed 1095

for example I have a json object like this:

{
"pic":"1.jpg",
"products":[
{
"id":1,
"pic":"4.jpg"
}
]

}

now I want to fetch all pic key inside an array or a list. the result must be: ["1.jpg","4.jpg"]

android json java
4 Answers

There is a simple solution for this in jackson library.

String value = "{\"pic\":\"1.jpg\",\"products\":[{\"id\":1,\"pic\":\"4.jpg\"}]}";
JsonNode jsonNode = new  ObjectMapper().readTree(value);
System.out.println(jsonNode.findValuesAsText("pic"));

You can add jackson by using following maven dependency.

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

You can also pass file, inputstream to readTree().

user_92462740

Please try this code:

    //define a list which will contain pic names
    List<String> picList = new ArrayList<>();
    try {
        //jsonMap: your json object variable name
        String picName = (String) jsonMap.get("pic");
        picList.add(picName);
    
        List<Map<String, Object>> products = (List<Map<String, Object>>) jsonMap.get("products");
        for (Map<String, Object> product : products) {
            String pic = (String) product.get("pic");
            picList.add(pic);
        }
    
        System.out.println("=====List of pics===="+picList);
    } catch (Exception e) {
    
    }
user_106611260

It would be better if you parse the json to a POJO class. You can use Gson to convert json string to below Data class object.

String jsonString = "you json string here"
Data object = Gson().fromJson(jsonString, Data.class)

Now you have the object and can get product list from which you can iterate and get "pic" values.

Below is the class

package com.example;

import java.util.List;
import com.google.gson.annotations.Expose;
import com.google.gson.annotations.SerializedName;

public class Data {

@SerializedName("pic")
@Expose
private String pic;
@SerializedName("products")
@Expose
private List<Product> products = null;

public String getPic() {
return pic;
}

public void setPic(String pic) {
this.pic = pic;
}

public List<Product> getProducts() {
return products;
}

public void setProducts(List<Product> products) {
this.products = products;
}

}
-----------------------------------com.example.Product.java-----------------------------------

package com.example;

import com.google.gson.annotations.Expose;
import com.google.gson.annotations.SerializedName;

public class Product {

@SerializedName("id")
@Expose
private int id;
@SerializedName("pic")
@Expose
private String pic;

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getPic() {
return pic;
}

public void setPic(String pic) {
this.pic = pic;
}

}
user_54566210

If you want the list of pics within the products node, then you can get the entire JSON into a JSONObject, and iterate over the inner JSONArray

String str = "{\n" +
        "\"pic\":\"1.jpg\",\n" +
        "\"products\":[\n" +
        "{\n" +
        "\"id\":1,\n" +
        "\"pic\":\"4.jpg\"\n" +
        "}\n" +
        "]\n" +
        "\n" +
        "}";

ArrayList<String> list = new ArrayList<>();

try {
    JSONObject root = new JSONObject(str);
    JSONArray products = root.getJSONArray("products");

    for (int i = 0; i <= products.length(); i++) {
        String value = ((JSONObject) products.get(i)).getString("pic");
        list.add(value);
    }

} catch (JSONException e) {
    e.printStackTrace();
}

Log.d(TAG, "onCreate: " + list);
user_98516080
Related