How to read JSON file and select specific values C# [Done] [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 9 years ago.

Improve this question

I'm a beginner in development so please don't judge. I need to read many (like 74) JSON files and all of them have other values. How can I read the JSON files dynamicly and can select specific values?

Currently I use Newtonsoft Json, but I don't know how I can get specific values. So as a sample this is one of the JSON file.

{
    "value": [
        {
            "resourceRef": "/accessControlLists/abc123",
            "resourceId": "abc123",
            "resourceMetadata": {
                "resourceName": "SCVMM Default ACL"
            },
            "etag": "W/\"ea02b098-bcd1-406a-abff-ab380011d510\"",
            "instanceId": "e123f536-ffc1-429e-b67e-50627b1613c8",
            "properties": {
                "provisioningState": "Succeeded",
                "aclRules": [
                    {
                        "resourceRef": "/accessControlLists/abc123/aclRules/def456",
                        "resourceId": "def456",
                        "etag": "W/\"ea02b098-bcd1-406a-abff-ab380011d510\"",
                        "instanceId": "e3467412-e9c7-48a0-9d45-bdaedbe72d2d",
                        "properties": {
                            "provisioningState": "Succeeded",
                            "protocol": "All",
                            "sourcePortRange": "*",
                            "destinationPortRange": "*",
                            "action": "Allow",
                            "sourceAddressPrefix": "*",
                            "destinationAddressPrefix": "*",
                            "priority": "65000",
                            "description": "SCVMM Default Rule - Allow All",
                            "type": "Inbound",
                            "logging": "Enabled"
                        }
                    }
                ],
                "ipConfigurations": [],
                "subnets": []
            }
        }
    ],
    "nextLink": ""
}

The second file is like this.

    {
      "resourceRef": "/virtualNetworkManager/",
      "instanceId": "00000000-0000-0000-0000-000000000000",
      "properties": {
        "provisioningState": "Succeeded",
        "distributedRouterState": "Enabled",
        "networkVirtualizationProtocol": "VXLAN"
      }
    }

So how can I read as a sample the description of the first file? And how can I do it dynamicly?

Thanks for help!

Edit: dynamic with JsonConvert worked for me.

        string path = string.Empty;
        Console.Write("Please enter json file path: ");
        path = Console.ReadLine();

        dynamic obj = JObject.Parse(File.ReadAllText(path));
        for (int i = 0; i < obj.value.Count; i++)
        {
            for (int j = 0; j < obj.value[i].properties.aclRules.Count; j++)
            {
                Console.WriteLine(obj.value[i].properties.aclRules[j].properties.description);
            }
        }

It doesn't matter if you are beginner. Rules applied to all. keyword: newtonsoft — T.S.
– T.S., Commented Nov 18, 2016 at 23:27
You could use SelectToken. See here or here. Start with How can I parse JSON with C#?. — dbc
– dbc, Commented Nov 18, 2016 at 23:31
Thanks. But this all doesn't really help. When I use classes I have more than 30 classes. Is there no other way to do it? — Varusal
– Varusal, Commented Nov 18, 2016 at 23:36
Though, there are ways to generate most/all of your classes from the JSON. Google "generate c# classes from json". It's not perfect, but it'll get you 90% of the way there. I recommend you take this approach, not the dynamic approach. — user47589
– user47589, Commented Nov 18, 2016 at 23:48

Jim · Accepted Answer · 2016-11-19 00:08:33Z

1

How can I read the JSON files dynamically and can select specific values? So how can I read as a sample the description of the first file? And how can I do it dynamically

With the dynamic functionality :

dynamic obj = JsonConvert.DeserializeObject(json);

var description = obj.value[0].properties.aclRules[0].properties.description;

answered Nov 19, 2016 at 0:08

Jim

2,9822 gold badges22 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

How to read JSON file and select specific values C# [Done] [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related