Java code to Convert JSON into a Map with specific fields as Key and values-CodePudding

I have a JSON as follows

[
    {
        "a": "John",
        "id": "6",
        "c": "val1"
    },
    {
        "a": "Jack",
        "id": "6",
        "c": "val2"            
    },
    {
        "a": "Joe",
        "id": "6",
        "c": "val3"
    }
]

I need to convert it into a Map<String, String> such that the values of the fields 'a' become the key and the values of the fields 'c' become the value in the Map.

In other words, my Map should look like the below:

John:val1
Jack:val2
Joe:val3

What is the shortest way to do this?

Also, I was wondering if in any way RestAssured GPath can be leveraged here

Something like this -

new JsonPath(jsonPayload).getString("findAll { json -> json.id == '6' }.a");

CodePudding user response：

Are u looking for JsonSlurper ?

import groovy.json.JsonSlurper

String json = '''
[
    {
        "a": "John",
        "id": "6",
        "c": "val1"
    },
    {
        "a": "Jack",
        "id": "6",
        "c": "val2"            
    },
    {
        "a": "Joe",
        "id": "6",
        "c": "val3"
    }
    
]
'''

def root = new JsonSlurper().parseText(json)
def result = root.findAll{it.id == '6'}.collectEntries{[it.a, it.c]}
print(result)

CodePudding user response：

You can use jsonpath library to make it. Add it into your pom.xml:

<dependency>
    <groupId>com.jayway.jsonpath</groupId>
    <artifactId>json-path</artifactId>
    <version>2.4.0</version>
</dependency>

Then try following code

// read the a, c of json string by the JsonPath libraby
List<String> aList = JsonPath.read(json, "$.[*].a");
List<String> cList = JsonPath.read(json, "$.[*].c");

// combine two list to a map
Iterator<String> i1 = aList.iterator();
Iterator<String> i2 = cList.iterator();
Map<String, String> map = new HashMap<>();
while (i1.hasNext() && i2.hasNext()) {
    map.put(i1.next(), i2.next());
}

// print it 
map.forEach((k,v) -> System.out.println(k   ":"   v));

See more about jsonpath

CodePudding user response：

You can convert it first to a list of YourObject and them convert it to a map following the rules you want ( key = a, value = c)

Create a class that represent the json object:

 class YourObject
 {
     String a;
     String id;
     String c;

     // contructors
     // getters and setters    
 }

Desserialize your JSON into it using Gson:

String json = "<PUT YOUR JSON HERE>";

List<YourObject> list = new GsonBuilder().create().fromJson(json, new TypeToken<List<YourObject>>(){}.getType());

Then transform it to a map:

Map<String, String> map = list.stream().collect(Collectors.toMap(YourObject::getA, YourObject::getC));

If you want to filter by an specific id (forxample id=6) you can do like that:

Map<String, String> map = list.stream()
            .filter(yo -> yo.getId().equals("6"))
            .collect(Collectors.toMap(YourObject::getA, YourObject::getC));