looping JSON in node JS with no ARRAY

Question

I have a response from API where JSON is not in an array, something like below

{
  "TV": {
    "USD": 9677.25,
    "EUR": 7768.87,
    "JPY": 1072773.87,
    "GBP": 6898.93,
    "AUD": 12294.15,
    "CAD": 12056.19
},
 "Lamp": {
    "USD": 231.35,
    "EUR": 185.89,
    "JPY": 25735.85,
    "GBP": 168.82,
    "AUD": 296.7,
    "CAD": 283
  }
}

if it is array I can use .map function, but in this scenario how can I display data while looping it as data coming from API might be different on every call.

desired format that i am looking for is

[{
    "PRODUCT": "TV",
    "PRICE": {
        "USD": 9677.25,
        "EUR": 7768.87,
        "JPY": 1072773.87,
        "GBP": 6898.93,
        "AUD": 12294.15,
        "CAD": 12056.19
    }
}, {
    "PRODUCT": "Lamp",
    "PRICE": {
        "USD": 231.35,
        "EUR": 185.89,
        "JPY": 25735.85,
        "GBP": 168.82,
        "AUD": 296.7,
        "CAD": 283
    }
}]

Please help..

What is the desired output?

Hassan Imam
– Hassan Imam

2018-02-15 04:31:31 +00:00
Commented Feb 15, 2018 at 4:31 — Hassan Imam
– Hassan Imam, Commented Feb 15, 2018 at 4:31
@HassanImam I want to convert above mention JSON to array

socialCoder
– socialCoder

2018-02-15 06:18:21 +00:00
Commented Feb 15, 2018 at 6:18 — socialCoder
– socialCoder, Commented Feb 15, 2018 at 6:18
Please update the question with the desired format.

Hassan Imam
– Hassan Imam

2018-02-15 06:19:24 +00:00
Commented Feb 15, 2018 at 6:19 — Hassan Imam
– Hassan Imam, Commented Feb 15, 2018 at 6:19
@HassanImam updated.

socialCoder
– socialCoder

2018-02-15 06:30:26 +00:00
Commented Feb 15, 2018 at 6:30 — socialCoder
– socialCoder, Commented Feb 15, 2018 at 6:30

Hassan Imam · Accepted Answer · 2018-02-15 06:33:46Z

1

You can use Object.keys() to iterate through each key of your data and then using array#map, you can create a resultant array with your objects.

var data = { "TV": { "USD": 9677.25, "EUR": 7768.87, "JPY": 1072773.87, "GBP": 6898.93, "AUD": 12294.15, "CAD": 12056.19 }, "Lamp": { "USD": 231.35, "EUR": 185.89, "JPY": 25735.85, "GBP": 168.82, "AUD": 296.7, "CAD": 283 } },
  result = Object.keys(data).map(k => ({PRODUCT: k, PRICE: data[k]}));
console.log(result);

answered Feb 15, 2018 at 6:33

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

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

Comments

FuriousD · Accepted Answer · 2018-02-15 05:11:08Z

0

You can retrieve the keys for the top level properties of the JSON object.

var payload = {
  "TV": {
    "USD": 9677.25,
    "EUR": 7768.87,
    "JPY": 1072773.87,
    "GBP": 6898.93,
    "AUD": 12294.15,
    "CAD": 12056.19
},
 "Lamp": {
    "USD": 231.35,
    "EUR": 185.89,
    "JPY": 25735.85,
    "GBP": 168.82,
    "AUD": 296.7,
    "CAD": 283
  }
}

var keys = Object.keys(payload)

Now you can map over these keys and use them to reference the payload. So for example if you wanted to create an array with the USD cost of each item.

var usdCost = keys.map(function (key) {
  return {
    item: key,
    usd: payload[key].USD
  }
})

// [{
//   item: "TV",
//   usd: 9677.25
// }, {
//   item: "Lamp",
//   usd: 231.35
// }]

edited Feb 15, 2018 at 5:11

answered Feb 15, 2018 at 4:35

FuriousD

8545 silver badges16 bronze badges

Collectives™ on Stack Overflow

looping JSON in node JS with no ARRAY

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