Topics

C#•2y ago

❔ JSON array to List KeyValuePair with Newtonsoft.JSON?

As the title reads, i'm attempting to load a config file (which successfully works) except I am struggling to figure out how I can take in my image assets as a KeyValuePair with the JSON name and value being the parameters. Here's my JSON code snippet:

{
  "image_asset_urls": [

    {
      "bot_icon":"test.com/test.png"
    }
    
  ]
}

{
  "image_asset_urls": [

    {
      "bot_icon":"test.com/test.png"
    }
    
  ]
}

Here's my C# translation using Newtonsoft.Json:

        [JsonProperty("image_asset_urls")]
        public List<KeyValuePair<string, string>>? Images { get; set; }

        [JsonProperty("image_asset_urls")]
        public List<KeyValuePair<string, string>>? Images { get; set; }

How would I correctly do this? Thanks.

44 Replies

TheRanger•2y ago

you should let a site like https://json2csharp.com/ generate C# classes out of your json for you

Convert JSON to C# Classes Online - Json2CSharp Toolkit

Convert any JSON object to C# classes online. Json2CSharp is a free toolkit that will help you generate C# classes on the fly.

TheRanger•2y ago

here's what it generated from ur current json code snippet

// Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse);
    public class ImageAssetUrl
    {
        public string bot_icon { get; set; }
    }

    public class Root
    {
        public List<ImageAssetUrl> image_asset_urls { get; set; }
    }

// Root myDeserializedClass = JsonConvert.DeserializeObject<Root>(myJsonResponse);
    public class ImageAssetUrl
    {
        public string bot_icon { get; set; }
    }

    public class Root
    {
        public List<ImageAssetUrl> image_asset_urls { get; set; }
    }

you can change the property name to Image and put the attribute [JsonProperty("image_asset_urls")] above the property

Hulkstance•2y ago

https://discord.com/channels/143867839282020352/1042207799440060497/1042211981320519751 mtreit just showed in a different post that there was a such feature in VS/Rider which automatically parses JSON to C# objects, so you don't have to use https://json2csharp.com/ 🙂

MODiX•2y ago

mtreit#6470

Quoted by

<@!228574670503280640> from #how to deserialize JSON array (click here)

From mtreit#6470

React with ❌ to remove this embed.

Owen•2y ago

Thanks for the response - i'm struggling to implement this. How would I go about doing this while also ensuring no JSON data is hard coded (i'd like to add to the list in the future without code changes)

Owen•2y ago

http://share.zeron.dev/obp4qXk

Owen•2y ago

http://share.zeron.dev/WVX9XBK

Owen•2y ago

I've implemented to this stage - any assistance is appreciated

TheRanger•2y ago

is this ur whole config.json or is there more than that?

Owen•2y ago

There is more, one moment

Owen•2y ago

http://share.zeron.dev/XjZ6d2m

TheRanger•2y ago

not asking for this

Owen•2y ago

Would you want a sample JSON? Sorry, was getting there

TheRanger•2y ago

as long as "image_asset_urls" is inside the root of the json, it will work

Owen•2y ago

{
  "console_title": "Zeron Discord Bot",
  "embed_title": "Zeron Developments Automated Checkout",
  "bot_prefix": "?",
  "bot_token": "0",
  "guild_id": 0,
  "notification_channel_id": 0,
  "ticket_identifer_string": "ticket-",
  "order_timeout_minutes": 15,
  "log_limit": 25,
  "image_asset_urls": [

    {
      "bot_icon":"test.com"
    }
    
  ],
  "ftp_info": {
    "username": "",
    "password": "",
    "ip_address": "",
    "access_url": ""
  }
}

{
  "console_title": "Zeron Discord Bot",
  "embed_title": "Zeron Developments Automated Checkout",
  "bot_prefix": "?",
  "bot_token": "0",
  "guild_id": 0,
  "notification_channel_id": 0,
  "ticket_identifer_string": "ticket-",
  "order_timeout_minutes": 15,
  "log_limit": 25,
  "image_asset_urls": [

    {
      "bot_icon":"test.com"
    }
    
  ],
  "ftp_info": {
    "username": "",
    "password": "",
    "ip_address": "",
    "access_url": ""
  }
}

TheRanger•2y ago

ok so what exactly isnt working?

Owen•2y ago

How would I call for both the name of the json value (Ex: bot_icon) and the url? I should be able to call for the name value aswell Considering they will be dynamic

TheRanger•2y ago

you want to put them into a dictionary?

Owen•2y ago

yeah correct, originally I tried a keyvaluepair above but had no luck apologies for my poor explanation

