Merge two Json.NET arrays by concatenating contained elements

Question

I have two JToken's that represent JSON arrays of objects and I would like to merge them. JToken has a method Concat but it produces null as result when I try to use it.

Action<JToken> Ok = (x) =>
{
    Debug.WriteLine(x);
    /* outputs
    [
      {
        "id": 1,
      },
      {
        "id": 2,
      }
    ]
    */

    x = (x).Concat<JToken>(x) as JToken;
    Debug.WriteLine(x); // null
};

How can I make it work?

Can you please show how you use the Concat method by providing your code + sample data? — GameScripting
– GameScripting, Commented Jan 2, 2013 at 11:25
@GameScripting well the code is right here in question, specifically the line x = (x).Concat<JToken>(x) as JToken. UPD: can you see the code block I've provided? — src091
– src091, Commented Jan 2, 2013 at 11:27
I don't know Json.Net, but concat is usually for joining two strings. I would expect a merge or union function would be more applicable. Does such a thing exist? — Smudge202
– Smudge202, Commented Jan 2, 2013 at 11:53

theDmi · Accepted Answer · 2016-08-11 05:33:35Z

34

Use JContainer.Merge() with MergeArrayHandling.Concat.

This is available starting with Json.NET 6 Release 4. So if your arrays are in a JContainer (e.g. a JObject), this is a simple and robust solution.

Example:

JObject o1 = JObject.Parse(@"{
  'FirstName': 'John',
  'LastName': 'Smith',
  'Enabled': false,
  'Roles': [ 'User' ]
}");
JObject o2 = JObject.Parse(@"{
  'Enabled': true,
  'Roles': [ 'Operator', 'Admin' ]
}");

o1.Merge(o2, new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Concat });

string json = o1.ToString();
// {
//   "FirstName": "John",
//   "LastName": "Smith",
//   "Enabled": true,
//   "Roles": [
//     "User",
//     "Operator",
//     "Admin"
//   ]
// }

edited Aug 11, 2016 at 5:33

answered Dec 16, 2014 at 10:24

theDmi

18.1k8 gold badges76 silver badges140 bronze badges

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

Comments

src091 · Accepted Answer · 2013-01-02 13:26:15Z

9

JToken.FromObject(x.Concat(x))

answered Jan 2, 2013 at 13:26

src091

2,8677 gold badges45 silver badges75 bronze badges

Comments

Anthony Johnston · Accepted Answer · 2013-06-14 08:06:08Z

I needed same, here's what I came up with

https://github.com/MrAntix/Newtonsoft.Json/blob/master/Src/Newtonsoft.Json/Linq/MergeExtensions.cs

public static void MergeInto(
    this JContainer left, JToken right, MergeOptions options)
{
    foreach (var rightChild in right.Children<JProperty>())
    {
        var rightChildProperty = rightChild;
        var leftPropertyValue = left.SelectToken(rightChildProperty.Name);

        if (leftPropertyValue == null)
        {
            // no matching property, just add 
            left.Add(rightChild);
        }
        else
        {
            var leftProperty = (JProperty) leftPropertyValue.Parent;

            var leftArray = leftPropertyValue as JArray;
            var rightArray = rightChildProperty.Value as JArray;
            if (leftArray != null && rightArray != null)
            {
                switch (options.ArrayHandling)
                {
                    case MergeOptionArrayHandling.Concat:

                        foreach (var rightValue in rightArray)
                        {
                            leftArray.Add(rightValue);
                        }

                        break;
                    case MergeOptionArrayHandling.Overwrite:

                        leftProperty.Value = rightChildProperty.Value;
                        break;
                }
            }

            else
            {
                var leftObject = leftPropertyValue as JObject;
                if (leftObject == null)
                {
                    // replace value
                    leftProperty.Value = rightChildProperty.Value;
                }

                else
                    // recurse object
                    MergeInto(leftObject, rightChildProperty.Value, options);
            }
        }
    }
}

left.SelectToken(rightChildProperty.Name); should be left[rightChildProperty.Name]; ... at least in my case (4.0 R8)

Collectives™ on Stack Overflow

Merge two Json.NET arrays by concatenating contained elements

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related