json properties as numbers in c# model class?

Question

How can I build a Model class to deserialize a json like this:-

{"query":{"apikey":"65320-2d8b-11eb-864","continent":"Africa"},"data":{"0":{"country_id":1,"name":"Africa","country_code":null,"continent":"Africa"},"9":{"country_id":10,"name":"Algeria","country_code":"dz","continent":"Africa"},"11":{"country_id":12,"name":"Angola","country_code":"ao","continent":"Africa"},"23":{"country_id":24,"name":"Botswana","country_code":"bw","continent":"Africa"},"27":{"country_id":28,"name":"Cameroon","country_code":"cm","continent":"Africa"},"32":{"country_id":33,"name":"Congo","country_code":"cg","continent":"Africa"},"39":{"country_id":40,"name":"Egypt","country_code":"eg","continent":"Africa"},"48":{"country_id":49,"name":"Ghana","country_code":"gh","continent":"Africa"},"62":{"country_id":63,"name":"Ivory Coast","country_code":"ci","continent":"Africa"},"67":{"country_id":68,"name":"Kenya","country_code":"ke","continent":"Africa"},"80":{"country_id":81,"name":"Morocco","country_code":"ma","continent":"Africa"},"85":{"country_id":86,"name":"Nigeria","country_code":"ng","continent":"Africa"},"102":{"country_id":103,"name":"Rwanda","country_code":"rw","continent":"Africa"},"106":{"country_id":107,"name":"Senegal","country_code":"sn","continent":"Africa"},"111":{"country_id":112,"name":"South Africa","country_code":"za","continent":"Africa"},"115":{"country_id":116,"name":"Tanzania","country_code":"tz","continent":"Africa"},"118":{"country_id":119,"name":"Tunisia","country_code":"tn","continent":"Africa"},"120":{"country_id":121,"name":"Uganda","country_code":"ug","continent":"Africa"},"129":{"country_id":130,"name":"Zambia","country_code":"zm","continent":"Africa"},"130":{"country_id":131,"name":"Zimbabwe","country_code":"zw","continent":"Africa"}}}

The problem is in the numbers like "0", "9", "11" etc! How can I convert these numbers to one property in the model class?

This answer can guide you: https://stackoverflow.com/a/28874282/10659482 — Akif, Dec 06 '20 at 14:38

score 2 · Accepted Answer · answered Dec 06 '20 at 14:37

If you implement the data item as a Dictionary on your model, these numbers would be the keys of this Dictionary.

public class Model
{
    [JsonProperty("query")]
    public Query query {get; set; }

    [JsonProperty("data")]
    public Dictionary<string, Country> Data { get; set; }
}

public class Country
{
    [JsonProperty("country_id")]
    public int Id { get; set; }

    [JsonProperty("name")]
    public string Name { get; set; }

    [JsonProperty("country_code")]
    public string Code { get; set; }

    [JsonProperty("continent")]
    public string Continent { get; set; }
}

public class Query
{
    [JsonProperty("apikey")]
    public string ApiKey { get; set; }

    [JsonProperty("continent")]
    public string Continent { get; set; }
}

score 0 · Answer 2 · answered Dec 06 '20 at 14:39

You can treat these numbers as keys of an dictionary. So may convert them like this:

using System;
using System.Collections.Generic;
using Newtonsoft.Json;
                    
public class Program
{
    public static void Main()
    {
        var testJson = "{\"data\":{\"11\": \"test11\"}}";
        var deserialized = (TestClass) JsonConvert.DeserializeObject(testJson, typeof(TestClass));
        Console.WriteLine(deserialized.Data[11]);
        
    }
}
public class TestClass
{
    public Dictionary<int, string> Data {get;set;}
}

(to test see this dotnetfiddle example)

Obviously only possible if no number appears twice or more.

json properties as numbers in c# model class?

2 Answers2