Capture value from the JSON array

Question

I am trying to call an API and getting the results back in the form of JSON. I need to parse the data received and collect the specific data "key" under mapping in below mentioned JSON data from the array. I also want to get the total count of key under the mapping, so that I can recurse the array and retrieve the key.

JSON data as below,

{
    "$type": "Type1",
    "mapping": [
        {
            "value": "Value1",
            "key": "Key1"
        },
        {
            "value": "Value2",
            "key": "Key2"
        }
    ]
}

I am stuck in the code until below mentioned. Was not sure how to proceed further. Kindly suggest how can I get the value

using (var webResponse = (HttpWebResponse)webrequest.GetResponse())
{
    using (var sr = new StreamReader(webResponse.GetResponseStream()))
    {
       text = sr.ReadToEnd();
       dynamic jsonObject = JsonConvert.DeserializeObject(text);
       //Need suggestion how can I retrieve the specific
    }
}

Perhaps you should deserialize to classes instead?

ProgrammingLlama
– ProgrammingLlama

2019-08-15 01:28:16 +00:00
Commented Aug 15, 2019 at 1:28 — ProgrammingLlama
– ProgrammingLlama, Commented Aug 15, 2019 at 1:28

Glenn Ferrie · Accepted Answer · 2019-08-15 01:34:38Z

1

Here is a quick Console app that does what you are trying to do. The trick is to traverse the dynamic object until you find what you want. But cast everything as dynamic as you go.

class Program
{
    static void Main(string[] args)
    {
        var text = "{ \"$type\": \"Type1\",\"mapping\": [ { \"value\": \"Value1\", \"key\": \"Key1\" }, { \"value\": \"Value2\", \"key\": \"Key2\" } ] }";

        dynamic result = JsonConvert.DeserializeObject(text);
        dynamic mapping = result.mapping;
        foreach(dynamic item in mapping as IEnumerable<dynamic>)
        {
            Console.WriteLine("{0}: {1}", (string)item.value, (string)item.key);
        }
        var done = Console.ReadLine();
    }
}

answered Aug 15, 2019 at 1:34

Glenn Ferrie

10.4k3 gold badges46 silver badges77 bronze badges

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

2 Comments

Dhillli4u Over a year ago

That worked like a charm! Thanks a lot for the suggestion.

Glenn Ferrie Over a year ago

glad it worked. dynamic is pretty useful when you're working with JSON.

Collectives™ on Stack Overflow

Capture value from the JSON array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related