How to send json result as a Dictionary instead of Array in expressjs

Question

I want to send response as a dictionary like this:

{
    "id": 5928101,
    "category": "animal welfare",
    "organizer": "Adam",
    "title": "Cat Cabaret",
    "description": "Yay felines!",
    "location": "Meow Town",
    "date": "2019-01-03T21:54:00.000Z",
    "time": "2:00",
}

But I am using bellow code, which results an array

var ress = JSON.stringify(sqlResults)
console.log('response json:' + ress)
res.send(ress)

The resulted array has brackets [] like this:

[
    {
        "id": 5928101,
        "category": "animal welfare",
        "organizer": "Adam",
        "title": "Cat Cabaret",
        "description": "Yay felines!",
        "location": "Meow Town",
        "date": "2019-01-03T21:54:00.000Z",
        "time": "2:00",
    }
]

How can I send result without a third bracket?

Terry Lennox · Accepted Answer · 2021-09-16 12:08:55Z

1

If you return the first element of your sqlResults array you should get the result you wish.

You should also be able to use res.json(dict) to send your result to the client.

sqlResults = [
    {
        "id": 5928101,
        "category": "animal welfare",
        "organizer": "Adam",
        "title": "Cat Cabaret",
        "description": "Yay felines!",
        "location": "Meow Town",
        "date": "2019-01-03T21:54:00.000Z",
        "time": "2:00",
    }
];

const dict = sqlResults[0];
var ress = JSON.stringify(dict, null, 2)
console.log('response json:' + ress)

// You can then send using res.send(ress);
// Or simply res.json(dict);

edited Sep 16, 2021 at 12:08

answered Sep 16, 2021 at 11:55

Terry Lennox

30.9k5 gold badges36 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

How to send json result as a Dictionary instead of Array in expressjs

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