JObject.Parse c#

Question

Im trying to parse my class to Json, but i have some problemas to do it like i want.

{     
      "bool": {
         "must": [
            {
               "Term": {
                  "number": 5
               }
            },
            {
               "Match": {
                  "name": "xxx"
               }
            }
         ]
     }         
}

my class is

    public class BaseLeafQuery
        {
            public BaseFilterType Bool { get; set; }
        }

    public class BaseFilterType 
        {
            [JsonProperty(PropertyName = "must", NullValueHandling = NullValueHandling.Ignore)]
            public List<BaseTypeQuery> Must { get; set; }
        }
    public class BaseTypeQuery {
           [JsonProperty(PropertyName = "term", NullValueHandling = NullValueHandling.Ignore)]
            public Dictionary<string, object> Term { get; set; } 
            [JsonProperty(PropertyName = "match", NullValueHandling = NullValueHandling.Ignore)]
            public Dictionary<string, object> Match { get; set; }
    }

But when i convert the json becomes it

{     
      "bool": {
         "must": [
            {
               "Term": {
                  "number": 5
               },
               "Match": {
                  "name": "xxx"
               }
            }
         ]
     }         
}

Every class inside the "MUST" class must be beetween {}

Example:

BaseTypeQuery baseTypeQuery = new BaseTypeQuery();
            baseTypeQuery.Term = new Dictionary<string, object>() { { "Id", 5 } };
            baseTypeQuery.Match = new Dictionary<string, object>() { { "Email", "xxx" } };

            BaseLeafQuery leafQuery = new BaseLeafQuery();
            leafQuery.Bool = new BaseFilterType();
            leafQuery.Bool.Must = new List<BaseTypeQuery>();
            leafQuery.Bool.Must.Add(baseTypeQuery);
            var a = JsonConvert.SerializeObject(leafQuery);

The result of A is {"bool":{"must":[{"term":{"Id":5},"match":{"Email":"xxx"}}]}} but should bu {"bool":{"must":[{"term":{"Id":5}},{"match":{"Email":"xxx"}}]}}

What properties are "term" and "match" supposed to match with in your JSON? — maccettura
– maccettura, Commented Sep 19, 2017 at 15:28

Vnvizitiu · Accepted Answer · 2017-09-19 17:29:21Z

2

This seems to have worked for me, can you confirm this is what you wanted?

    void Main()
{
    var a = Newtonsoft.Json.JsonConvert.DeserializeObject( "{     \"bool\": {\"must\": [{\"Term\": {\"number\": 5}},{\"Match\": {\"name\": \"xxx\"}}]}}",typeof(TestClass)).Dump();
    JsonConvert.SerializeObject(a).Dump();
}

public class TestClass
{
    [JsonProperty(PropertyName = "bool", NullValueHandling = NullValueHandling.Ignore)]
    public BaseFilterType Bool { get; set; }
}

public class BaseFilterType
{
    [JsonProperty(PropertyName = "must", NullValueHandling = NullValueHandling.Ignore)]
    public List<BaseTypeQuery> Must { get; set; }
}
public class BaseTypeQuery
{
    [JsonProperty(PropertyName = "term", NullValueHandling = NullValueHandling.Ignore)]
    public Dictionary<string, object> Term { get; set; }
    [JsonProperty(PropertyName = "match", NullValueHandling = NullValueHandling.Ignore)]
    public Dictionary<string, object> Match { get; set; }
}

Please note that I had to @bool the class because you cannot declare a class with a keyword name

The output for the serialize is

{"bool":{"must":[{"term":{"number":5}},{"match":{"name":"xxx"}}]}}

This is the change you've been looking for I hope

BaseTypeQuery baseTypeQuery1 = new BaseTypeQuery();
BaseTypeQuery baseTypeQuery2 = new BaseTypeQuery();
baseTypeQuery1.Term = new Dictionary<string, object>() { { "Id", 5 } };
baseTypeQuery2.Match = new Dictionary<string, object>() { { "Email", "xxx" } };

BaseLeafQuery leafQuery = new BaseLeafQuery();
leafQuery.Bool = new BaseFilterType();
leafQuery.Bool.Must = new List<BaseTypeQuery>();
leafQuery.Bool.Must.Add(baseTypeQuery1);
leafQuery.Bool.Must.Add(baseTypeQuery2);
var a = JsonConvert.SerializeObject(leafQuery, Newtonsoft.Json.Formatting.Indented);

edited Sep 19, 2017 at 17:29

answered Sep 19, 2017 at 15:41

Vnvizitiu

7595 silver badges9 bronze badges

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

7 Comments

maccettura Over a year ago

Dont use the @ sign, just use [JsonProperty(PropertyName = "bool"] on top of the public BaseFilterType Bool { get; set; }. Also, OP should consider not naming properties after reserved keywords...

Vnvizitiu Over a year ago

True, was just staying as close as I can to the initial setting :), made the suggested change, thanks

Vnvizitiu Over a year ago

I don't get it, when I plug your code in (assuming that BaseLeafQuery" is actuall the **bool class from the example), I don't have a definition for baseQuery, without that line I get {"bool":{"must":[{"term":{"Id":5},"match":{"Email":"xxx"}}]}}. So either something is missing or we're not using the same objects as you presented initially.

Mauricio Bueno Over a year ago

sorry, the baseQuery i have puted it wrong. And you are right the BaseLeafQuery is the bool from example

Vnvizitiu Over a year ago

no worries but are we using the same classes as at the top?

|

Collectives™ on Stack Overflow

JObject.Parse c#

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related