How to change values in a json file using XPath/JsonPath in java

Question

here is the json file

{
    "session":
        {
            "name":"JSESSIONID",
            "value":"5864FD56A1F84D5B0233E641B5D63B52"
        },
    "loginInfo":
        {
            "loginCount":77,
            "previousLoginTime":"2014-12-02T11:11:58.561+0530"
        }
}

I want to change the value of name.by directly giving XPath/JsonPath Like

($.session.name).changevalue("MYSESSINID") this is just a Example

I am correctly using jackson library and using the below code for reading via XPath

ObjectMapper mapper = new ObjectMapper();

        Object jsonObj=mapper.readValue(new File(Json file), Object.class);
        Object name=PropertyUtils.getProperty(jsonObj, "session.name");
        System.out.println("Name:"+name);

so is their a way to change the name by XPath

PropertyUtils.setProperty(jsonObj, "session.value", "new value");

still in the file its not working.

PropertyUtils has a setProperty method as well, have you tried that? — flup
– flup, Commented Dec 2, 2014 at 8:03
@flup setProperty code is not working its not giving any error but its not changing the value either — vaibhavcool20
– vaibhavcool20, Commented Dec 2, 2014 at 8:56
The object tree lives in memory only. So after you change the value in the object tree, you have to serialize it back to file. — flup
– flup, Commented Dec 2, 2014 at 9:01
@flup <br/> PropertyUtils.setProperty(jsonObj, "session.name", "lkihilh"); mapper.writeValue(json file ,jsonObj); this will write the entire json code in a file if the file is big it consume a lot of time Is their in other way to do it — vaibhavcool20
– vaibhavcool20, Commented Dec 2, 2014 at 9:48
Probably best to create a new question for the new question :) — flup
– flup, Commented Dec 3, 2014 at 14:45

kalle · Accepted Answer · 2015-02-24 08:22:51Z

48

Using Jayways JsonPath you can:

private static final Configuration configuration = Configuration.builder()
    .jsonProvider(new JacksonJsonNodeJsonProvider())
    .mappingProvider(new JacksonMappingProvider())
    .build();

@Test
public void a_value_can_be_updated(){

    String originalJson = "{\n"
        + "\"session\":\n"
        + "    {\n"
        + "        \"name\":\"JSESSIONID\",\n"
        + "        \"value\":\"5864FD56A1F84D5B0233E641B5D63B52\"\n"
        + "    },\n"
        + "\"loginInfo\":\n"
        + "    {\n"
        + "        \"loginCount\":77,\n"
        + "        \"previousLoginTime\":\"2014-12-02T11:11:58.561+0530\"\n"
        + "    }\n"
        + "}";

    JsonNode updatedJson = JsonPath.using(configuration).parse(originalJson).set("$.session.name", "MYSESSINID").json();

    System.out.println(updatedJson.toString());
}

You can configure the default JsonProvider so you don't have to pass it in all calls.

answered Feb 24, 2015 at 8:22

kalle

1,91914 silver badges14 bronze badges

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

4 Comments

InCh Over a year ago

I tried your solution but it is setting a number value as string. Any solution to this? eg : tried to set login count to 1, it was returned as : "loginCount":"1"

InCh Over a year ago

Oh found the solution! Pass integer object to set as int

mvmn Over a year ago

What if multiple nodes are matched? Looks like there's a need for something like "forEach" with custom handler that could handle nodes of any types.

RedShift Over a year ago

Note that this only works if the specified key already exists.

vaibhavcool20 · Accepted Answer · 2014-12-02 09:57:11Z

3

PropertyUtils.setProperty(jsonObj, "session.value", "new value");
        PropertyUtils.setProperty(jsonObj, "session.name", "new name");
        mapper.writeValue(Json File ,jsonObj);

answered Dec 2, 2014 at 9:57

vaibhavcool20

8913 gold badges12 silver badges28 bronze badges

2 Comments

JESii Over a year ago

Unfortunately, mapper is not defined so this doesn't work.

CJDownUnder Over a year ago

What's "mapper"?

Vladi · Accepted Answer · 2021-07-18 11:17:28Z

3

the easiest way i found to exchange inside Json (When my Body is a JSONObject)

import com.jayway.jsonpath.JsonPath;


JsonPath.parse(Body).set(fieldPath, Value);

edited Jul 18, 2021 at 11:17

answered Oct 26, 2020 at 9:33

Vladi

2,03823 silver badges36 bronze badges

Comments

Justin · Accepted Answer · 2022-06-29 15:40:12Z

0

I tried Kalle's way, it always said jsonPath not found when I am adding a new field.

So I used this updated way to add a new field

        @Test
        public void a_node_can_be_updated_and_created() throws ParseException{
        
        System.out.println(originalJson);
        JSONObject json = (JSONObject)new JSONParser(JSONParser.DEFAULT_PERMISSIVE_MODE).parse(originalJson);
        JSONObject session = JsonPath.read(json, "$.session");
        session.appendField("new__field", "new__value");        // add a new field
        session.put("name", "Justin2");                         // update an existing field
        System.out.println(JsonFormatter.prettyPrint(json.toJSONString()) );
        
    }

This new way also doesn't need Jackson library, only Jayway.

edited Jun 29, 2022 at 15:40

answered Jun 29, 2022 at 15:23

Justin

1,16612 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to change values in a json file using XPath/JsonPath in java

4 Answers 4

4 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related