How to convert dynamic JSON to C# object

Question

I am trying to convert below JSON object to C# class. I could able to get C# equivalent for filter, but not for sort.

In the case of filter JSON object; andOr, openCondition, etc are static. Hence, I could able to generate C# class.

But for sort JSON object; accountName, and tradeDate are not static. These fields are completely as per user requirement. They may change as some other fields for some other input. Hence, I'm not understanding how can I generate C# class for this sort JSON object. Can anyone please suggest me how to do this?

{
    "filter": [
        {
            "andOr": "",
            "openCondition": false,
            "columnName": "accountName",
            "operator": "eq",
            "value": "KATHERINE",
            "closeCondition": false
        }
    ],
    "sort": {
            "accountName": "asc",
            "tradeDate": "desc"       
    },
    "pageIndex": 1,
    "pageSize": 75
}

I have tried to create SortCriteria class like below. But, it is not matching to the JSON sort object.

public class SortCriteria
{
    public string ColumnName { get; set; }
    public string SortOrder { get; set; }
}

Can anyone please suggest me how can I solve this issue.

That is why you have newtonsoft package

Bosco
– Bosco

2019-10-05 09:58:19 +00:00
Commented Oct 5, 2019 at 9:58 — Bosco
– Bosco, Commented Oct 5, 2019 at 9:58

Anu Viswan · Accepted Answer · 2019-10-05 10:12:25Z

1

You could use a Dictionary (with JsonExtensionDataAttribute) for cases where properties are NOT fixed, such as in Sort. For example,

public class Filter
{
    public string andOr { get; set; }
    public bool openCondition { get; set; }
    public string columnName { get; set; }
    public string @operator { get; set; }
    public string value { get; set; }
    public bool closeCondition { get; set; }
}

public class Sort
{
    [JsonExtensionData]
    public Dictionary<string,object> RandomKeyValuePair {get;set;}
}

public class RootObject
{
    public List<Filter> filter { get; set; }
    public Sort sort { get; set; }
    public int pageIndex { get; set; }
    public int pageSize { get; set; }
}

Sample Output

edited Oct 5, 2019 at 10:12

answered Oct 5, 2019 at 9:47

Anu Viswan

18.2k4 gold badges27 silver badges53 bronze badges

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

Comments

Prasad Telkikar · Accepted Answer · 2019-10-05 09:59:55Z

1

If your json properties are not fixed and it may change over the time then instead of creating a separate class you can use dynamic.

Like,

string jsonString = @"{
    sort: {
      accountName: 'asc',
      tradeDate: 'desc'       
    }
}";


JObject obj = JObject.Parse(jsonString);
Console.WriteLine($"AccountNumber: {obj["sort"]["accountName"]}");

using Json path,

Console.WriteLine($"AccountNumber: {obj.SelectToken("$.sort.accountName")}");

.Net Fiddle

edited Oct 5, 2019 at 9:59

answered Oct 5, 2019 at 9:54

Prasad Telkikar

16.1k7 gold badges26 silver badges49 bronze badges

Comments

Sir Rufo · Accepted Answer · 2019-10-05 10:41:15Z

1

You can deserialize any JSON object into a Dictionary<string,object> or if you know the value type you can use that value type instead of object.

In this case the sort value will only be "asc" or "desc" so we can use a string or (better) an enum

public enum SortDirection
{
    Asc,
    Desc,
}

The class would look like

public class Data
{
    ...
    [JsonProperty( "sort" )]
    public Dictionary<string,SortDirection> Sort { get; set; }
    ...
}

a minimal example

var json = "{\"sort\":{\"accountName\":\"asc\",\"tradeDate\":\"desc\"}}";
var obj = JsonConvert.DeserializeObject<Data>(json);

.net fiddle example

answered Oct 5, 2019 at 10:41

Sir Rufo

19.3k3 gold badges47 silver badges79 bronze badges

2 Comments

Ashok kumar Over a year ago

Thank you for your answer. "Anu Viswan" answer worked well for me, hence, marked as accepted answer. Your suggestion is also valuable. Hence, given up-vote. I have not yet verified your suggestion, but looks like nice approach.

Sir Rufo Over a year ago

The verification is very simple: click on the .net fiddle link in the answer and see the working code sample in your browser ;o)

Collectives™ on Stack Overflow

How to convert dynamic JSON to C# object

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related