Add sorted json back to json object

Question

How to add sorted json('sortedJson') back to the whole json('jObj') below? Or is there an alternative to do the below?

 Json:
        {
          "Information": [
            {
              "FieldName": "Area04",
              "Draft": "Unknown",
            },
            {
              "FieldName": "Area02",
              "Draft": "Unknown",
            },
            {
              "FieldName": "Area01",
              "Draft": "Unknown",
            },
            {
              "FieldName": "Area03",
              "Draft": "Unknown",
            }
          ],
          "OtherInfo": []
        }


    Code:     
        static void Main(string[] args)
          {
            string _json = "{'Information': [{'FieldName': 'Area04','Draft': 'Unknown'},{'FieldName': 'Area02','Draft': 'Unknown'},{'FieldName': 'Area01','Draft': 'Unknown'},{'FieldName': 'Area03','Draft': 'Unknown'}],'OtherInfo': []}";
            var jObj = JsonConvert.DeserializeObject<Informat>(_json);
            var test1 = jObj.Information.OrderBy(x => x.FieldName);
            var sortedJson = JsonConvert.SerializeObject(test1);
           //Add code to merge 'sortedJson' to '_json'
          }
    
    Class:
    public class Informat
    {
        public Information[] Information { get; set; }
        public object[] OtherInfo { get; set; }
    }
    
    public class Information
    {
        public string FieldName { get; set; }
        public string Draft { get; set; }
    }

I dont know how to add the sorted json back to whole json. Could you please help me with this?

Just set the ordered output back into your class and deserialise the entire object back to JSON. So jObj.Information = test1.ToArray(); _json = JsonConvert.SerializeObject(jObj); — DavidG
– DavidG, Commented Jul 6, 2021 at 11:46
@DavidG - Thanks David! Yep! I should have though about this.Works fine. — DeSon
– DeSon, Commented Jul 6, 2021 at 11:53
@DavidG - My solution to sort doesn`t work when the string & number combination is more than 5 chars. Could you help? — DeSon
– DeSon, Commented Jul 6, 2021 at 14:44
Not sure what you mean. Sorting is sorting, it has nothing to do with how long the fields are. — DavidG
– DavidG, Commented Jul 6, 2021 at 15:21

oRoiDev · Accepted Answer · 2021-07-06 12:04:52Z

2

Here's an example using Array.Sort()

var jObj = JsonConvert.DeserializeObject<Informat>(_json);
Array.Sort(jObj.Information, (x, y) => x.FieldName.CompareTo(y.FieldName));
var sortedJson = JsonConvert.SerializeObject(jObj);

answered Jul 6, 2021 at 12:04

oRoiDev

3591 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Add sorted json back to json object

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related