Converting XML string to JSON

Question

I am making an API request to the Census API for my Node app. The response I am receiving is an XML string:

"[["POP","DATE","state"],
["735132","6","02"],
["735132","6","02"]]"

I would like to convert it into JSON. I have tried using npm xml2js but I am receiving the following error:
"Non-whitespace before first tag. Line: 0 Column: 1
I dont understand XML, so its makes it difficult to comprehend the error message. Any good ideas how I can convert this response to JSON? Thanks in advance!

Why do you think it's an XML stirng if it's a JSON string? Just do a JSON.parse(your_string) — Vsevolod Goloviznin
– Vsevolod Goloviznin, Commented Dec 11, 2015 at 17:07
If that's an XML response, I'm losing my mind.... @VsevolodGoloviznin your comment should work — Ferry Kobus
– Ferry Kobus, Commented Dec 11, 2015 at 17:07
Your example is not an XML string. That's why you can't convert is using xml2js — Matt Hogan-Jones
– Matt Hogan-Jones, Commented Dec 11, 2015 at 17:08
Sorry. I figured an JSON response would be an object {} rather than an array [] — Steez
– Steez, Commented Dec 11, 2015 at 17:10

Ferry Kobus · Accepted Answer · 2015-12-11 17:10:11Z

2

You are not getting a XML response. It's a parsed JSON string.

So if you want a JSON Object:

var response = "[["POP","DATE","state"], ["735132","6","02"], ["735132","6","02"]]";
var json = JSON.parse(response);

answered Dec 11, 2015 at 17:10

Ferry Kobus

2,0492 gold badges14 silver badges18 bronze badges

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

Comments

chapinkapa · Accepted Answer · 2015-12-11 17:09:21Z

1

This is JSON. The problem is it has 2 extra double quotes, at the beginning and the end.

You can do:

var string = stringFromAPI;
var sringWithoutExtraDoubleQuotes = string.substring(1, string.length - 1);
var parsedObject = JSON.parse(sringWithoutExtraDoubleQuotes);

answered Dec 11, 2015 at 17:09

chapinkapa

2,6833 gold badges16 silver badges22 bronze badges

1 Comment

chapinkapa Over a year ago

Node might actually parse it without removing the extra double quotes.

Collectives™ on Stack Overflow

Converting XML string to JSON

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related