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 — Heretic Monkey
– Heretic Monkey, Commented Dec 12, 2019 at 16:23

Clarity · Accepted Answer · 2019-12-12 16:22:00Z

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, 2019 at 16:22

answered Dec 12, 2019 at 16:17

Clarity

10.9k2 gold badges27 silver badges38 bronze badges

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

6 Comments

Amar Over a year ago

i want the output in this way ['xyz.in','yyy.in','xyz.in'] i have used your way.

Clarity Over a year ago

Actually, Object.entries isn't even necessary here, Object.values will be enough.

Amar Over a year ago

but it returns 2 times i want only time each value of the office.

Clarity Over a year ago

@Amar then you need to use Set on the inner map to remove duplicates. I've updated the answer.

Amar Over a year ago

is it possible to filter the timestamp and get the timestamp according to that event and store it into the array ?

|

Nina Scholz · Accepted Answer · 2019-12-12 16:37:19Z

0

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);

edited Dec 12, 2019 at 16:37

answered Dec 12, 2019 at 16:23

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

Theodor Golo Hillmann · Accepted Answer · 2019-12-12 16:53:11Z

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, 2019 at 16:53

Theodor Golo Hillmann

531 silver badge5 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related