Looping through JSON Array List

Question

This is a follow up to a question that I asked before. I am trying to parse an array of JSON data. I have the following classes for the data. I have the data in a list and I can loop through the RootObject data but I am having trouble looping the the child StoreDepartment data. Can someone tell me how I can accomplish this? Thank you.

string sJSON = @"[{""dateNumeric"":1216000000,""hourOfDay"":0,""customerNumber"":12,""storedepartment"":[{""department"":333,""descriptionOfDepartment"":""Department A""},{""department"":111,""descriptionOfDepartment"":""Department B""}]},{""dateNumeric"":1216000000,""hourOfDay"":3,""customerNumber"":3,""storedepartment"":[{""department"":999,""descriptionOfDepartment"":""Department X""},{""department"":888,""descriptionOfDepartment"":""Department Y""}]}]";

List<RootObject> Data = JsonConvert.DeserializeObject<List<RootObject>>(sJSON);


foreach (RootObject c in Data)
{
   debugOutput(c.dateNumeric.ToString());
   debugOutput(c.customerNumber.ToString());
}


public class RootObject
{
    public int dateNumeric { get; set; }
    public int hourOfDay { get; set; }
    public int customerNumber { get; set; }
    public List<Storedepartment> storedepartment { get; set; }
}

public class Storedepartment
{
    public int department { get; set; }
    public string descriptionOfDepartment { get; set; }
}

Please share the code you are using to loop StoreDepartmant, and what kind of a trouble you are having? Are you having an exception? — Mithgroth
– Mithgroth, Commented Jan 8, 2018 at 8:00
But what is the problem exactly that you are having? c.storedepartment should be the list that you want to iterate, however you might just want to make sure it isn't null before going over it — Icepickle
– Icepickle, Commented Jan 8, 2018 at 8:04
I mean do I us a foreach within the original foreach. I am just trying to itterate the root data and the Storedepartment data. foreach (RootObject c in Data) { foreach (c.Storedepartment s in Data) { } } — nemesis713
– nemesis713, Commented Jan 8, 2018 at 8:15

Morten Bork · Accepted Answer · 2018-01-08 08:09:24Z

1

This should do it?

foreach (RootObject c in Data)
{
   debugOutput(c.dateNumeric.ToString());
   debugOutput(c.customerNumber.ToString());
   if(c.storedepartment != null)
   {
      foreach (Storedepartment sd in c.storedepartment)
      {
      debugOutput(sd.department.ToString());
      debugOutput(sd.descriptionOfDepartment.ToString());
      }
   }
   else
   {
      debugOutput("Storedepartment was null");
   }
}

answered Jan 8, 2018 at 8:09

Morten Bork

1,67714 silver badges25 bronze badges

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

2 Comments

nemesis713 Over a year ago

I think that's it. That's all I needed. Thank you very much.

Morten Bork Over a year ago

@nemesis713 please choose this as the "accepted answer", if it worked for you :) Thank you in advance.

John Wu · Accepted Answer · 2018-01-08 08:17:49Z

0

Pretty easy!

foreach (var d in Data)
{
    foreach (var s in d.storedepartment)
    {               
        Console.WriteLine(s.descriptionOfDepartment);
    }
}

Working example on DotNetFiddle

answered Jan 8, 2018 at 8:17

John Wu

52.5k8 gold badges50 silver badges92 bronze badges

Collectives™ on Stack Overflow

Looping through JSON Array List

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related