Convert nested [Array] of {Object} to > {Object} | JSON File

Question

I am new to JSON data manipulation and I would like some help.

I have a JSON file that looks like the below:

[
  {
    "plannification": {
      "Data": 1,
      "DataType": "GB",
      "InclusionOption1": ".",
      "Default": false,
      "PropositionId": "GBT13456",
      "EssentialLink": "greatpdf.com/pdf.pdf",
      "Term": "1",
      "Segment": "part",
      "Id": "653284",
    }
  },
  {
    "plannification": {
      "Data": 1,
      "DataType": "FR",
      "inclusionOption1": ".",
      "default": false,
      "PropositionId": "FRT13456",
      "EssentialLink": "greatpdf.com/pdf2.pdf",
      "term": "1",
      "Segment": "pro",
      "Id": "984532",
    }
  }
]

I'd like to to convert this file to object and only pull data from "Segment": “pro”, as below:

    {
      984532:{
      Segment: "pro",
      EssentialLink: "greatpdf.com/pdf.pdf",
      PropositionId: "FRT13456",
     },
      etc.. {},
}

Where do I start?

your json is not valid. format it correctly the way you want. — izengod
– izengod, Commented Feb 27, 2018 at 5:27

Hassan Imam · Accepted Answer · 2018-02-27 05:33:06Z

1

You can filter your array using array#filter on the Segment where the value is pro. You can use array#reduce and iterate through the array and using Object#values() take out the values of each object and create your new object.

const data = [{ "plannification": { "Data": 1, "DataType": "GB", "InclusionOption1": ".", "Default": false, "PropositionId": "GBT13456", "EssentialLink": "greatpdf.com/pdf.pdf", "Term": "1", "Segment": "part", "Id": "653284" } }, { "plannification": { "Data": 1, "DataType":"FR", "inclusionOption1": ".", "default": false, "PropositionId": "FRT13456", "EssentialLink": "greatpdf.com/pdf2.pdf", "term": "1", "Segment": "pro", "Id": "984532", } } ],
      result = data.filter(o => {
        let { Segment } = Object.values(o)[0];
        return Segment === 'pro';
      }).reduce((r,o) => {
        let { Id, Segment, PropositionId, EssentialLink } = Object.values(o)[0];
        r[Id] = { Segment, PropositionId, EssentialLink };
        return r;
      },{})
console.log(result);

edited Feb 27, 2018 at 5:33

answered Feb 27, 2018 at 5:26

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

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

2 Comments

Tyfab Over a year ago

Great! thank you so much. This is exactly what I am looking for. Now I'll find how to pull from a file

Hassan Imam Over a year ago

Using Javascript, you can refer to this

jonhid · Accepted Answer · 2018-02-27 05:25:32Z

0

1 - Read the json file

2 - Iterate over the array of objects

3 - For every object, check your desired property

4 - If it matchs what you want, read the properties of the object and construct your object

answered Feb 27, 2018 at 5:25

jonhid

2,1451 gold badge14 silver badges18 bronze badges

Comments

user6722263 · Accepted Answer · 2018-02-27 05:26:22Z

0

your data structure is not valid, at first correct the way you've written your json array of object so that i can figure out

answered Feb 27, 2018 at 5:26

user6722263

1 Comment

Tyfab Over a year ago

This is unfortunately from an API, I cannot change the structure

Collectives™ on Stack Overflow

Convert nested [Array] of {Object} to > {Object} | JSON File

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related