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 · 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<Accounts> 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<Models.Accounts>();
            }

            financialData.AccountsList.Add(JsonConvert.DeserializeObject<Models.Accounts>(account.ToString()));
        }

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

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

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

User · 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

[c#] C# Parsing JSON array of objects

Examples related to c#

Examples related to arrays

Examples related to json

Examples related to parsing