How to access elements of a JArray or iterate over them

Question

I have the following Json gotten from Twitter              token               trends                      name    Croke Park II            url    http   twitter com search q  22Croke Park II 22            promoted content   null           query     22Croke Park II 22            events   null                           name     twiznight            url    http   twitter com search q  23twiznight            promoted content   null           query     23twiznight            events   null                           name     Phanhattan            url    http   twitter com search q  23Phanhattan            promoted content   null           query     23Phanhattan            events   null                           name     VinB            url    http   twitter com search q  23VinB            promoted content   null           query     23VinB            events   null                           name     Boston            url    http   twitter com search q  23Boston            promoted content   null           query     23Boston            events   null                           name     rtept            url    http   twitter com search q  23rtept            promoted content   null           query     23rtept            events   null                           name    Facebook            url    http   twitter com search q Facebook            promoted content   null           query    Facebook            events   null                           name    Ireland            url    http   twitter com search q Ireland            promoted content   null           query    Ireland            events   null                           name    Everton            url    http   twitter com search q Everton            promoted content   null           query    Everton            events   null                           name    Twitter            url    http   twitter com search q Twitter            promoted content   null           query    Twitter            events   null                     as of    2013-04-17T13 05 30Z        created at    2013-04-17T12 51 41Z        locations                      name    Dublin            woeid   560743                       Newtonsoft Json Linq JToken  Newtonsoft Json Linq JArray    Problem is I can t seem to access any of the elements  I have tried foreach loops and normal for loops and can never seem to access individual elemets it always ends up accessing the whole area   Any idea how I access the individual elements in this Json JArray

User · Answer

There is a much simpler solution for that.
Actually treating the items of JArray as JObject works.
Here is an example:
Let's say we have such array of JSON objects:

JArray jArray = JArray.Parse(@"[
              {
                ""name"": ""Croke Park II"",
                ""url"": ""http://twitter.com/search?q=%22Croke+Park+II%22"",
                ""promoted_content"": null,
                ""query"": ""%22Croke+Park+II%22"",
                ""events"": null
              },
              {
                ""name"": ""Siptu"",
                ""url"": ""http://twitter.com/search?q=Siptu"",
                ""promoted_content"": null,
                ""query"": ""Siptu"",
                ""events"": null
              }]");

To get access each item we just do the following:

foreach (JObject item in jArray)
{
    string name = item.GetValue("name").ToString();
    string url = item.GetValue("url").ToString();
    // ...
}

User · Answer

Once you have a JArray you can treat it just like any other Enumerable object      and using linq you can access them  check them  verify them  and select them   var str      1  2  3    var jArray   JArray Parse str   Console WriteLine String Join  -   jArray Where i   gt   int i  gt  1  Select i   gt  i ToString

User · Answer

Update - I verified the below works   Maybe the creation of your JArray isn t quite right    TestMethod      public void TestJson                 var jsonString        trends                                        name      Croke Park II                      url      http   twitter com search q  22Croke Park II 22                      promoted content    null                    query       22Croke Park II 22                      events    null                                                    name      Siptu                      url      http   twitter com search q Siptu                      promoted content    null                    query      Siptu                      events    null                                                    name       HNCJ                      url      http   twitter com search q  23HNCJ                      promoted content    null                    query       23HNCJ                      events    null                                                    name      Boston                      url      http   twitter com search q Boston                      promoted content    null                    query      Boston                      events    null                                                    name       prayforboston                      url      http   twitter com search q  23prayforboston                      promoted content    null                    query       23prayforboston                      events    null                                                    name       TheMrsCarterShow                      url      http   twitter com search q  23TheMrsCarterShow                      promoted content    null                    query       23TheMrsCarterShow                      events    null                                                    name       Raw                      url      http   twitter com search q  23Raw                      promoted content    null                    query       23Raw                      events    null                                                    name      Iran                      url      http   twitter com search q Iran                      promoted content    null                    query      Iran                      events    null                                                    name       gaa                      url      http   twitter com search q  23gaa                      promoted content    null                    query      gaa                      events    null                                                    name      Facebook                      url      http   twitter com search q Facebook                      promoted content    null                    query      Facebook                      events    null                              var twitterObject   JToken Parse jsonString           var trendsArray   twitterObject Children lt JProperty gt    FirstOrDefault x   gt  x Name     trends   Value            foreach  var item in trendsArray Children                          var itemProperties   item Children lt JProperty gt                   you could do a foreach or a linq here depending on what you need to do exactly with the value             var myElement   itemProperties FirstOrDefault x   gt  x Name     url                var myElementValue   myElement Value      This is a JValue type                   So call Children on your JArray to get each JObject in JArray   Call Children on each JObject to access the objects properties    foreach var item in yourJArray Children          var itemProperties   item Children lt JProperty gt           you could do a foreach or a linq here depending on what you need to do exactly with the value     var myElement   itemProperties FirstOrDefault x   gt  x Name     url        var myElementValue   myElement Value      This is a JValue type

[c#] How to access elements of a JArray (or iterate over them)

Examples related to c#

Examples related to .net

Examples related to twitter

Examples related to json.net