how to convert array api response to json in JavaScript

Question

I have an api which return data structured like this :

//code return response.status(200).json(startdate)

results data:

[
    "2020-01-16",
    "2020-01-18",
]

i want that this api to return result like this:

Code: 200
Content:
{
    "availableDates": [
      "2017-11-24",
      "2017-11-27"
    ],
    "status": "SUCCESS",
    "message": ""
}

this is my full code where i get the data as array

app.get('/api/getBusyDays',(request, response) =>{
    odoo.connect(function (err) {



        console.log(' OdooStartDate' + dateTimeStartUsed + 'OdooStopdate' + dateTimeEndUsed);
        var params1 = [];
        params1.push(inParams1);

        console.log(' search params '+ JSON.stringify(params1));
        odoo.execute_kw('calendar.event', 'search_read', params1, function (err, value) {
            if (err) { return console.log(err) }
            if(value) {
                if (value.length > 0) {


                    value.forEach(function(a) {
                        a.start_datetime = moment(a.start_datetime).format('YYYY-MM-DD');
                        a.stop_datetime = moment(a.stop_datetime).format('YYYY-MM-DD');
                    });

                    const startdate = [...new Set(value.map(val => val.start_datetime))];

                    startdate.sort();


                   // return response.status(200).json( value)

                    return response.status(200).json(startdate)
                }
            }

So what's the problem?

Sourabh Somani
– Sourabh Somani

2020-01-16 13:58:47 +00:00
Commented Jan 16, 2020 at 13:58 — Sourabh Somani
– Sourabh Somani, Commented Jan 16, 2020 at 13:58
don't know how to convert

user7575848
– user7575848

2020-01-16 14:01:12 +00:00
Commented Jan 16, 2020 at 14:01 — user7575848
– user7575848, Commented Jan 16, 2020 at 14:01

ROOT · Accepted Answer · 2020-01-16 14:40:21Z

2

you can just create an object like this:

let arrVal = [
  "2017-11-24",
  "2017-11-27"
];
// return Object or your framework (Express or KOA or) response Object
console.log({
  "Code": 200,
  "Content": {
    "availableDates": arrVal,
    "status": "SUCCESS",
    "message": ""
  }
})

Update:

Based on the comments on this answer, modify your response so it looks like this:

app.get('/api/getBusyDays',(request, response) =>{
    odoo.connect(function (err) {



        console.log(' OdooStartDate' + dateTimeStartUsed + 'OdooStopdate' + dateTimeEndUsed);
        var params1 = [];
        params1.push(inParams1);

        console.log(' search params '+ JSON.stringify(params1));
        odoo.execute_kw('calendar.event', 'search_read', params1, function (err, value) {
            if (err) { return console.log(err) }
            if(value) {
                if (value.length > 0) {


                    value.forEach(function(a) {
                        a.start_datetime = moment(a.start_datetime).format('YYYY-MM-DD');
                        a.stop_datetime = moment(a.stop_datetime).format('YYYY-MM-DD');
                    });

                    const startdate = [...new Set(value.map(val => val.start_datetime))];

                    startdate.sort();


                   // return response.status(200).json( value)

                    return response.status(200).json({"code": 200, "content": {"availableDates": startdate, "status": "SUCCESS", "message": ""}})
                }
            }

edited Jan 16, 2020 at 14:40

answered Jan 16, 2020 at 14:03

ROOT

11.7k5 gold badges35 silver badges49 bronze badges

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

4 Comments

user7575848 Over a year ago

sorry i reformulated my question maybe it was not clear the idea

ROOT Over a year ago

@Alia do you have access to the API code base? and which framework are you using?

user7575848 Over a year ago

i cant add all the code ...but the idea is that api works well , just i want to have result not like array but json with status inside and message

ROOT Over a year ago

if you want the response to be like this, then you have to modify the response to be an object and change the frontend implementation, response.status(200) only modify the response header status code and it doesn't create an object.

lousybear · Accepted Answer · 2020-01-16 14:44:15Z

1

You can create an empty object and set properties to it and send it as response from ur node api service.

let data = [
    "2017-11-24",
    "2017-11-27"
];

let response = [];
response.data = data;
response.code = 200;
response.status = 'success';
response.message = 'Mission Successful';

return response;

answered Jan 16, 2020 at 14:44

lousybear

4513 silver badges12 bronze badges

Collectives™ on Stack Overflow

how to convert array api response to json in JavaScript

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related