Parse json object to string in node.js

Question

this my code

app.get('/status',function ( req,res) {
        var data = {
            "error": 1,
            'data status': ""
        };
        connection.query("SELECT * from status", function (err, rows, fields) {
            if (rows.length != 0) {
            data = rows;
                console.log(data);
                res.json(data);
             } else {
                data["Data status"] = '0';
                res.json(data);
            }
        })
});

I had a problem I try to change the json object

[{"id_status":5,"pin_arduino":1,"status":0}]

I will eliminate be

{"id_status":5,"pin_arduino":1,"status":0}

yes i'am try JSON.parse, JSON.stringify not work @evolutionxbox — erwins wiradhika
– erwins wiradhika, Commented Mar 6, 2017 at 9:44
Why did you use stringify? Please read developer.mozilla.org/docs/Web/JavaScript/Reference/… — evolutionxbox
– evolutionxbox, Commented Mar 6, 2017 at 9:45
I tried to remove the existing array format in json @damitj07 — erwins wiradhika
– erwins wiradhika, Commented Mar 6, 2017 at 9:46

rsp · Accepted Answer · 2017-03-06 10:11:16Z

It's not clear what you're asking for.

If you get this:

[{"id_status":5,"pin_arduino":1,"status":0}]

and you want this:

{"id_status":5,"pin_arduino":1,"status":0}

then instead of:

res.json(data);

use:

res.json(data[0]);

If you get this:

{"id_status":5,"pin_arduino":1,"status":0}

and you want this:

[{"id_status":5,"pin_arduino":1,"status":0}]

then instead of:

res.json(data);

use:

res.json([data]);

Also, looking at your examples, this:

data["Data status"] = '0';

should probably be:

data.status = 0;

or:

data[0].status = 0;

depending on how your data really looks like, which is not entirely clear from your question.

Note that you're not doing anything with JSON here. You just handle normal JS objects which get serialized to JSON automatically by Express when you use res.json() so there's no need to use JSON.parse() or JSON.stringify() at all, at least not in the code that you included in your question.

Collectives™ on Stack Overflow

Parse json object to string in node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related