How to convert XML to Json with only STRING type

Question

I use JSONObject's toJSONObject() to convert XML into JSON. However, there is an annoying converting problem for me.

For example, my original XML looks like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><testData><Timestamp>20170907005718936</Timestamp><Detail><Item1>02907005718520</Item1><Item2>02907425118520</Item2><Item3>20170921133613</Item3></Detail></testData>

then I do the following to convert them into JSON:

String xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><testData><Timestamp>20170907005718936</Timestamp><Detail><Item1>02907005718520</Item1><Item2>02907425118520</Item2><Item3>20170921133613</Item3></Detail></testData>";
    try {
        JSONObject xmlObj = XML.toJSONObject(xml);
        System.out.println(xmlObj.toString());
    } catch (JSONException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

After conversion, my data inside each tag is corrupted, because it thinks they are NUMBERS, not STRING.

{"testData":{"Timestamp":20170907005718936,"Detail":{"Item1":2907005718520,"Item2":2907425118520,"Item3":20170921133613}}}

How can I convert all tag values into String type only?

@CodeMatrix it's just "Converted", not into the data type I want — user6309529
– user6309529, Commented Sep 21, 2017 at 10:39

mohan raj · Accepted Answer · 2018-04-13 00:36:10Z

4

Try this,

JSONObject xmlObj = XML.toJSONObject(xml,true);

the boolean after the input XML in a function will return as you expected the result.

thanks, Morajse

answered Apr 13, 2018 at 0:36

mohan raj

413 bronze badges

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

2 Comments

user6309529 Over a year ago

sadly this solution come late, so I'll give you thumb up for useful

aled Over a year ago

@user6309529 you can change the accepted answer if a better one appears. See meta.stackoverflow.com/a/256595/721855

Yahya · Accepted Answer · 2017-09-22 08:45:51Z

0

You can try convert every number to a String, something like:

String xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><testData><Timestamp>20170907005718936</Timestamp><Detail><Item1>02907005718520</Item1><Item2>02907425118520</Item2><Item3>20170921133613</Item3></Detail></testData>";
xml = xml.replaceAll("(?<=\\d+)<", "\"<"); // any < preceded by digits
xml = xml.replaceAll(">(?=\\d+)", ">\""); // any > followed by digits
System.out.println(xml);

Output:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><testData><Timestamp>"20170907005718936"</Timestamp><Detail><Item1>"02907005718520"</Item1><Item2>"02907425118520"</Item2><Item3>"20170921133613"</Item3></Detail></testData>

EDIT:

If you may have String values that may start/end with a digit(s), you can specify the lower limit of how many digits your value should have to be considered as a Number, for example:

xml = xml.replaceAll("(?<=\\d{5})<", "\"<"); // any < preceded by at least 5 digits
xml = xml.replaceAll(">(?=\\d{5})", ">\""); // any > followed by at least 5 digits

edited Sep 22, 2017 at 8:45

answered Sep 21, 2017 at 10:20

Yahya

14.3k6 gold badges34 silver badges45 bronze badges

3 Comments

user6309529 Over a year ago

this would add extra double-quote into my result if the value is STRING already. like <Item4>Item4</Item4> would be turned into "Item4":"Item4\"" after XML to JSON conversion. need to adjust it

user6309529 Over a year ago

But yours seem like most close to what I need. If there's no better one posted in next few days, I'll tag you as right answer.

aled Over a year ago

Using string manipulation functions to transform JSON or XML is a bad practice and can cause issues, for example the extra quoting mentioned.

F0XS · Accepted Answer · 2017-09-21 09:47:19Z

0

I think this can be use : Class :

public JSONObject() {
    this.map = new LinkedHashMap<String, Object>();
}
 
 
public JSONObject(Map<String, Object> map) {
    this.map = new LinkedHashMap<String, Object>();
    if (map != null) {
        Iterator<Entry<String, Object>> i = map.entrySet().iterator();
        while (i.hasNext()) {
            Entry<String, Object> entry = i.next();
            Object value = entry.getValue();
            if (value != null) {
                this.map.put(entry.getKey(), wrap(value));
            }
        }
    }
}

Then on your main :

String xml = FileUtils.readFileToString(new File("test.xml"));
System.out.println(org.json.XML.toJSONObject(xml).toString());

Hope it help's you ! =)

answered Sep 21, 2017 at 9:47

F0XS

1,2693 gold badges16 silver badges19 bronze badges

1 Comment

user6309529 Over a year ago

sadly this one make no different between using XML.toJSONObject(), my 0 on the left at each tag value still trimmed.

Collectives™ on Stack Overflow

How to convert XML to Json with only STRING type

3 Answers 3

2 Comments

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related