Nodejs - Mysql - Nested JSON Response

Question

I have a NodeJS Express API developed. I have a query and the respone of the query has to be send as nested response in the format mentioend below :

[
 {
  Status: Success,
  data:{
        "Key 1" : "Value1"
       },
       {
        "Key 2" : "Value2"
       }

  }
]

Key and value are obtained from mysql query which returns the response.

app.post('/getstatus', function(req, res){
    r1= req.body.imei;


    mysqlQuery = `SELECT value from table1 where key = true `;

    mysqlPool.query(mysqlQuery, function(error, response, fields){
        if(error){
            result = [{Status:"Error", Error: "Error Connecting to Database. Contact Administrator.", ErrorDetails:error.message }];

        }else{

            result=[{status:"Success", data:JSON.stringify(response)}];
        }
        res.json(result);
    });
});

I have tried the above code but it doesn't give me the response correctly. JSON.stringify(response) doesn't convert the data to JSON format.

Sydney Y · Accepted Answer · 2020-02-04 05:07:12Z

1

else{

            result=[{status:"Success", data:response}];
        }
        res.json(JSON.stringify(result));

answered Feb 4, 2020 at 5:07

Sydney Y

3,1503 gold badges11 silver badges15 bronze badges

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

2 Comments

EmreSURK Over a year ago

Why you used 'stringify'? res.json(result); will work, I think.

Sydney Y Over a year ago

Hey, good point! Docs on re.json here expressjs.com/en/api.html#res.json I didn't even look at OP's response method, just that they were using stringify in the wrong spot!

Engineer S. Saad · Accepted Answer · 2020-02-04 05:10:21Z

0

Donot stringify the response at server side. You should send it like a JSON and on user stringify it.

answered Feb 4, 2020 at 5:10

Engineer S. Saad

3845 silver badges20 bronze badges

1 Comment

Sydney Y Over a year ago

I think you're mistaking stringify for parse. Stringify makes a widely compatible string, and parse changes that into a JavaScript object. I'm not sure if the server can send a JavaScript object over http.

Collectives™ on Stack Overflow

Nodejs - Mysql - Nested JSON Response

2 Answers 2

2 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Related