single xml objects as json array in sql
up vote
1
down vote
favorite
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" }]
c# sql
edited Nov 21 at 6:43
abhirathore2006
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
1
down vote
favorite
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" }]
c# sql
edited Nov 21 at 6:43
abhirathore2006
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4: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 at 6:52
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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" }]
c# sql
edited Nov 21 at 6:43
abhirathore2006
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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" }]
c# sql
c# sql
edited Nov 21 at 6:43
abhirathore2006
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 6:43
abhirathore2006
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 21 at 6:43
abhirathore2006
2,1391624
edited Nov 21 at 6:43
abhirathore2006
2,1391624
edited Nov 21 at 6:43
abhirathore2006
2,1391624
2,1391624
asked Nov 21 at 4:07
abirami
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 21 at 4:07
abirami
61
asked Nov 21 at 4:07
abirami
61
61
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
abirami is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4: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 at 6:52
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04
add a comment |
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4: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 at 6:52
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4:42
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4: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 at 6:52
when you change as multiple user object, you wont see like you want. The converter will convert as'[ "user1", "user1" ]'
– Mustafa Tığ
Nov 21 at 6:52
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
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 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
up vote
0
down vote
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 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Nov 21 at 8:51
Sk83r1l4m4
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Nov 21 at 8:51
Sk83r1l4m4
416
answered Nov 21 at 8:51
Sk83r1l4m4
416
416
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Sk83r1l4m4 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
abirami is a new contributor. Be nice, and check out our Code of Conduct.
abirami is a new contributor. Be nice, and check out our Code of Conduct.
abirami is a new contributor. Be nice, and check out our Code of Conduct.
abirami is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53405128%2fsingle-xml-objects-as-json-array-in-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
root <users> is the label for your JSON object. when you have multiple <user> you will see "user": [ "user1", "user1" ]
– comphonia
Nov 21 at 4: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 at 6:52
How would your converter xml-to-json know that it could be an array? Do you have an XSD?
– nvoigt
Nov 21 at 9:04