put XML document in json

[MD]

I want to put the xml document into the JSON like the following.

[
{
"id" : "123333",
"xmldoc": "<? xml version=\"1.0\" ?><data><link></link></data>";
},
{
"id" : "123334",
"xmldoc": "<? xml version=\"1.0\" ?><data><link></link></data>";
},
]

However, usually my xml document has new line for the xml document. Is there
any option to skip the new line in the JSON or I just have to remove them
manually .


MD

 

[MD]

Thanks for reply,

However, I don't want to conver to any format but json.
We have xml document for each record in oracle xml type,
I just want to get it and pass to the browser from servlet as a search
result.

[

 

[Tom Cole]

Thanks for reply,

However, I don't want to conver to any format but json.
We have xml document for each record in oracle xml type,
I just want to get it and pass to the browser from servlet as a search
result.

[

{
"id" : "123333",
"xmldoc": "<? xml version=\"1.0\" ?><data><link></link></data>";
},
{
"id" : "123334",
"xmldoc": "<? xml version=\"1.0\" ?><data><link></link></data>";
},
]

Both your sample here and the one I gave are JASON.

Just for future reference, it's JSON (I went to school with a Jason,
though). Wouldn't want you to put JASON on a job application or
anything, might loose some "cred" with the employer...

I once had a friend ask me if I'd heard anything about some new
technology called Rudy on Rails. I snickered (inside of course).

 

[Martin Honnen]

MD wrote:

However, usually my xml document has new line for the xml document. Is there
any option to skip the new line in the JSON or I just have to remove them
manually .

I am not sure I understand the problem, if you build JSON with
<http://www.json.org/json.js>
then the result you get for e.g.
var s = ['<gods>', '<god>Kibo</god>', '</gods>'].join('\r\n');
var obj = { xml: s };
obj.toJSONString()
is
{"xml":"<gods>\r\n<god>Kibo</god>\r\n</gods>"}
so all line break/carriage return characters are properly escaped.
Simply use that library or the proper library for other languages (e.g.
PHP) to create your JSON data and line breaks/carriage returns in
strings (of XML or otherwise) should not be a problem, they will simply
be escaped as needed.

 

[Martin Honnen]

drclue wrote:

I think the OP's newline issue might actually be related not so much to
the data itself , but rather spreading the JSON syntax over multiple
lines of source which can cause parsing issues.

I think JSON allows white space like line breaks between
tokens/delimiters: <http://www.ietf.org/rfc/rfc4627.txt?number=4627>