storing xml inside json object

Question

I need to store complete XML document as part of JSON object. when i receive the request and try to create JSON object from JSON string like below:

{"content":{
"name" : "xyz",
"details":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>
 <ns0:Report xmlns:ns0=\"http://www.khisko.com/triTypes\">
  <StackTrace>Job-8004 Error in [xxxxxxxxxx]
      Output data invalid&#xD;
  at com.xyz.tst.a(Unknown Source)&#xD;
      caused by: java.lang.NullPointerException&#xD;
   </StackTrace>
   <Msg>Output data invalid</Msg>
  </ns0:Report>"
 }}

I am getting Unterminated string error at first char of details. How can I handle it?

I am using org.json.JSONObject constructor which takes java string as parameter and passing above JSON as java string.

xml is request received from client which i need to preserve. — chappalprasad, Jun 03 '13 at 21:48
@varun - because you need to support a new feature in an existing code base without disrupting other existing functionality :( ;) — Zeek2, Apr 06 '21 at 09:53

score 28 · Answer 1 · answered Jan 21 '19 at 10:27

28

You can encode and decode xml string like

{
  "content": {
    "name": "xyz",
    "details": "PD94bWwgdmVyc2lvbj1cIjEuMFwiIGVuY29kaW5nPVwiVVRGLThcIj8+CiA8bnMwOlJlcG9ydCB4bWxuczpuczA9XCJodHRwOi8vd3d3LmtoaXNrby5jb20vdHJpVHlwZXNcIj4KICA8U3RhY2tUcmFjZT5Kb2ItODAwNCBFcnJvciBpbiBbeHh4eHh4eHh4eF0KICAgICAgT3V0cHV0IGRhdGEgaW52YWxpZCYjeEQ7CiAgYXQgY29tLnh5ei50c3QuYShVbmtub3duIFNvdXJjZSkmI3hEOwogICAgICBjYXVzZWQgYnk6IGphdmEubGFuZy5OdWxsUG9pbnRlckV4Y2VwdGlvbiYjeEQ7CiAgIDwvU3RhY2tUcmFjZT4KICAgPE1zZz5PdXRwdXQgZGF0YSBpbnZhbGlkPC9Nc2c+CiAgPC9uczA6UmVwb3J0Pg==",
    "encoding": "base64"
  }
}

answered Jan 21 '19 at 10:27

bitsabhi

728
8
12

5

To do encoding and decoding in client JavaScript use atob() and btoa(). Here is MDN doc link: https://developer.mozilla.org/en-US/docs/Web/API/WindowBase64/Base64_encoding_and_decoding – Kyrylo Malakhov Aug 11 '19 at 18:15
2

I was wondering why this answer was not marked as the right answer until I saw it is posted 6 years after the question :) – Conffusion May 13 '20 at 14:12
I don't find this answer clear tbh. You have hashed the XML? What if you get that xml from a db and you have to store it as it is in the json file? – Zizzipupp Jan 14 '21 at 11:27
@Zizzipupp looks like base64 encoding to me. Just google base64 to find the appropriate .Net call. e.g. https://learn.microsoft.com/en-us/dotnet/api/system.convert.tobase64string?view=net-5.0 e.g. code: public static String ToBase64String(this String source) { return Convert.ToBase64String(Encoding.Unicode.GetBytes(source)); } – Zeek2 Apr 06 '21 at 10:00

score 14 · Answer 2 · answered Dec 21 '15 at 21:24

14

Just I've changed \" to ' and remove line breaks like @Explosion Pills says

{"content":{
    "name" : "xyz",
    "details":"<?xml version='1.0' encoding='UTF-8'?>
     <ns0:Report xmlns:ns0='http://www.khisko.com/triTypes'>
      <StackTrace>Job-8004 Error in [xxxxxxxxxx]
          Output data invalid&#xD;
      at com.xyz.tst.a(Unknown Source)&#xD;
          caused by: java.lang.NullPointerException&#xD;
       </StackTrace>
       <Msg>Output data invalid</Msg>
      </ns0:Report>"
     }}

answered Dec 21 '15 at 21:24

AITAALI_ABDERRAHMANE

2,499
1
26
31

actually the original question is a duplicate of http://stackoverflow.com/questions/9264470/is-it-possible-to-write-xml-into-json-object but that Thread has the answer hidden in a comment. I have a similar need and will try this approach, I guess this comes closest to XML's CDATA element. – Gregor May 05 '17 at 10:32

score 5 · Answer 3 · edited May 07 '23 at 00:14

5

I didn't want to remove the line breaks from the XML so I've changed the Java class that handles the JSON to not throw unterminated string exceptions for newlines or carriage returns.

edited May 07 '23 at 00:14

user16217248

3,119
19
19
37

answered Jun 06 '13 at 15:24

chappalprasad

775
4
15
26

storing xml inside json object

3 Answers3

Linked