Mapping object key : value pair to array of object arrays for JSON

Question

I'm trying to convert the following array into something JSON can understand and be able to append the same key/value pair to each array of objects, but I'm getting stuck on how to go about it.

Given the following array of objects:

{
  "array": [
    {
      "Type": "Current",
      "Item1": "3",
      "Item2": "23",
      "Item3": "90",
      "Item4": null,
      "Year": "2019",
      "Amount": "100"
    },
    {
      "Type": "Current",
      "Item1": "3",
      "Item2": "23",
      "Item3": "90",
      "Item4": null,
      "Year": "2020",
      "Amount": "200"
    },
    {
      "Type": "Current",
      "Item1": "3",
      "Item2": "23",
      "Item3": "90",
      "Item4": null,
      "Year": "2021",
      "Amount": "300"
    },
    {
      "Type": "Change",
      "Item1": null,
      "Item2": null,
      "Item3": null,
      "Item4": null,
      "Year": "2019"
    },
    {
      "Type": "Change",
      "Item1": null,
      "Item2": null,
      "Item3": null,
      "Item4": null,
      "Year": "2020",
      "Amount": ""
    },
    {
      "Type": "Change",
      "Item1": null,
      "Item2": null,
      "Item3": null,
      "Item4": null,
      "Year": "2021",
      "Amount": ""
    }
  ]
}

I need to add the following to each array:

{Title : "title", id : "idNum"}

So that it reads like:

{
  "Title": "title",
  "ID": "idNum",
  "Type": "Current",
  "Item1": "3",
  "Item2": "23",
  "Item3": "90",
  "Item4": null,
  "Year": "2019",
  "Amount": "100"
},
{
  "Title": "title",
  "ID": "idNum",
  "Type": "Current",
  "Item1": "3",
  "Item2": "23",
  "Item3": "90",
  "Item4": null,
  "Year": "2020",
  "Amount": "200"
},

etc.

I'm not even sure if this is actually an array of object arrays, as I'm admittedly guessing a bit on the terminology. Eventually, I need this to be able to be processed as a JSON object for submitting to a SharePoint list using AJAX.

Would I need to loop through each array within the array and then add the object key/value pairs?

Yes, this is in fact an array of objects

SpeedOfRound
– SpeedOfRound

2018-11-26 21:15:28 +00:00
Commented Nov 26, 2018 at 21:15 — SpeedOfRound
– SpeedOfRound, Commented Nov 26, 2018 at 21:15

Akrion · Accepted Answer · 2018-11-26 21:14:02Z

5

You can use Array.map and spread and not mutate the original array:

const data = { "array": [ { "Type": "Current", "Item1": "3", "Item2": "23", "Item3": "90", "Item4": null, "Year": "2019", "Amount": "100" }, { "Type": "Current", "Item1": "3", "Item2": "23", "Item3": "90", "Item4": null, "Year": "2020", "Amount": "200" }, { "Type": "Current", "Item1": "3", "Item2": "23", "Item3": "90", "Item4": null, "Year": "2021", "Amount": "300" }, { "Type": "Change", "Item1": null, "Item2": null, "Item3": null, "Item4": null, "Year": "2019" }, { "Type": "Change", "Item1": null, "Item2": null, "Item3": null, "Item4": null, "Year": "2020", "Amount": "" }, { "Type": "Change", "Item1": null, "Item2": null, "Item3": null, "Item4": null, "Year": "2021", "Amount": "" } ] } 

result = data.array.map(x => ({ Title: 'Title', ID: 'idNum', ...x}))

console.log(result)

answered Nov 26, 2018 at 21:14

Akrion

18.6k1 gold badge38 silver badges58 bronze badges

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

1 Comment

BWieland86 Over a year ago

Awesome, thank you! I was trying something like below, but this works much faster! $(jsonAmountData["array"].each(function( index ) { jsonAmountData["array"][index].Title = "title"; jsonAmountData["array"][index].ID = "idNum"; };

Collectives™ on Stack Overflow

Mapping object key : value pair to array of object arrays for JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related