How to merge two Javascript objects by key value

Question

I need to merge two Javascript objects by its key value mapping.

Here is my first Javascript object

var json1= [
    { ID: 1, limit: 5, name: "foo" }, 
    { ID: 2, limit: 9, name: "dog" }

   ];

Here is my second Javascript object

 var json2 = [
        { ID: 2, validate: false, LastRunTime: "February" }, 
        { ID: 1, validate: true, LastRunTime: "January" }
    ];
 $.extend(true, {}, json1, json2);

this gives me the resultant Javascript like this

[
    {
        {
            ID: 2,
            LastRunTime: "February",
            limit: 5,
            name: "foo",
            validate: false
        },
        {
            ID: 1,
            LastRunTime: "January",
            limit: 9,
            name: "dog",
            validate: true
        }
    }
]

but I am looking for the code that map ID as a key and then merge the Javascript objects like this irrespective of their order in array.

[
    {
        {
            ID: 1,
            LastRunTime: "January",
            limit: 5,
            name: "foo",
            validate: true
        },
        {
            ID: 2,
            LastRunTime: "February",
            limit: 9,
            name: "dog",
            validate: false
        }
    }
]

What do you want to happen if the merge has a conflict (e.g. each object has a conflicting value for a key)? — jfriend00
– jfriend00, Commented May 8, 2014 at 6:25
Your resulting JSON is not a possible Javascript object. You can't have { { in an object. — Barmar
– Barmar, Commented May 8, 2014 at 6:26

3y3 · Accepted Answer · 2014-05-08 06:29:22Z

2

You need to switch the data representation. The best will be to store your json as:

var json1 = {
    "1": { ID: 1, limit: 5, name: "foo" }, 
    "2": { ID: 2, limit: 9, name: "dog" }
};

If it's impossible then you can convert your data on the fly:

var json1obj = {};
json1.forEach(function(obj) {
  json1obj[obj.ID] = obj;
});
var json2obj = ...;

$.extend(true, {}, json1obj, json2obj);

answered May 8, 2014 at 6:29

3y3

8021 gold badge6 silver badges18 bronze badges

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

Comments

Barmar · Accepted Answer · 2014-05-08 06:43:47Z

0

var result = [];
for (var i = 0; i < json1.length; i++) {
    var found = false;
    for (var j = 0; j < json2.length; j++) {
        if (json1[i].ID == json2[j].ID) {
            result.push($.extend(true, {}, json1[i], json2[j]));
            found = true;
            break;
        }
    }
    if (!found) {
        // If no match found in json2, put a copy in the result
        result.push($.extend(true, {}, json1[i]));
    }
}

edited May 8, 2014 at 6:43

answered May 8, 2014 at 6:23

Barmar

789k57 gold badges554 silver badges669 bronze badges

3 Comments

Gokul Over a year ago

what does break outer means

Barmar Over a year ago

Sorry, that should just be break. I originally had it breaking the outer loop, and had a label outer: before that. But then I realized I needed to add the code at the bottom that puts a copy of json1[i] in the result if the inner loop doesn't find anything.

Gokul Over a year ago

thanks barmar and also result.push($.extend(true, {}, json1[i], json2[j]));

Collectives™ on Stack Overflow

How to merge two Javascript objects by key value

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related