TheRanger•2y ago

never tried keyvaluepair but dictionary works

    public class Root
    {
        public List<Dictionary<string, string>> image_asset_urls { get; set; }
    }

    public class Root
    {
        public List<Dictionary<string, string>> image_asset_urls { get; set; }
    }

after all, Dictionary is a collection of KeyValuePair ah wait

Owen•2y ago

Awesome, assuming i'd place

[JsonProperty("image_asset_urls")]

[JsonProperty("image_asset_urls")]

above the Dictionary line also? roger

TheRanger•2y ago

its an array, let me fix it

Owen•2y ago

👌 Appreciate it

TheRanger•2y ago

code edited, not sure if it will work

Owen•2y ago

Will give it a shot, thank you

TheRanger•2y ago

works fine on my end

Owen•2y ago

One more for you, what would the best way to call this be? Previously I used LINQ, unsure what changes would be required here

Owen•2y ago

Thanks a bunch for this Very appreciative

TheRanger•2y ago

what does the error message say? i have no idea what the type of i and Keys are

Owen•2y ago

Owen•2y ago

Need to figure out how to filter the keys in the collection to find the correct key, then pull the value ideally Essentially looking to pull any URL from the JSON data using the key value associated with it

TheRanger•2y ago

ah i think i see what ur trying to do ur trying to get the value of "bot_icon" ?

Owen•2y ago

Sweet, this way I can keep all images external for easy updates. Correct, and if the value is found I want the url associated with bot_icon

TheRanger•2y ago

what if you have multiple bot_icons in your List ?

Owen•2y ago

I don't see it happening. Each entry in the JSON list would be unique

TheRanger•2y ago

will it always be the first element in the list?

Owen•2y ago

No It would be changed in position often

TheRanger•2y ago

well this is one way of doing it

IconUrl = myDeserializedClass.image_asset_urls.First(dic => dic.ContainsKey("bot_icon"))["bot_icon"];

IconUrl = myDeserializedClass.image_asset_urls.First(dic => dic.ContainsKey("bot_icon"))["bot_icon"];

but there is probably a better way i have to think/remember of but i would suggest to make a method in the Root class to return it cleaner, and avoid repeating code in different places

Owen•2y ago

Thanks, i'll implement this ASAP Working!! Thanks a tone. Will leave this open incase you or someone else stumbles across a better way of doing this.

TheRanger•2y ago

i already did, 1 sec

Owen•2y ago

You're a machine 😛

TheRanger•2y ago

    public class Root
    {
        public List<Dictionary<string, string>> image_asset_urls { get; set; }

        public string GetValue(string key)
        {
            foreach(var image in image_asset_urls)
            {
                if (image.ContainsKey(key))
                {
                    return image[key];
                }
            }

            return null;
        }
    }

    public class Root
    {
        public List<Dictionary<string, string>> image_asset_urls { get; set; }

        public string GetValue(string key)
        {
            foreach(var image in image_asset_urls)
            {
                if (image.ContainsKey(key))
                {
                    return image[key];
                }
            }

            return null;
        }
    }

then u just do IconUrl = config.GetValue("bot_icon");

Owen•2y ago

Similar to what I had in mind, great stuff Thanks a lot my friend

Accord•2y ago

Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.

We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.

52KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Use class from different project in my tests project [Answered]Hello, I am trying to create tests for my XKCD.Net API Library but for some reason it does not seem ASP.NET TempData alternative for my use case?I am serializing 40kb of data (list of objects), storing it on TempData, and then deserializing it o ❔ how can pass a google authentication code from my browser to my unity appas shown in the end of this tutorial https://www.youtube.com/watch?v=7D8Z9_tNrC8&t=23s Help with refactoring [Answered]How could I simplify this? ```cs var service = new RbService(); switch (fieldNum) { case 0: ❔ How do I get an IntPtr from a Span [Answered]a library wants me to give a span<byte> as a pointer, and I am not sure as I haven't really done muc ❔ How to download my ASP. NET project from the web hosting's control panelHi everyone, I need some urgent help, I need to work with my ASP. NET project (application) that wi Connect together [Answered]Have one file that has: 1 2 3 6 7 8 9 11 12 13 Other one is: 3 4 5 6 9 10 11 Need to connect them in Blazor routing with multiple parameters [Answered]is there someone who can explain why my blazor page isn't taking 2 parameters in the route? I've got ❔ Data binding errorI have two lists in one window . First one loads the database table well but second doesn`t Error d ✅ Best practice usage of HttpClient in .Net Framework 4.5Hello everyone 👋 hope you’ll. Are having a good day/evening. What is the recommended approach of