C Parsing JSON array of objects

Question

I have an array of objects like this in json format     results     SwiftCode      City      BankName   Deutsche Bank   Bankkey   10020030   Bankcountry   DE     SwiftCode      City   10891 Berlin   BankName   Commerzbank Berlin  West    Bankkey   10040000   Bankcountry   DE       What I want to get is a object   in C   where one object  contains all the data what is in one json object  The thing is  I can NOT make a class with the properties of this object like here   public class Result       public int SwiftCode   get  set        public string City   get  set                                    public string Bankcountry   get  set        Because I get everytime different results back  but I know it s always an array of objects  Someone knows how I could manage to get an array of objects back   EDIT  I have to pass this object to powershell via WriteObject results   So the ouput should only be the object IN the array

User · Accepted Answer

Use newtonsoft like so   using System Collections Generic  using System Linq  using Newtonsoft Json Linq   class Program       static void Main                 string json      results     SwiftCode      City      BankName   Deutsche    Bank   Bankkey   10020030   Bankcountry   DE     SwiftCode      City   10891    Berlin   BankName   Commerzbank Berlin  West    Bankkey   10040000   Bankcountry   DE                var resultObjects   AllChildren JObject Parse json                First c   gt  c Type    JTokenType Array  amp  amp  c Path Contains  results                 Children lt JObject gt              foreach  JObject result in resultObjects                foreach  JProperty property in result Properties                         do something with the property belonging to result                                       recursively yield all children of json     private static IEnumerable lt JToken gt  AllChildren JToken json                foreach  var c in json Children                  yield return c              foreach  var cc in AllChildren c                     yield return cc

User · Answer

I have just got an solution a little bit easier do get an list out of an JSON object  Hope this can help   I got an JSON like this     Accounts       bank     Itau     account     456     agency     0444     digit     5         And made some types like this      public class FinancialData       public string Accounts   get  set       this will store the JSON string     public List lt Accounts gt  AccountsList   get  set       this will be the actually list          public class Accounts       public string bank   get  set        public string account   get  set        public string agency   get  set        public string digit   get  set         and the  magic  part   Models FinancialData financialData    Models FinancialData JsonConvert DeserializeObject myJSON typeof Models FinancialData            var accounts   JsonConvert DeserializeObject financialData Accounts  as JArray           foreach  var account in  accounts                        if  financialData AccountsList    null                                financialData AccountsList   new List lt Models Accounts gt                                financialData AccountsList Add JsonConvert DeserializeObject lt Models Accounts gt  account ToString

User · Answer

I believe this is much simpler   dynamic obj   JObject Parse jsonString   string results    obj results  foreach string result in result Split         Todo

User · Answer

Use NewtonSoft JSON Net library   dynamic obj   Newtonsoft Json JsonConvert DeserializeObject jsonString     Hope this helps

User · Answer

string jsonData1       name     0     price     40     count     1     productId     4     catid     4     productTotal     40     orderstatus     0     orderkey     123456789                          string jsonData   jsonData1 Replace                                DataSet ds   new DataSet                      DataTable dt   new DataTable           JArray array  JArray Parse jsonData     couldnot parse   if the vaule is a string    look at name   meals   if name   1 then it will parse

User · Answer

Though this is an old question  I thought I d post my answer anyway  if that helps someone in future   JArray array   JArray Parse jsonString    foreach  JObject obj in array Children lt JObject gt             foreach  JProperty singleProp in obj Properties                    string name   singleProp Name           string value   singleProp Value ToString               Do something with name and value            System Windows MessageBox Show  name is   name   and value is   value                This solution uses Newtonsoft library  don t forget to include using Newtonsoft Json Linq

[c#] C# Parsing JSON array of objects

Examples related to c#

Examples related to arrays

Examples related to json

Examples related to parsing