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 every time 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.

the better question is, why do you need it to be an object[] in c# if you don't even know what the object is going to look like? It sounds like you should be using something like a dictionary instead. — Red Alert
– Red Alert, Commented Nov 11, 2013 at 15:58
I don't have to know what kind of object it is, I give it over in powershell for the end-user. — Patrick
– Patrick, Commented Nov 11, 2013 at 16:01

Bibaswann Bandyopadhyay · Accepted Answer · 2016-05-01 17:20:42Z

25

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<JObject>())
 {
     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;

answered May 1, 2016 at 17:20

Bibaswann Bandyopadhyay

3,5652 gold badges35 silver badges31 bronze badges

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

Comments

allonhadaya · Accepted Answer · 2013-11-13 16:15:39Z

20

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 => c.Type == JTokenType.Array && c.Path.Contains("results"))
            .Children<JObject>();

        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<JToken> AllChildren(JToken json)
    {
        foreach (var c in json.Children()) {
            yield return c;
            foreach (var cc in AllChildren(c)) {
                yield return cc;
            }
        }
    }
}

edited Nov 13, 2013 at 16:15

answered Nov 11, 2013 at 16:14

allonhadaya

1,3077 silver badges19 bronze badges

7 Comments

Patrick Over a year ago

Thanks for the answer, it' helpful as well. but what would be if my string looks like

tring json = "{'test':{'results':[{'SwiftCode':'','City':'','BankName':'Deutsche Bank','Bankkey':'10020030','Bankcountry':'DE'},{'SwiftCode':'','City':'10891 Berlin','BankName':'Commerzbank Berlin (West)','Bankkey':'10040000','Bankcountry':'DE'}]}}";

allonhadaya Over a year ago

Is the results array at any level of nesting the signal to spit out the enclosed objects?

Patrick Over a year ago

Yes results it's always the name of the object[] I need. Solved it with the following code:

dynamic obj = JsonConvert.DeserializeObject(json);                     var convert = obj.d.results.ToString();                     ErrorRecord errorRecord;                     var result = JsonObject.ConvertFromJson(convert, out errorRecord);

Do you have a smoother solution for me?

Patrick Over a year ago

Now another problem appeared. Somewhere in my rawjson I have dates in unixtimestamp like this: Date: "/Date(1382400000)/" . But if parse the json this way, It automaticly trys to convert in a type of DateTime, but with wrong date. So can I ovverride only the part of parsing the date? It would help me a lot.

allonhadaya Over a year ago

@AstralisSomnium this might lead you in the right direction: stackoverflow.com/questions/18088406/…

|

Mehmet Ince · Accepted Answer · 2013-11-11 16:00:01Z

18

Use NewtonSoft JSON.Net library.

dynamic obj = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonString);

Hope this helps.

edited Nov 11, 2013 at 16:00

Mehmet Ince

4,21914 gold badges48 silver badges65 bronze badges

answered Nov 11, 2013 at 15:57

Marvin Smit

4,1181 gold badge24 silver badges21 bronze badges

3 Comments

Patrick Over a year ago

Thanks for the fast answer. I already tried dynamic, but it stores even information about the array itself (like type, has valuse, first, last, parent....), but I don't need any of these. I only need the objects.

Marvin Smit Over a year ago

So, ignore the data your not interested in and take it from obj.results[x]?

Patrick Over a year ago

Holy potato, that's awesome! Didn't know that I can just .whateverIwantHere in a dynamic class. Thank you Marvin!

Luiz Paulo · Accepted Answer · 2024-05-27 19:31:01Z

16

I have a solution a little bit easier to use. Hope this may help.

Provided a JSON like this:

{"Accounts":"[{\"bank\":\"Itau\",\"account\":\"456\",\"agency\":\"0444\",\"digit\":\"5\"}]"}

You can create some types, like so

    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; }

}

then, 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()));
        }

EDIT: My english got a lot better :D

edited May 27, 2024 at 19:31

answered Nov 1, 2016 at 11:25

Luiz Paulo

4316 silver badges14 bronze badges

2 Comments

Kshitij Jhangra Over a year ago

This is actually the correct way of parsing a json collection inside the parent json object.

Bob Kaufman Over a year ago

I was creating all sorts of kludgy solutions that weren't working. I knew there'd be a simple, elegant solution to fetching the records within a single JSON field. Thank you!

Ogglas · Accepted Answer · 2021-11-10 15:47:04Z

3

Using .NET 6 you could use built in System.Text.Json.Nodes

Example:

string json = @"{""results"":[{""SwiftCode"":"""",""City"":"""",""BankName"":""Deutsche Bank"",""Bankkey"":""10020030"",""Bankcountry"":""DE""},{""SwiftCode"":"""",""City"":""10891 Berlin"",""BankName"":""Commerzbank Berlin (West)"",""Bankkey"":""10040000"",""Bankcountry"":""DE""}]}";

JsonObject obj = JsonNode.Parse(json).AsObject();
JsonArray jsonArray = (JsonArray)obj["results"];

answered Nov 10, 2021 at 15:47

Ogglas

71.4k43 gold badges388 silver badges484 bronze badges

Comments

mca · Accepted Answer · 2015-05-14 20:12:41Z

1

I believe this is much simpler;

dynamic obj = JObject.Parse(jsonString);
string results  = obj.results;
foreach(string result in result.Split('))
{
//Todo
}

answered May 14, 2015 at 20:12

mca

1241 silver badge3 bronze badges

Collectives™ on Stack Overflow

C# Parsing JSON array of objects

6 Answers 6

Comments

7 Comments

3 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

7 Comments

3 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related