Parse the JSON data in javascript

Question

I Have following JSON data, I need to iterate this data based on Keytype in JAVASCRIPT. It should return record from only the passed key code. Say i need record from 438 means it should give me only following data. (ex:"K": "43800001", "D": "Data1")

{
  "GroupCode": {
    "PickType": [
      {
        "@KeyType": "438",
        "R": [
          {
            "K": "43800001",
            "D": "Data1"
          }
        ]
      },
      {
        "@KeyType": "439",
        "R": [
          {
            "K": "43900001",
            "D": "Data2"
          }
        ]
      },
      {
        "@KeyType": "440",
        "R": [
          {
            "K": "44000001",
            "D": "Data3"
          }
        ]
      },
      {
        "@KeyType": "441",
        "R": [
          {
            "K": "44100001",
            "D": "Data4"
          }
        ]
      }
    ]
  }
}

as I'm not good in java script and new to it, i haven't tried coding for this. Please help me in getting the data.

@JaromandaX Why would he needs to parse it? It is already js object in valid JSON format — A. Wolff
– A. Wolff, Commented Feb 4, 2016 at 11:37

Nikhil Aggarwal · Accepted Answer · 2016-02-04 11:47:21Z

2

Let us say the above is stored in a variable obj. You can get the result via following

var result = obj.GroupCode.PickType.filter(function(item){
                return item["@KeyType"] === "438"
            }).map(function(item){
               return item.R[0];
            });

Please note, result is an array. If you have unique object against the condition then for that you will have to check the length of array and then extract the object i.e. result[0] or result.shift()

edited Feb 4, 2016 at 11:47

answered Feb 4, 2016 at 11:37

Nikhil Aggarwal

28.5k4 gold badges46 silver badges61 bronze badges

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

8 Comments

A. Wolff Over a year ago

Very close but returns an array. OP wants .map(...)[0]

Nikhil Aggarwal Over a year ago

@A.Wolff - I was editing the answer with comments. Thank you

A. Wolff Over a year ago

That's said, you don't need to map it: obj.GroupCode.PickType.filter(function(item){ return item["@KeyType"] === "438" })[0].R[0]; But somehow, your code is more readable

Nikhil Aggarwal Over a year ago

@A.Wolff - I wish that was an answer so that I can upvote it :)

ViKu Over a year ago

@nikil What is the purpose of item in filter function here

|

Thanga · Accepted Answer · 2016-02-04 11:47:08Z

0

Working Fiddle here

function getByKeyType(keytype) {
  for(i in f.GroupCode.PickType) {
    if(f.GroupCode.PickType[i].KeyType == keytype) {
       return f.GroupCode.PickType[i].R[0];
    }
  }
  return null;
}

alert(getByKeyType(438).K)
alert(getByKeyType(438).D)

answered Feb 4, 2016 at 11:47

Thanga

8,2003 gold badges22 silver badges39 bronze badges

Comments

Wasiq Muhammad · Accepted Answer · 2016-02-04 11:55:08Z

0

Try this

  function getByKeyType(keytype) {
    for(i in f.GroupCode.PickType) {
    if(f.GroupCode.PickType[i].KeyType == keytype) {
       return f.GroupCode.PickType[i].R[0];
    }
  }
  return null;
}

edited Feb 4, 2016 at 11:55

answered Feb 4, 2016 at 11:48

Wasiq Muhammad

3,1483 gold badges19 silver badges30 bronze badges

1 Comment

A. Wolff Over a year ago

No, it won't work. var result = JSON.parse(obj); I think obj in OP's code is already an object

madalinivascu · Accepted Answer · 2016-02-04 11:58:41Z

0

Try a simple jquery each loop and a if:

jquery:

$.each(obj.GroupCode.PickType,function(i,v){
 if (v["@KeyType"] == 438) {
      console.log(v.R)//v.R[0];
   }
});

javascript:

for(v in obj.GroupCode.PickType) {
  if (v["@KeyType"] == 438) {
      console.log(v.R)//v.R[0];
   }
}

edited Feb 4, 2016 at 11:58

answered Feb 4, 2016 at 11:43

madalinivascu

32.4k4 gold badges41 silver badges59 bronze badges

2 Comments

Sabaz Over a year ago

warning here, $.each is not a vanilla javascript , it comes with jQuery: a js lib. do not take it for granted knowledge. also op said he's new in javascript so maybe he'll get an error while testing your code and wondering "..why?", add some additional info

Sabaz Over a year ago

eveything is possible, thank you for the edit and for the burning reply

Collectives™ on Stack Overflow

Parse the JSON data in javascript

4 Answers 4

8 Comments

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related