How to get value from array of object

Question

I'm learning Node.js and using mssql to retrieve employee data. I get the following recordset back and having trouble grab the first and last name:

{ recordsets: [ [ [Object] ] ],
  recordset: [ { uid: 'jd123', fName: 'John', lName: 'Doe' } ],
  output: {},
  rowsAffected: [ 1 ] 
}

I have tried the following but had no luck:

D:\LearnNodeJs\Udemy\routes\processes.js

// var submitter = recordset[0]['fName']; // TypeError: Cannot read property 'fName' of undefined
                               ^
//var submitter = recordset[0].fName; // TypeError: Cannot read property 'fName' of undefined
var submitter = recordset.fName; // undefined

console.log(submitter);

recordset is a property of some object, what is the object name — Jaromanda X
– Jaromanda X, Commented Jan 17, 2018 at 0:50

Bergur · Accepted Answer · 2018-01-17 01:04:12Z

1

Seems you are doing it right

https://jsfiddle.net/9co7wf5t/

const response = {
    recordsets: [ [ [Object] ] ],
  recordset: [ { uid: 'jd123', fName: 'John', lName: 'Doe' } ],
  output: {},
  rowsAffected: [ 1 ] 
};

console.log(response.recordset[0].fName);

answered Jan 17, 2018 at 1:04

Bergur

4,07714 silver badges21 bronze badges

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

1 Comment

user752746 Over a year ago

Although the suggestion above worked I accepted this method because it easier to use in my opinion. Thank you Bergur!

HolyMoly · Accepted Answer · 2018-01-17 01:05:07Z

0

what is the name of your object? try:

const firstNames = someObject.recordset.map(record => record.fName) to get the first name(s). modify on that as needed to get what you want.

answered Jan 17, 2018 at 1:05

HolyMoly

2,0903 gold badges26 silver badges38 bronze badges

2 Comments

user752746 Over a year ago

Hi, HolyMoly, thanks for your repsonse. The object is data.

user752746 Over a year ago

Thank you, I was able to get the first name back with the following code. const firstNames = data.recordset.map(data => data.fName); console.log(firstNames);

Collectives™ on Stack Overflow

How to get value from array of object

2 Answers 2

1 Comment

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Related