Query Json Object dynamically

Question

I am trying to implement a dynamic condition on a JSON Object. After searching for a while, I am not able to find any resources which can meet my needs.

In the below fashion, I am getting the JsonObject dynamic string into jsonObject variable.

   string inputFromAPI = client.GetStringAsync(URL).Result;
   dynamic jsonObject = JValue.Parse(inputFromAPI);

I now have a condition which can change on need basis.For example I can have a condition which says "inputFromAPI.DidWeCharge == true && inputFromAPI.DidWeHold == false"

The above line can change on the fly. Any inputs how to address this will be greatly appreciated.

LINQ to JSON?

itsme86
– itsme86

2018-03-07 22:54:42 +00:00
Commented Mar 7, 2018 at 22:54 — itsme86
– itsme86, Commented Mar 7, 2018 at 22:54

ismael. · Accepted Answer · 2018-03-08 00:02:12Z

1

I can't comment for clarification (don't have the rep yet), but if you need to be able to read the property name because it's changing you can do this. You would have to know the name though.

var JSONobj = JObject.Parse(json);

foreach (JToken child in JSONobj.Children())
{
    var prop = child as JProperty; 
    var propertyName = prop.Name; // this will give you the name of the property
    if (propertyName == "DidWeCharge")
    {

       var value = prop.Value; // Do something here with value?
    }
    if (propertyName == "DidWeHold")
    {
       var value = prop.Value; // Do something here with value?
    }

    var propertyType = prop.Value.Type; // this return the type as a JTokenType enum.
}

I don't know how nested your JSON is, so you may have to traverse further down with another foreach on the child by doing child.Children().

edited Mar 8, 2018 at 0:02

answered Mar 7, 2018 at 23:31

ismael.

4383 silver badges8 bronze badges

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

1 Comment

Richard Over a year ago

This helped. Thank you.

kasuocore · Accepted Answer · 2018-03-07 22:58:43Z

0

You can use ExpandoObject:

var expandoObj = JsonConvert.DeserializeObject<ExpandoObject>(jsonObject);

expandoObj.yourProperty

JsonConvert is from Newtonsoft.Json package.

answered Mar 7, 2018 at 22:58

kasuocore

991 bronze badge

2 Comments

Richard Over a year ago

Well, in my case if you notice my property name and the codition itself can be dynamic. I do not have a problem navigating to the values within my JsonObject.

kasuocore Over a year ago

Did you try DynamicExpresso for dynamic conditionals? github.com/davideicardi/DynamicExpresso

Dave Bish · Accepted Answer · 2018-03-07 23:10:40Z

0

You may be able to use Jpath:

using Newtonsoft.Json -

....

var json = @"
{
    stuff : [
        {
            value : 1
        },
        { 
            value : 2
        }       
    ]
}";


var token = JToken.Parse(json);

var something = token.SelectTokens("$.stuff[?(@.value == 1)]").ToList();

answered Mar 7, 2018 at 23:10

Dave Bish

19.7k7 gold badges50 silver badges63 bronze badges

Collectives™ on Stack Overflow

Query Json Object dynamically

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related