Parse JSON String into List string

Question

string json       People       FirstName     Hans     LastName     Olo                                   FirstName     Jimmy     LastName     Crackedcorn         var obj   JObject Parse json    List lt string gt  first  List lt string gt  last   foreach  var child in obj  People   Children          var name   child First    countryName   ToString        var two   child First    countryCode   ToString        var three   child First    isoAlpha3   ToString         countries Add name       twoCharCodes Add two       threeCharCodes Add three        Console Write  Name  t t 0  n2CharCode  t 1  n3CharCode  t 2  n n   name  two  three       I m looking for a way to add each FirstName value into the first List and the same with the LastName vaues and the last List  What is the best way to go about doing this   The above code breaks on   var name   child First    countryName   ToString      with this error    Cannot access child value on Newtonsoft Json Linq JProperty   Any advice

User · Answer

Wanted to post this as a comment as a side note to the accepted answer, but that got a bit unclear. So purely as a side note:

If you have no need for the objects themselves and you want to have your project clear of further unused classes, you can parse with something like:

var list = JObject.Parse(json)["People"].Select(el => new { FirstName = (string)el["FirstName"], LastName = (string)el["LastName"] }).ToList();

var firstNames = list.Select(p => p.FirstName).ToList();
var lastNames = list.Select(p => p.LastName).ToList();

Even when using a strongly typed person class, you can still skip the root object by creating a list with JObject.Parse(json)["People"].ToObject<List<Person>>() Of course, if you do need to reuse the objects, it's better to create them from the start. Just wanted to point out the alternative ;)

User · Answer

I use this JSON Helper class in my projects  I found it on the net a year ago but lost the source URL  So I am pasting it directly from my project   using System  using System Collections Generic  using System Linq  using System Web  using System Runtime Serialization Json  using System IO  using System Text       lt summary gt      JSON Serialization and Deserialization Assistant Class      lt  summary gt  public class JsonHelper            lt summary gt          JSON Serialization          lt  summary gt      public static string JsonSerializer lt T gt   T t                DataContractJsonSerializer ser   new DataContractJsonSerializer typeof T            MemoryStream ms   new MemoryStream            ser WriteObject ms  t           string jsonString   Encoding UTF8 GetString ms ToArray             ms Close            return jsonString                 lt summary gt          JSON Deserialization          lt  summary gt      public static T JsonDeserialize lt T gt   string jsonString                DataContractJsonSerializer ser   new DataContractJsonSerializer typeof T            MemoryStream ms   new MemoryStream Encoding UTF8 GetBytes jsonString            T obj    T ser ReadObject ms           return obj            You can use it like this  Create the classes as Craig W  suggested   And then deserialize like this  RootObject root   JSONHelper JsonDeserialize lt RootObject gt  json

User · Answer

Seems like a bad way to do it  creating two correlated lists  but I m assuming you have your reasons   I d parse the JSON string  which has a typo in your example  it s missing a comma between the two objects  into a strongly-typed object and then use a couple of LINQ queries to get the two lists   void Main         string json       People       FirstName     Hans     LastName     Olo       FirstName     Jimmy     LastName     Crackedcorn             var result   JsonConvert DeserializeObject lt RootObject gt  json        var firstNames   result People Select  p   gt  p FirstName  ToList        var lastNames   result People Select  p   gt  p LastName  ToList       public class Person       public string FirstName   get  set        public string LastName   get  set       public class RootObject       public List lt Person gt  People   get  set

User · Answer

Try this   using System  using Newtonsoft Json  using System Collections Generic  public class Program       public static void Main                 List lt Man gt  Men   new List lt Man gt              Man m1   new Man            m1 Number     1-9169168158           m1 Message    Hello Bob from 1           m1 UniqueCode    0123           m1 State   0           Man m2   new Man            m2 Number     1-9296146182           m2 Message    Hello Bob from 2           m2 UniqueCode    0125           m2 State   0           Men AddRange new Man     m1  m2              string result   JsonConvert SerializeObject Men           Console WriteLine result              List lt Man gt  NewMen   JsonConvert DeserializeObject lt List lt Man gt  gt  result           foreach Man m in NewMen  Console WriteLine m Message           public class Man       public string Number get set       public string Message  get set       public string UniqueCode  get set       public int State  get set

User · Answer

Since you are using JSON NET  personally I would go with serialization so that you can have Intellisense support for your object  You ll need a class that represents your JSON structure  You can build this by hand  or you can use something like json2csharp to generate it for you   e g   public class Person       public string FirstName   get  set        public string LastName   get  set       public class RootObject       public List lt Person gt  People   get  set        Then  you can simply call JsonConvert s methods to deserialize the JSON into an object   RootObject instance   JsonConvert Deserialize lt RootObject gt  json     Then you have Intellisense   var firstName   instance People 0  FirstName  var lastName   instance People 0  LastName

[c#] Parse JSON String into List<string>

Examples related to c#

Examples related to json

Examples related to list