Iterating through object Where Value is Array of Objects and return one value from each Objects of Array of Objects

Question

How to get all the office values from this and store it as a simple array?

var data = {
  'XYZ': [{
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'processed',
      timestamp: '02-12-2019 00:15:32'
    }
  ],
  'yyy': [{
      office: 'yyy.in',
      reportName: 'payroll',
      event: 'delivered',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'yyy.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:32'
    }
  ],
  'zzz': [{
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'delivered',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:32'
    }
  ]
}

The output should be like:

officesArray = ['xyz.in', 'yyy.in', 'xyz.in']

my code is

var Office = (Object.entries(grpDatas).flatMap(([k, v]) => (v.forEach(({office})=> office))))

It prints array of undefined.

Does this answer your question? [From an array of objects, extract value of a property as array](https://stackoverflow.com/questions/19590865/from-an-array-of-objects-extract-value-of-a-property-as-array) — Heretic Monkey, Dec 12 '19 at 16:23

Clarity · Accepted Answer · 2019-12-12T16:22:00.503

2

Use map instead of forEach and also you're accessing email instead of office:

var data = {
  'XYZ': [{
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'processed',
      timestamp: '02-12-2019 00:15:32'
    }
  ],
  'yyy': [{
      office: 'yyy.in',
      reportName: 'payroll',
      event: 'delivered',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'yyy.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:32'
    }
  ],
  'zzz': [{
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'delivered',
      timestamp: '02-12-2019 00:15:29'
    },
    {
      office: 'xyz.in',
      reportName: 'payroll',
      event: 'open',
      timestamp: '02-12-2019 00:15:32'
    }
  ]
}

var Email = Object.values(data).flatMap(item => [...new Set(item.map(({office})=> office))])
console.log(Email)

edited Dec 12 '19 at 16:22

answered Dec 12 '19 at 16:17

Clarity

10,730
2
25
35

i want the output in this way ['xyz.in','yyy.in','xyz.in'] i have used your way. – Amar Dec 12 '19 at 16:19
Actually, `Object.entries` isn't even necessary here, `Object.values` will be enough. – Clarity Dec 12 '19 at 16:21
but it returns 2 times i want only time each value of the office. – Amar Dec 12 '19 at 16:21
@Amar then you need to use `Set` on the inner map to remove duplicates. I've updated the answer. – Clarity Dec 12 '19 at 16:24
is it possible to filter the timestamp and get the timestamp according to that event and store it into the array ? – Amar Dec 14 '19 at 18:09
@Amar instead of returning just `office`, you'll need to return office and timestamp. – Clarity Dec 15 '19 at 12:19

Nina Scholz · Answer 2 · 2019-12-12T16:37:19.187

You could get unique values from the wanted properties.

var data = { XYZ: [{ office: 'xyz.in', reportName: 'payroll', event: 'open', timestamp: '02-12-2019 00:15:29' }, { office: 'xyz.in', reportName: 'payroll', event: 'processed', timestamp: '02-12-2019 00:15:32' }], yyy: [{ office: 'yyy.in', reportName: 'payroll', event: 'delivered', timestamp: '02-12-2019 00:15:29' }, { office: 'yyy.in', reportName: 'payroll', event: 'open', timestamp: '02-12-2019 00:15:32' }], zzz: [{ office: 'xyz.in', reportName: 'payroll', event: 'delivered', timestamp: '02-12-2019 00:15:29' }, { office: 'xyz.in', reportName: 'payroll', event: 'open', timestamp: '02-12-2019 00:15:32' }] },
    office = Object.values(data).flatMap(v => [...new Set(v.map(({ office }) => office))]);

console.log(office);

score 0 · Answer 3 · answered Dec 12 '19 at 16:53

0

const result = Object.keys(data) .map( key => data[key]) .flat() .map( element => element.office)

Transforming everything to arrays and flattening them helps a lot!

https://codepen.io/t0dorakis/pen/MWYerKL

answered Dec 12 '19 at 16:53

Theodor Golo Hillmann

53
1
5

Iterating through object Where Value is Array of Objects and return one value from each Objects of Array of Objects

3 Answers3