How can I return an object instead of an array?

Question

I was trying to return a JSON Object but instead it returns an array. I am using primary key for query so I am sure I will only get one result.

This is my approach :

router.get("/student_info/:id", (req, res, next) => {
    connection.getConnection((error, currentConnection) => {
        if (!!error) {
            console.log("Error occurred while connecting db")
        } else {
            let id = req.params.id;
            currentConnection.query("SELECT * FROM students WHERE id=" + "'" + id + "'", (error, rows, fields) => {
                if (!!error) {
                    console.log(error.message)
                } else {
                    res.status(200).json(rows);
                }
                currentConnection.release();
            });
        }
    });
});

What I want is this :

    {
        "id": "171-15-8966",
        "name": "Alif Hasnain",
        "course_code": "CSE412,CSE413"
    }

But I get the result like this :

[
    {
        "id": "171-15-8966",
        "name": "Alif Hasnain",
        "course_code": "CSE412,CSE413"
    }
]

GMB · Accepted Answer · 2020-03-18 13:17:34Z

1

Just get the first element of the array before the json transformation:

res.status(200).json(rows[0]);

answered Mar 18, 2020 at 13:17

GMB

224k25 gold badges103 silver badges151 bronze badges

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

Comments

Prakhar Patidar · Accepted Answer · 2020-03-18 13:20:50Z

1

By default query return the array of rows reflected by the select query. Since your query has single result it returns as array of single object to user.

You can change it to

res.status(200).json(rows[0]);

Please let us know if got better alternate.

answered Mar 18, 2020 at 13:20

Prakhar Patidar

1441 silver badge8 bronze badges

Comments

Paulo · Accepted Answer · 2021-11-11 17:02:57Z

0

Try this, using nested array destructuring

res.status(200).json([[rows]]);

You can read this blog to learn more about ES6 - Destructuring

ES6 - Understanding Destructuring

answered Nov 11, 2021 at 17:02

Paulo

7046 silver badges14 bronze badges

Collectives™ on Stack Overflow

How can I return an object instead of an array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related