how to convert json array to object rest api on express

Question

i tested rest api using postman and the result

{
    "success": true,
    "message": "success",
    "data": [
        {
            "id_buku": 9,
            "judul_buku": "xxxxxx",
        }
    ]
}

I want "data" : {...} but the result is "data" : [{...}]

i am using express node.js to develop rest api

getDataBukuByID(req,res){
    let id = req.params.id;
    pool.getConnection(function(err, connection) {
        if (err) throw err;
        connection.query(
            `
            SELECT * FROM buku WHERE id_buku = ?;
            `
        , [id],
        function (error, results) {
            if(error) throw error;

            res.send({
                success: true,
                message: 'success',
                data: results
            });
        });
        connection.release();
    })
},

what code should be changed?

You can get the object from the array response.data[0]

DecPK
– DecPK

2021-06-16 04:18:12 +00:00
Commented Jun 16, 2021 at 4:18 — DecPK
– DecPK, Commented Jun 16, 2021 at 4:18

Tony George · Accepted Answer · 2021-06-16 04:33:24Z

1

hi bro actually what do you mean..? if you want value in an object you can use data.id_buku to get the value '9

answered Jun 16, 2021 at 4:33

Tony George

1261 silver badge16 bronze badges

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

Comments

S Ahmed Naim · Accepted Answer · 2021-06-16 05:50:05Z

1

res.send({
    success: true,
    message: 'success',
    data: results
});

On the data key, you have assigned the variable named results which is returning by the callback function. As it is returning as an array of objects, so this is why the final output on that property is returning as array of object. The result must be always array of objects if it returns one more collection of data. Otherwise return single row to get an specific object as well.
You can use LIMIT on your mysql query to fetch single data. Then just return that row as an object.

answered Jun 16, 2021 at 5:50

S Ahmed Naim

3041 silver badge9 bronze badges

Collectives™ on Stack Overflow

how to convert json array to object rest api on express

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