Grouping the List of json of different types as per their type in c#

Question

I have a json list of Different Type of objects (Schemaless). however, every row contains the Type of the structure. I need to group it as per their type. I need to group this Json. Input is below

 var result =   [{ "firstName":"John", "lastName":"Doe", "Type":"Person" },
    { "fruit":"apple", "Type":"Diet" },
    { "length":100, "width":60, "height":30,, "Type":"Measure" },
    { "firstName":"Shivang", "lastName":"Mittal", "Type":"Person" }]

Expected Output:

    var persons=   [{ "firstName":"John", "lastName":"Doe", "Type":"Person" }, 
                    { "firstName":"Shivang", "lastName":"Mittal", "Type":"Person" }];

    var Diets = [{ "fruit":"apple", "Type":"Diet" }];
    var Measures = [{ "length":100, "width":60, "height":30,, "Type":"" }];

How can i group it based on their Type in c#?

@greenhoorn : Json Iteself, in diff groups. So basically i need to segregate it by type — Shivang MIttal
– Shivang MIttal, Commented Apr 17, 2015 at 11:21
You could make the question clearer... anyhow have a read of stackoverflow.com/questions/27685829/… — BLoB
– BLoB, Commented Apr 17, 2015 at 11:40
Then have a read of using newtonsoft.com/json to achieve grouping stackoverflow.com/questions/1698175/… — BLoB
– BLoB, Commented Apr 17, 2015 at 11:42

Ondrej Svejdar · Accepted Answer · 2015-04-17 12:10:33Z

2

Without using strongly-typed objects/changing schema:

  var jarray = JArray.Parse(@"[{ ""firstName"":""John"", ""lastName"":""Doe"", ""Type"":""Person"" },
{ ""fruit"":""apple"", ""Type"":""Diet"" },
{ ""length"":100, ""width"":60, ""height"":30, ""Type"":""Measure"" },
{ ""firstName"":""Shivang"", ""lastName"":""Mittal"", ""Type"":""Person"" }]");

  var query = jarray
    .GroupBy(g => g["Type"])
    .Select(g => string.Format("var {0}={1};{2}", g.Key, new JArray(g.ToList()), Environment.NewLine));
  string result = string.Join(string.Empty, query);

answered Apr 17, 2015 at 12:10

Ondrej Svejdar

22.2k5 gold badges60 silver badges93 bronze badges

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

Comments

Bondaryuk Vladimir · Accepted Answer · 2015-04-17 11:33:06Z

1

better for you will be change your json format:

{
   "Customer": [{"firstName":"John", "lastName":"Doe", "Type":"Person" }],
   "Fruit": [{"fruit":"apple", "Type":"Diet" }],
   "Length": [{"length":100, "width":60, "height":30, "Type":"Measure" }]
}

and then it will be easy

public class JsonType()
{
    public CustomerType Customer {get; set;}
    public FruitType Fruit {get; set;}
    public LengthType Length {get; set;}
}

public class CustomerType()
{
    public string firstName {get; set;}
    public string lastName {get; set;}
    public string Type {get; set;}
}

public class FruitType()
{
    public string fruit {get; set;}
    public string Type {get; set;}
}

etc...

var result = JsonConvert.DeserializeObject<JsonType>(yourJson);

edited Apr 17, 2015 at 11:33

answered Apr 17, 2015 at 11:25

Bondaryuk Vladimir

5193 silver badges10 bronze badges

1 Comment

Shivang MIttal Over a year ago

nice suggestion. But for that i need to change the end point ( service returning the json ). It will be a time taking work around to change the service

Collectives™ on Stack Overflow

Grouping the List of json of different types as per their type in c#

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related