JSON.NET - outputting dynamic object data

Question

I'm working on a project that takes an ingested JSON file and outputs a UI based on the file contents. My JSON looks like this:

{
    "template" : {
        "example" : {
            "name" : "Name",
            "wigglies" : [
                {
                    "displayname" : "Artifact Spots"
                }
            ],
            "othersrc" : [
                {
                    "displayname" : "Other Sources"
                }
            ],
            "reward" : "Donation Reward",
            "drops" : [
                {
                    "displayname" : "Monster Drops"
                }
            ],
            "price0base" : "Base Price",
            "edibility" : "Edibility",
            "iridium" : "",
            "image" : ""
        },
        "metadata" : {
            "author" : "Me",
            "version" : "1.0",
            "published" : "12/21/2019"
        }
    },
    "content" : {
        "categories" : [
            {
                "category" : "Artifacts",
                "subcategories" : [
                    {
                        "subcategory" : "Artifacts",
                        "items" : [
                            {
                                "name" : "Amphibian Fossil",
                                "wigglies" : [
                                    {
                                        "name" : "Forest"
                                    },
                                    {
                                        "name" : "Mountain"
                                    }
                                ],
                                "othersrc" : [
                                    {
                                        "name" : "Fishing Treasure Chest"
                                    }
                                ],
                                "price0base" : "150"
                            },
                            {
                                "name" : "Anchor",
                                "wigglies" : [
                                    {
                                        "name" : "The Beach"
                                    }
                                ],
                                "othersrc" : [
                                    {
                                        "name" : "Fishing Treasure Chest"
                                    },
                                    {
                                        "name" : "Artifact Trove"
                                    }
                                ],
                                "price0base" : "100"
                            }
                        ]
                    }
                ]
            },
            {
                "category" : "Equipment",
                "subcategories" : [
                    {
                        "subcategory" : "Refining",
                        "items" : [
                            {
                                "name" : "Charcoal Kiln"
                            },
                            {
                                "name" : "Crystalarium"
                            }
                        ]
                    },
                    {
                        "subcategory" : "Artisan",
                        "items" : [
                            {
                                "name" : "Bee House"
                            },
                            {
                                "name" : "Cask"
                            }
                        ]
                    }
                ]
            }
        ]
    }
}

What I'm having trouble with is how to return this data in a useful way, while allowing an arbitrary data structure in the array contained by Content.Categories.Category.Subcategories.Subcategory.Items. My sample JSON is not the only structure for that data; it's just one example. So, there could be more nested arrays in there, too.

I know I can access data through something like:

Content.Categories[0].Subcategories[0].Items[0]["name"]

This returns a Json.Linq.Jtoken though, which isn't super useful. The Items array is a JObject[]. I feel like I'm missing something obvious here.

score 1 · Accepted Answer · answered Dec 26 '19 at 05:15

1

I believe you are looking for string representation of the JToken. You can get that by using .ToString() and .ToArray() for name and items respectively.


    JToken name = jsonFeed["content"]["categories"][0]["subcategories"][0]["items"][0]["name"];
    string nameString = jsonFeed["content"]["categories"][0]["subcategories"][0]["items"][0]["name"].ToString();

    JToken[] itemArray = jsonFeed["content"]["categories"][0]["subcategories"][0]["items"].ToArray();

answered Dec 26 '19 at 05:15

Jawad

11,028
3
24
37

Sorry my question isn't very clear - how do I enumerate the contents of an item *without referring to the properties explicitly*? The properties of an item are completely arbitrary. My code doesn't know about them. How doI retreive the list of keys for a given item, and use that list to get the values for outputting as XAML controls in my UI? – CXL Dec 26 '19 at 19:30
You can use Properties() method to get the keys of the object . then based on these keys, you can iterate through it. Sample: https://www.newtonsoft.com/json/help/html/JObjectProperties.htm – Jawad Dec 26 '19 at 19:32
Thank you!! This got me in the direction I needed to go. :) – CXL Dec 26 '19 at 22:23

score 0 · Answer 2 · answered Dec 26 '19 at 06:02

0

You can use this:

string jsonData = "";
dynamic templates = JsonConvert.DeserializeObject<dynamic>(jsonData);
var name = templates.example.Name;  // prints Name
var categories = templates.Content.Categories; // list of categories

// loop through the categories
// or do whatever

This way your code is easier to read and manage.

answered Dec 26 '19 at 06:02

Gauravsa

6,330
2
21
30

Sorry my question isn't very clear - how do I enumerate the contents of an item *without referring to the properties explicitly*? The properties of an item are completely arbitrary. My code doesn't know about them. How doI retreive the list of keys for a given item, and use that list to get the values for outputting as XAML controls in my UI? – CXL Dec 26 '19 at 19:30

JSON.NET - outputting dynamic object data

2 Answers2