Question 110060 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

How to remove the "nameValuePairs" key from a json in java SpringBoot?

I have the following method that when receiving an xml in a String converts it to objects of type CitiMarketSSAEvent

public CitiMarketSSAEvent convertXmlToObject(String xml){
    CitiMarketSSAEvent citiMarket = null;
    
    JAXBContext jaxbContext =     JAXBContext.newInstance(CitiMarketSSAEvent.class);
    Unmarshaller unmarshaller = jaxbContext.createUnmarshaller();
    StringReader reader = new StringReader(xml);
    citiMarket = (CitiMarketSSAEvent) unmarshaller.unmarshal(reader);
    return citiMarket;
}

and then I have the following method that converts the objects of that class into a json

public String convertObjectToJson(CitiMarketSSAEvent citiMarketObject) {
    GsonBuilder gsonBuilder = new GsonBuilder();
    gsonBuilder.setPrettyPrinting();
    gsonBuilder.disableHtmlEscaping();

    Gson gson = gsonBuilder.create();
    return gson.toJson(citiMarketObject, CitiMarketSSAEvent.class);
}

and it paints the json as follows

{
    "header":{
        "name": "transactionCount",
        "version": "2.0",
        "code": "1530",
        "country": "MX",
        "domain": "counts",
        "time": "2018-10-11 11:20:34.323 GMT",
    },
    "body":{
        "INPUNT": "I",
        "MESSAGE_01": "RSTW",
        "MESSAGE_02": "MNXTYP",
        "MESSAGE_03": "RSTWERDCV",
        "SEND_TIME": "20-NOV-2011 04:53:04 p.m.",
        "RCV_ID": "ABGRCV",
        "FORMAT0_MONTO": "200,000,300.00",
        "FORMATO_MONEDA": "USD",
        "CONTROL_01": "MSG1RCVSND",
        "CONTROL_02": "MSG2RCVSND",
        "CONTROL_03": "MSG3RCVSND",
    }
}

but I want to add the "event" key to the json in such a way that I get something like this:

{
 "event":{
    "header":{
        "name": "transactionCount",
        "version": "2.0",
        "code": "1530",
        "country": "MX",
        "domain": "counts",
        "time": "2018-10-11 11:20:34.323 GMT",
    },
    "body":{
        "INPUNT": "I",
        "MESSAGE_01": "RSTW",
        "MESSAGE_02": "MNXTYP",
        "MESSAGE_03": "RSTWERDCV",
        "SEND_TIME": "20-NOV-2011 04:53:04 p.m.",
        "RCV_ID": "ABGRCV",
        "FORMAT0_MONTO": "200,000,300.00",
        "FORMATO_MONEDA": "USD",
        "CONTROL_01": "MSG1RCVSND",
        "CONTROL_02": "MSG2RCVSND",
        "CONTROL_03": "MSG3RCVSND",
    }
  }
}

and then I modified my method as follows using JSONObject

public String convertObjectToJson(CitiMarketSSAEvent citiMarketObject) {
        GsonBuilder gsonBuilder = new GsonBuilder();
        gsonBuilder.setPrettyPrinting();
        gsonBuilder.disableHtmlEscaping();
        
        JSONObject jsonObj = new JSONObject();
        jsonObj.put("event",citiMarketObject);
        
        Gson gson = gsonBuilder.create();
        return gson.toJson(jsonObj, JSONObject.class);                                            
  }

and it throws me the json but the key "nameValuePairs" was added, how can it be removed? Or how else can I do it to just add the "event" key?

 {
    "nameValuePairs":{
        "event":{
            "header":{
                "name": "transactionCount",
                "version": "2.0",
                "code": "1530",
                "country": "MX",
                "domain": "counts",
                "time": "2018-10-11 11:20:34.323 GMT",
            },
            "body":{
                "INPUNT": "I",
                "MESSAGE_01": "RSTW",
                "MESSAGE_02": "MNXTYP",
                "MESSAGE_03": "RSTWERDCV",
                "SEND_TIME": "20-NOV-2011 04:53:04 p.m.",
                "RCV_ID": "ABGRCV",
                "FORMAT0_MONTO": "200,000,300.00",
                "FORMATO_MONEDA": "USD",
                "CONTROL_01": "MSG1RCVSND",
                "CONTROL_02": "MSG2RCVSND",
                "CONTROL_03": "MSG3RCVSND",
            }
        }
    }
}
Tags:

2

Answers


  1. 0

    Try this code, it is supposed to do what you need.

    package com;


import com.fasterxml.jackson.annotation.JsonProperty;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;

import java.util.LinkedHashMap;

public class Main {
    public static void main(String[] args) throws JsonProcessingException {
        String json = "{n" +
                "    "header":{n" +
                "        "name": "transactionCount",n" +
                "        "version": "2.0",n" +
                "        "code": "1530",n" +
                "        "country": "MX",n" +
                "        "domain": "counts",n" +
                "        "time": "2018-10-11 11:20:34.323 GMT"n" +
                "    },n" +
                "    "body":{n" +
                "        "INPUNT": "I",n" +
                "        "MESSAGE_01": "RSTW",n" +
                "        "MESSAGE_02": "MNXTYP",n" +
                "        "MESSAGE_03": "RSTWERDCV",n" +
                "        "SEND_TIME": "20-NOV-2011 04:53:04 p.m.",n" +
                "        "RCV_ID": "ABGRCV",n" +
                "        "FORMAT0_MONTO": "200,000,300.00",n" +
                "        "FORMATO_MONEDA": "USD",n" +
                "        "CONTROL_01": "MSG1RCVSND",n" +
                "        "CONTROL_02": "MSG2RCVSND",n" +
                "        "CONTROL_03": "MSG3RCVSND"n" +
                "    }n" +
                "}";

        ObjectMapper objectMapper = new ObjectMapper();
        LinkedHashMap hashMap = objectMapper.readValue(json, LinkedHashMap.class);
        Event event =  new Event(hashMap);
        System.out.println(objectMapper.writerWithDefaultPrettyPrinter().writeValueAsString(event));
    }

    public static class Event {
        @JsonProperty("event")
        private LinkedHashMap event;
        public Event(LinkedHashMap event){
            this.event = event;
        }
    }
}
    Login or Signup to reply.
  2. 0

    Use Map instead of JSONObject would fix nameValuePairs

    The code should be like this

      public String convertObjectToJson(CitiMarketSSAEvent citiMarketObject) {
    GsonBuilder gsonBuilder = new GsonBuilder();
    gsonBuilder.setPrettyPrinting();
    gsonBuilder.disableHtmlEscaping();

    Map<Object,Object> map = new HashMap<>();
    map.put("event",citiMarketObject);

    Gson gson = gsonBuilder.create();
    return gson.toJson(map);
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search