JSON returning undefined values

Question

I have a problem with a json output values returning undefined.

JSON:

[ { ID: 2, user: 'ngx.daniel', password: 'password', admin: 'F' } ]

CODE:

console.log(res);
res = JSON.stringify(res);
console.log(res);
var user = {};
user.user = res.user;
user.password = res.password;
user.admin = res.admin;
console.log(user);

OUTPUT:

[ RowDataPacket { ID: 2, user: 'ngx.daniel', password: 'password', admin: 'F' } ]
[ { ID: 2, user: 'ngx.daniel', password: 'password', admin: 'F' } ]
{ user: undefined, password: undefined, admin: undefined }

JSON.stringify returns a string. Why do you expect a string to have a user property? — SLaks
– SLaks, Commented Sep 20, 2015 at 19:22
Your JSON syntax is wrong. It should be [ { "ID": 2, "user": "ngx.daniel", "password": "Root_!$@#", "admin": "F" } ]. — Guffa
– Guffa, Commented Sep 20, 2015 at 19:24

Craicerjack · Accepted Answer · 2015-09-20 19:28:43Z

3

A few things. If this is your json:

[ RowDataPacket { ID: 2, user: 'ngx.daniel', password: 'password', admin: 'F' } ]

you dont need to stringify it. When you stringify it you turn your object into a string. you then try to access attributes of a string, which it doesnt have.
1 - Remove the stringify
2 - Thats an array thats being returned with a RowPacketData object, which is also invalid json.
3 - To access an object in an array you need to first access the index. So it should really be something like

(if res = [ { ID: 2, user: 'ngx.daniel', password: 'Root_!$@#', admin: 'F' }])

var user = {};
user.user = res[0].user;
user.password = res[0].password;
user.admin = res[0].admin;

edited Sep 20, 2015 at 19:28

answered Sep 20, 2015 at 19:22

Craicerjack

6,3303 gold badges34 silver badges41 bronze badges

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

Comments

user2609980 · Accepted Answer · 2015-09-20 19:30:11Z

0

The response can apparently consist of multiple items (RowDataPackets). You can get the first via index 0. And there is no need to stringify the response:

console.log(res);
var user = {};
user.user = res[0].user;
user.password = res[0].password;
user.admin = res[0].admin;
console.log(user);

Which prints

Object { user="ngx.daniel", password="Root_!$@#", admin="F"}

answered Sep 20, 2015 at 19:30

user2609980

10.5k17 gold badges87 silver badges147 bronze badges

Collectives™ on Stack Overflow

JSON returning undefined values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related