Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Using JSON.NET to read a dynamic property name

Tags:

json

c#

json.net

I am using data from an external API that returns JSON such as the following.

{
  "data": {
    "4": {
      "id": "12",
      "email": "q23rfedsafsadf",
      "first_name": "lachlan",

Using JSON.NET, how do I get the 4 value? This is dynamic as it changes for each record (not the most ideal API I've ever used).

like image 632
Lock Avatar asked Dec 29 '16 22:12

Lock


1 Answers

Here's a working dotNetFiddle: https://dotnetfiddle.net/6Zq5Ry

Here's the code:

using System;
using Newtonsoft.Json;
using System.Collections.Generic;

public class Program
{
    public static void Main()
    {
        string json = @"{
                      'data': {
                        '4': {
                          'id': '12',
                          'email': '[email protected]',
                          'first_name': 'lachlan'
                          },
                        '5': {
                          'id': '15',
                          'email': '[email protected]',
                          'first_name': 'appuswamy'
                          }
                       }
                    }";

        var data = JsonConvert.DeserializeObject<RootObject>(json);
        Console.WriteLine("# of items deserialized : {0}", data.DataItems.Count);
        foreach ( var item in data.DataItems)
        {
            Console.WriteLine("  Item Key {0}: ", item.Key);
            Console.WriteLine("    id: {0}", item.Value.id);
            Console.WriteLine("    email: {0}", item.Value.email);
            Console.WriteLine("    first_name: {0}", item.Value.first_name);
        }
    }
}

public class RootObject
{
    [JsonProperty(PropertyName = "data")]
    public Dictionary<string,DataItem> DataItems { get; set; }
}

public class DataItem
{
    public string id { get; set; }
    public string email { get; set; }
    public string first_name { get; set; }
}

Here's the output:

enter image description here

like image 191
Shiva Avatar answered Nov 16 '22 17:11

Shiva