JQuery parse JSON return null

Question

Hello I have the following JSON returned from my server side:

{"command":"SELECT","rowCount":1,"oid":null,"rows":[{"username":"xxxx"}],"fields":[{"name":"username","tableID":34722,"columnID":3,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":204,"format":"text"}],"_parsers":[null]}

I'm parsing that json in javascript like this :

 var ParsedJSONResponse = $.parseJSON(JSONResponseFromServerSide);

The variable is "ParsedJSONResponse" always null, my JSON is valid I checked it in JSONLint so what is going on please?

You do know that if you put the contentType:JSON that jQuery will parse it for you and ultimately return a a JSON object. — Ryan
– Ryan, Commented Sep 19, 2013 at 17:07
looks like the value is already a object not a json string so there is no need to parse it again — Arun P Johny
– Arun P Johny, Commented Sep 19, 2013 at 17:07

Ilya · Accepted Answer · 2013-09-19 17:12:20Z

3

You should parse the String

var stringJson = '{"command":"SELECT","rowCount":1,"oid":null,"rows":[{"username":"xxxx"}],"fields":[{"name":"username","tableID":34722,"columnID":3,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":204,"format":"text"}],"_parsers":[null]}';  
var ParsedJSONResponse = $.parseJSON(stringJson);

You just have a Json (JSONResponseFromServerSide) and no reason to parse it.

Parsing the Json object returns null.

$.parseJSON({}); // returns `null`

answered Sep 19, 2013 at 17:12

Ilya

29.9k19 gold badges119 silver badges161 bronze badges

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

Comments

Shalom Aleichem · Accepted Answer · 2013-09-19 17:16:54Z

0

Your code is correct check out this JSFiddle.

var JSONResponseFromServerSide = '{"command":"SELECT","rowCount":1,"oid":null,"rows":[{"username":"xxxx"}],"fields":[{"name":"username","tableID":34722,"columnID":3,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":204,"format":"text"}],"_parsers":[null]}'; //it's your json string
$.parseJSON(JSONResponseFromServerSide); //nothing wrong

If JSONResponseFromServerSide is already a JavaScript object, than you don't have to do parseJSON

edited Sep 19, 2013 at 17:16

answered Sep 19, 2013 at 17:10

Shalom Aleichem

3,0272 gold badges25 silver badges34 bronze badges

Collectives™ on Stack Overflow

JQuery parse JSON return null

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related