How to access data json.net array in c#

Question

I can't access all of json data that it is deserialized by json.net. How can I access it. It's null when I WriteLine in console.

Account.cs

public class Account
{
public string Email { get; set; }
public bool Active { get; set; }
public DateTime CreatedDate { get; set; }
public IList<string> Roles { get; set; }
}

main class

 string json2 = @"{'Accounts' :[{
 'Email': '[email protected]',
  'Active': true,
  'CreatedDate': '2013-01-20T00:00:00Z',
  'Roles': [
    'User',
    'Admin']
},
{
 'Email': '[email protected]',
  'Active': true,
  'CreatedDate': '2013-01-20T00:00:00Z',
  'Roles': [
    'Userz',
    'Adminz'
  ]
}]}";

    List<Account> account = new List<Account>();
    account.Add(JsonConvert.DeserializeObject<Account>(json2));


    // [email protected]
    Console.Write(account[0].Email);

Always use this if in doubt: json2csharp.com. Just paste the JSON, and you get the C# class output. — nawfal
– nawfal, Commented Oct 10, 2015 at 17:17

Borislav Borisov · Accepted Answer · 2015-10-10 17:24:27Z

1

The JSON string you have can not be parsed the way you want. Try this instead:

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

public class Program
{
    public static void Main()
    {
        string json2 = @"[{
     'Email': '[email protected]',
      'Active': true,
      'CreatedDate': '2013-01-20T00:00:00Z',
      'Roles': [
        'User',
        'Admin']
    },
    {
     'Email': '[email protected]',
      'Active': true,
      'CreatedDate': '2013-01-20T00:00:00Z',
      'Roles': [
        'Userz',
        'Adminz'
      ]
    }]";

    List<Account> account = new List<Account>();
    account.AddRange(JsonConvert.DeserializeObject<List<Account>>(json2));


    // [email protected]
    Console.Write(account[0].Email);
    }
}

public class Account
{
    public string Email { get; set; }
    public bool Active { get; set; }
    public DateTime CreatedDate { get; set; }
    public IList<string> Roles { get; set; }
}

Edit: or actually the answer @dotnetom provided solves your problem in case you don't have control over the json format

edited Oct 10, 2015 at 17:24

answered Oct 10, 2015 at 17:06

Borislav Borisov

4081 gold badge4 silver badges12 bronze badges

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

1 Comment

Pagorn Over a year ago

wow! that's great! Now I can access data Thankyou very much ^___^

krivtom · Accepted Answer · 2015-10-10 17:00:14Z

1

The reason is that you are missing one more class here:

public class Root
{
    public List<Account> Accounts { get; set; }
}

You need this class, because your JSON has a property which is called Accounts, so you need to have it as well in your C# code in order to deserialize successfully.

And then you deserialise this object use such code:

var root = JsonConvert.DeserializeObject<Root>(json2);

// you can access first element by using
Console.Write(root.Accounts[0].Email);    //prints [email protected]

answered Oct 10, 2015 at 17:00

krivtom

25k10 gold badges53 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to access data json.net array in c#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related