single xml objects as json array in sql

Question

From SQL, I generated my XML and it looks like this

<users>
    <user>user1</user>
</users>

Then I converted it to JSON and it looks like this,

"users": { "user": "user1" }

but I'm expecting a JSON to look like a single object array:

"users": [{ "user": "user1" }]

root is the label for your JSON object. when you have multiple you will see "user": [ "user1", "user1" ] — comphonia, Nov 21 '18 at 04:42
when you change as multiple user object, you wont see like you want. The converter will convert as'[ "user1", "user1" ]' — Mustafa Tığ, Nov 21 '18 at 06:52
How would your converter xml-to-json know that it *could* be an array? Do you have an XSD? — nvoigt, Nov 21 '18 at 09:04

score 0 · Answer 1 · answered Nov 21 '18 at 08:51

0

Singe object array for JSON is basically the same as a single object.

There is a tricky way to overcome this, that is mentioned in this answer.

I would post this as a comment, but can't due to my privileges. Thank you for your understanding !

answered Nov 21 '18 at 08:51

Sk83r1l4m4

1 Answers1