parse json values from array within object

Question

I am using Newtonsoft within .net to parse json content and wish I had actually studied this better. I create an obj to parse the string text by listing all the children into a list of JTOkens and then grab the individual values from each JProperty. But now I need to capture a list of values and not sure how to that.

 Dim jobj As JObject = JObject.Parse(msg.Body.ToString())
 Dim results As List(Of JToken) = jobj.Children().ToList
 For Each item As JProperty In results
            item.CreateReader()
            If item.Name = "id" Then
                statid = item.Value
            End If
 etc...

But now I find the following item within the object and need all the "values" and "Tags"

{"results":
 {
 {
   "language": {
   "value": "ja"
},
"matching_results": [
{
  "value": "iPhone5",
  "tag": "JOE"
},
{
  "value": "iPhone5",
  "tag": "BOB"
}
],}

rene · Accepted Answer · 2014-02-11 21:25:13Z

1

I have same problem while handling JSON and I find this solution:-

function jsonParse(data)
{
  if(typeof data=='object')
  {
    for(var obj in data)
    {
      if(obj=='value')
      {
        console.log('value---',data[obj])
      }
      else if(obj=='tag')
      {
        console.log('tag---',data[obj])
      }
      jsonParse(data[obj])
    }
  }      
}

Please remove all console with your variable, I hope this will help you.

edited Feb 11, 2014 at 21:25

rene

42.6k78 gold badges122 silver badges166 bronze badges

answered Dec 5, 2012 at 16:07

Mithlesh Kumar

7587 silver badges16 bronze badges

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

Comments

vbNewbie · Accepted Answer · 2012-12-05 18:58:39Z

0

It was just a matter of breaking the object into token and reading the values into a list.

 Dim tags As List(Of JToken) = 
 item.Last.SelectToken("matching_results").Children()("tag").ToList

edited Dec 5, 2012 at 18:58

answered Dec 5, 2012 at 15:32

vbNewbie

3,36515 gold badges81 silver badges160 bronze badges

1 Comment

Paul R Over a year ago

Please add some explanatory text to make this a useful answer - thanks.

Collectives™ on Stack Overflow

parse json values from array within object

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related