Delete certain array in a JSONArray with JackSon

Question

I have something like this:

    { 
  "Person": {
    "Info": [{
      "name":"Becky",
      "age": 14
      }
    ]
  },
  "FruitsList": {
    "Fruits": [
      {
        "name": "avocado",
        "organic": true
      },
      {
        "name": "mango",
        "organic": true
      }
    ]
  },
  "VegetablesList": {
    "Vegetables": [
      {
        "name": "brocoli",
        "organic": true
      },
      {
        "name": "lettuce",
        "organic": true
      }
    ]
  }
}

I want to remove the array FruitsList and the VegetablesList or perhaps even Person array. Something like this.

{ 
  "Person": {
    "Info": [
      "name": "Becky",
      "age": 14
    ]
   },
  "Fruits": [
    {
      "name": "avocado",
      "organic": true
    },
    {
      "name": "mango",
      "organic": true
    }
  ],
  "Vegetables": [
    {
      "name": "brocoli",
      "organic": true
    },
    {
      "name": "lettuce",
      "organic": true
    }
  ]
}

I am not quite sure what methods to use with in JACKSON libraries to get the right result. I would much appreciate your help. Thanks in advance.

Your input JSON string seems invalid, Info is not a JSON array. — LHCHIN
– LHCHIN, Commented Nov 5, 2019 at 6:50
you can read the input into a Map<String, Object>, remove the keys and serialize the map back to json — Sharon Ben Asher
– Sharon Ben Asher, Commented Nov 5, 2019 at 6:58

LHCHIN · Accepted Answer · 2019-11-05 07:47:35Z

1

A simple way is to remove FruitsList and VegetablesList nodes from root node first, and add Fruits and Vegetables back to it as follows:

ObjectMapper mapper = new ObjectMapper();
JsonNode rootNode = mapper.readTree(jsonStr);
JsonNode personNode = rootNode.get("Person");
JsonNode fruitsListNode = rootNode.get("FruitsList");
JsonNode vegetablesList = rootNode.get("VegetablesList");
((ObjectNode) rootNode).remove("FruitsList");
((ObjectNode) rootNode).remove("VegetablesList");
((ObjectNode) rootNode).put("Fruits", fruitsListNode.get("Fruits"));
((ObjectNode) rootNode).put("Vegetables", vegetablesList.get("Vegetables"));

System.out.println(rootNode.toString());

BTW, as I said in OP's comment, your JSON string is invalid. A valid one should be "Person": {"Info": {...}},....

edited Nov 5, 2019 at 7:47

answered Nov 5, 2019 at 7:31

LHCHIN

4,0782 gold badges19 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Delete certain array in a JSONArray with JackSon

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related