Creating a new array from JSON object

Question

I am new to JSON and Javascript. I have JSON object as below:

const text = {"recordset": [
    {
        "planned_date": "2020-06-29T00:00:00.000Z",
        "quantity": 9,
    },
    {
        "planned_date": "2020-07-06T00:00:00.000Z",
        "quantity": 12,
    },
    {
        "planned_date": "2020-07-13T00:00:00.000Z",
        "quantity": 13,
    },
    {
        "planned_date": "2020-07-20T00:00:00.000Z",
        "quantity": 9,
    }
 
]};

I tried to create a new array which only take the "quantity" as such but failed miserably:

for (i in text.recordset) {
    for (j in text.recordset[i].quantity) {
        newText += text.recordset[i].quantity[j]
    }
}

What I want is new array as below:

const newText = [9, 12, 13, 9]

You don't have a JSON object, that's an object literal. See https://stackoverflow.com/q/2904131 — Guy Incognito, Jul 27 '20 at 14:26

score 3 · Answer 1 · answered Jul 27 '20 at 14:26

You can make use of .map method in js array.

const text = {"recordset": [
    {
        "planned_date": "2020-06-29T00:00:00.000Z",
        "quantity": 9,
    },
    {
        "planned_date": "2020-07-06T00:00:00.000Z",
        "quantity": 12,
    },
    {
        "planned_date": "2020-07-13T00:00:00.000Z",
        "quantity": 13,
    },
    {
        "planned_date": "2020-07-20T00:00:00.000Z",
        "quantity": 9,
    }
 
]};

var result = text.recordset.map(obj => obj.quantity);
console.log(result);

score 1 · Answer 2 · answered Jul 27 '20 at 14:26

1

text.recordset.map(r => r.quantity)

answered Jul 27 '20 at 14:26

Santiago Cabrera

134
8

Creating a new array from JSON object

2 Answers2