Javascript to Pull Specific Record from JSON Array

Question

I have a JSON array like this:

[{"Name":"Bob", "EmployeeID":1234, "StartDate":"12/01/2011"},
 {"Name":"Jim", "EmployeeID":4432, "StartDate":"01/12/1997"},
 {"Name":"Heather", "EmployeeID":6643, "StartDate":"07/09/2010"}]

How can I use Javascript to find and retrieve the record for Jim, searching by EmployeeID (4432)?

Matthew Sant · Accepted Answer · 2014-11-24 21:16:55Z

6

You can use filter:

var records = [{"Name":"Bob", "EmployeeID":1234, "StartDate":"12/01/2011"},
   {"Name":"Jim", "EmployeeID":4432, "StartDate":"01/12/1997"},
   {"Name":"Heather", "EmployeeID":6643, "StartDate":"07/09/2010"}];

var result = records.filter(function(r) { return r["EmployeeID"] == 4432 })[0]||'No record found';

A search function could be implemented as follows:

function findByEmployeeId(records, employeeId) {
   return records.filter(function(r) { return r["EmployeeID"] == employeeId })[0]||null;
}

In general, if you have any control over the data, I would recommend changing the structure to make your life easier. If you use the following structure you can access the record directly by using records[employeeId]:

{ "1234" : {"Name":"Bob", "EmployeeID":1234, "StartDate":"12/01/2011"},
  "4432" : {"Name":"Jim", "EmployeeID":4432, "StartDate":"01/12/1997"},
  "6643" : {"Name":"Heather", "EmployeeID":6643, "StartDate":"07/09/2010"} }

edited Nov 24, 2014 at 21:16

answered Nov 24, 2014 at 21:05

Matthew Sant

1,63111 silver badges10 bronze badges

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

6 Comments

Sam Greenhalgh Over a year ago

or find() if you can to use ECMAScript 6 developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…

Adam Over a year ago

When I try your function example, the console says "records.filter is not a function..."

stakolee Over a year ago

Not every browser has this yet, but I'd recommend checking out Underscore.js that gives you a lot of search functionality.

Adam Over a year ago

Unfortunately I don't have control over the data... this is being sent as a feed from a different server

Shai Over a year ago

@Adam this would occur if records is not an array, or if you're using IE 8 or lower. If the former, pass an array for records. If the latter, try the polyfill at MDN.

|

fictus · Accepted Answer · 2014-11-24 21:11:40Z

-1

First of all, Your JSON object is incorrect; it's missing two commas. It should be:

[{"Name":"Bob", "EmployeeID":1234, "StartDate":"12/01/2011"},
 {"Name":"Jim", "EmployeeID":4432, "StartDate":"01/12/1997"},
 {"Name":"Heather", "EmployeeID":6643, "StartDate":"07/09/2010"}]

So, you can access EmplyeeID 4432 like this:

var myJSONobject = [{"Name":"Bob", "EmployeeID":1234, "StartDate":"12/01/2011"},
 {"Name":"Jim", "EmployeeID":4432, "StartDate":"01/12/1997"},
 {"Name":"Heather", "EmployeeID":6643, "StartDate":"07/09/2010"}];

function showJSON() {
  alert(myJSONobject[1].EmployeeID);
}

answered Nov 24, 2014 at 21:11

fictus

2862 silver badges5 bronze badges

1 Comment

Shai Over a year ago

OP wants to retrieve the employee by its EmployeeID – this retrieves it by its array index.

Collectives™ on Stack Overflow

Javascript to Pull Specific Record from JSON Array

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related