return JSON with nested array for data and heading in NodeJS express

Question

I have a Node.js API that returns JSON formatted like this:

[
    {
        "id" : "1",
        "tstamp": "2017-06-01T00:00:00.000Z",
        "dmemberprofiles","48400"
        "dgroupprofiles","4800"
        "msclprofiles","400"
    },
    {
        "id" : "2",
        "tstamp" : "2017-06-02T00:00:00.000Z",
        "dmemberprofiles","48700"
        "dgroupprofiles","4900"
        "msclprofiles","410
    }
]

How do I make Node.js return the JSON, looking like this:

{
    "header": [
        "id",
        "tstamp",
        "dmemberprofiles",
        "dgroupprofiles",
        "msclprofiles"
    ],
    "data": [
        {
            "id" : "1",
            "tstamp" : "2017-06-01T00:00:00.000Z",
            "dmemberprofiles","48400"
            "dgroupprofiles","4800"
            "msclprofiles","400"
        },
        {
            "id" : "2",
            "tstamp" : "2017-06-02T00:00:00.000Z",
            "dmemberprofiles","48700"
            "dgroupprofiles","4900"
            "msclprofiles","410
        }           
    ]
}

I've looked around for other examples but haven't found a Node.js-specific solution.

Possible duplicate of Get array of object's keys

str
– str

2017-06-10 15:39:08 +00:00
Commented Jun 10, 2017 at 15:39 — str
– str, Commented Jun 10, 2017 at 15:39

Nina Scholz · Accepted Answer · 2017-06-10 15:29:10Z

1

You could take the keys from the first object of the array with Object.keys.

var array = [{ id: "1", tstamp: "2017-06-01T00:00:00.000Z", dmemberprofiles: 48400, dgroupprofiles: 4800, msclprofiles: 400 }, { id: "2", tstamp: "2017-06-02T00:00:00.000Z", dmemberprofiles: 48700, dgroupprofiles: 4900, msclprofiles: 410 }],
    object = { header: Object.keys(array[0]), data: array };

console.log(object);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Jun 10, 2017 at 15:29

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

Comments

Julian Goacher · Accepted Answer · 2017-06-10 15:25:29Z

0

Assuming

var data = [
    {
        "id" : "1",
        "tstamp": "2017-06-01T00:00:00.000Z",
        "dmemberprofiles","48400"
        "dgroupprofiles","4800"
        "msclprofiles","400"
    },
    {
        "id" : "2",
        "tstamp" : "2017-06-02T00:00:00.000Z",
        "dmemberprofiles","48700"
        "dgroupprofiles","4900"
        "msclprofiles","410
    }
]

then just do:

// Add data to wrapper
var wrapper = {
    "header": [
        "id",
        "tstamp",
        "dmemberprofiles",
        "dgroupprofiles",
        "msclprofiles"
    ],
    "data": data
}

// Convert to JSON
var json = JSON.stringify( wrapper );

answered Jun 10, 2017 at 15:25

Julian Goacher

5672 silver badges6 bronze badges

1 Comment

user3442693 Over a year ago

Yes, this one with the wrapper was integrated and proven to work well.

Collectives™ on Stack Overflow

return JSON with nested array for data and heading in NodeJS express

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related