Deserializing JSON Object Array with Json net

Question

I am attempt to use an API that use the follow example structure for their returned json                customer              first name   Test             last name   Account             email   test1 example com             organization                reference  null            id  3545134            created at   2013-08-06T15 51 15-04 00             updated at   2013-08-06T15 51 15-04 00             address                address 2                city                state                zip                country                phone                               customer              first name   Test             last name   Account2             email   test2 example com             organization                reference  null            id  3570462            created at   2013-08-12T11 54 58-04 00             updated at   2013-08-12T11 54 58-04 00             address                address 2                city                state                zip                country                phone                      JSON net would work great with something like the following structure           customer               field1     value   etc                field1     value   etc                But I can not figure out how to get it to be happy with the provided structure    Using the default JsonConvert DeserializeObject content  results the correct number of Customer but all of the data is null   Doing something a CustomerList  below  results in a  Cannot deserialize the current JSON array  exception  public class CustomerList       public List lt Customer gt  customer   get  set        Thoughts

User · Accepted Answer

You can create a new model to Deserialize your Json CustomerJson:

public class CustomerJson
{
    [JsonProperty("customer")]
    public Customer Customer { get; set; }
}

public class Customer
{
    [JsonProperty("first_name")]
    public string Firstname { get; set; }

    [JsonProperty("last_name")]
    public string Lastname { get; set; }

    ...
}

And you can deserialize your json easily :

JsonConvert.DeserializeObject<List<CustomerJson>>(json);

Hope it helps !

Documentation: Serializing and Deserializing JSON

User · Answer

Using the accepted answer you have to access each record by using Customers i  customer  and you need an extra CustomerJson class  which is a little annoying  If you don t want to do that  you can use the following   public class CustomerList        JsonConverter typeof MyListConverter        public List lt Customer gt  customer   get  set        Note that I m using a List lt  gt   not an Array  Now create the following class   class MyListConverter   JsonConverter       public override object ReadJson JsonReader reader  Type objectType  object existingValue  JsonSerializer serializer                var token   JToken Load reader           var list   Activator CreateInstance objectType  as System Collections IList          var itemType   objectType GenericTypeArguments 0           foreach  var child in token Values                          var childToken   child Children   First                var newObject   Activator CreateInstance itemType               serializer Populate childToken CreateReader    newObject               list Add newObject                     return list             public override bool CanConvert Type objectType                return objectType IsGenericType  amp  amp   objectType GetGenericTypeDefinition      typeof List lt  gt               public override bool CanWrite   gt  false      public override void WriteJson JsonWriter writer  object value  JsonSerializer serializer    gt  throw new NotImplementedException

User · Answer

Further modification from JC VA  take what he has  and replace the MyModelConverter with     public class MyModelConverter   JsonConverter         objectType is the type as specified for List lt myModel gt   i e  myModel      public override object ReadJson JsonReader reader  Type objectType  object existingValue  JsonSerializer serializer                var token   JToken Load reader     json from myModelList  gt  model         var list   Activator CreateInstance objectType  as System Collections IList     new list to return         var itemType   objectType GenericTypeArguments 0      type of the list  myModel          if  token Type ToString       Object     Object                       var child   token Children                var newObject   Activator CreateInstance itemType               serializer Populate token CreateReader    newObject               list Add newObject                     else   Array                       foreach  var child in token Children                                  var newObject   Activator CreateInstance itemType                   serializer Populate child CreateReader    newObject                   list Add newObject                                   return list              public override bool CanConvert Type objectType                return objectType IsGenericType  amp  amp   objectType GetGenericTypeDefinition      typeof List lt  gt               public override bool CanWrite   gt  false      public override void WriteJson JsonWriter writer  object value  JsonSerializer serializer    gt  throw new NotImplementedException        This should work for json that is either  myModelList   model         object            or  myModelList   model        object           they will both end up being parsed as if they were  myModelList   model         object

User · Answer

For those who don t want to create any models  use the following code   var result   JsonConvert DeserializeObject lt    List lt Dictionary lt string       Dictionary lt string  string gt  gt  gt  gt  content     Note  This doesn t work for your JSON string  This is not a general solution for any JSON structure

User · Answer

Slight modification to what was stated above   My Json format  which validates was         mycollection                                   property0 value                 property1 value                                                   property0 value                 property1 value                                                     Using AlexDev s response  I did this  Looping each child  creating reader from it   public partial class myModel       public static List lt myModel gt  FromJson string json    gt  JsonConvert DeserializeObject lt myModelList gt  json  Converter Settings  model      public class myModelList        JsonConverter typeof myModelConverter        public List lt myModel gt  model   get  set        class myModelConverter   JsonConverter       public override object ReadJson JsonReader reader  Type objectType  object existingValue  JsonSerializer serializer                var token   JToken Load reader           var list   Activator CreateInstance objectType  as System Collections IList          var itemType   objectType GenericTypeArguments 0           foreach  var child in token Children       mod here                       var newObject   Activator CreateInstance itemType               serializer Populate child CreateReader    newObject     mod here             list Add newObject                     return list             public override bool CanConvert Type objectType                return objectType IsGenericType  amp  amp   objectType GetGenericTypeDefinition      typeof List lt  gt               public override bool CanWrite   gt  false      public override void WriteJson JsonWriter writer  object value  JsonSerializer serializer    gt  throw new NotImplementedException

[c#] Deserializing JSON Object Array with Json.net

Examples related to c#

Examples related to json.net