extracting data from json string

Question

I am new to using javascript as well as json. I need to extract certain sections from json for processing the data.

{
  "status": "SUCCESS",
  "status_message": "blah blah blah",
  "pri_tag": [
      {
          "tag_id": 1,
          "name": "Tag1"
      },
      {
          "tag_id": 2,
          "name": "Tag2"
      },
      {
          "tag_id": 3,
          "name": "Tag3"
      },
      {
          "tag_id": 4,
          "name": "Tag4"
      }
  ]
}

From the above json message I need to extract pri_tag section so that the extracted json should look like below:

[
  {name:'Tag1', tag_id:1},
  {name:'Tag2', tag_id:2},
  {name:'Tag3', tag_id:3},
  {name:'Tag4', tag_id:4},
  {name:'Tag5', tag_id:5},
  {name:'Tag6', tag_id:6}
];

How to get this done using javascript? Please help me. Thanks in advance.

Thanks friends. I was able to get this working. Thanks once again.

@super Hornet gave you the perfect answer! Is your JSON message already loaded as a JSON Object (if you declared it like you did above in your JS, it is). If you load the message with AJAX, you need to add var json_message = JSON.parse(my_json_message_variable) — Nicky Smits
– Nicky Smits, Commented Mar 25, 2014 at 8:12

Super Hornet · Accepted Answer · 2014-03-25 08:21:02Z

5

try this:

  var data={
  "status": "SUCCESS",
  "status_message": "blah blah blah",
  "pri_tag": [
  {
      "tag_id": 1,
      "name": "Tag1"
  },
  {
      "tag_id": 2,
      "name": "Tag2"
  },
  {
      "tag_id": 3,
      "name": "Tag3"
  },
  {
      "tag_id": 4,
      "name": "Tag4"
  }
  ]
  };

if you get the data from Ajax request you need to parse it like this:

  var newData=JSON.parse(data).pri_tag;

if not, you don't need to parse that:

  var newData=data.pri_tag;

edited Mar 25, 2014 at 8:21

answered Mar 25, 2014 at 8:04

Super Hornet

2,9275 gold badges31 silver badges58 bronze badges

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

2 Comments

jarandaf Over a year ago

Who is Jason? :) No need to parse anything, data is already a JSON object, not a string.

Super Hornet Over a year ago

@jaranda I just fixed my answer

Murugan Pandian · Accepted Answer · 2014-03-25 08:06:51Z

1

var data={
  "status": "SUCCESS",
  "status_message": "blah blah blah",
  "pri_tag": [
      {
          "tag_id": 1,
          "name": "Tag1"
      },
      {
          "tag_id": 2,
          "name": "Tag2"
      },
      {
          "tag_id": 3,
          "name": "Tag3"
      },
      {
          "tag_id": 4,
          "name": "Tag4"
      }
  ]
}

use this code

var result=data.pri_tag;
for(var i in result)
{
    console.log(result[i]);
}

answered Mar 25, 2014 at 8:06

Murugan Pandian

7781 gold badge5 silver badges17 bronze badges

Comments

xiaoboa · Accepted Answer · 2014-03-25 08:05:25Z

0

Try this

var foo = '{"status": "SUCCESS","pri_tag": [...]}'
var bar = JSON.parse(foo)
bar.pri_tag

answered Mar 25, 2014 at 8:05

xiaoboa

1,95114 silver badges18 bronze badges

Comments

jawn · Accepted Answer · 2022-03-21 15:55:36Z

0

Hopefully this helps someone, I have a scenario where retrieving JSON.parse(someJsonObject).someAttribute doesn't work. Alternatively, you can also extract attribute data using JSON.parse(someJsonObject)['someAttribute']:

answered Mar 21, 2022 at 15:55

jawn

1,02910 silver badges16 bronze badges

Comments

jarandaf · Accepted Answer · 2014-03-25 08:04:46Z

-2

Assuming you have a data variable containing the JSON object, result would hold what you expect (without using the same data variable):

var result = [];

for(var i = 0; i < data.pri_tag.length; i++){
    result.push({'name': data.pri_tag[i].name, 'tag_id': data.pri_tag[i].tag_id});
}

console.log(result);

Here you are a working example.

answered Mar 25, 2014 at 8:04

jarandaf

4,4378 gold badges43 silver badges71 bronze badges

5 Comments

Nicky Smits Over a year ago

Super hornet's answer is better. You do not have to push anything to a seperate array. The data you need is already packaged nicely. Only takes one lune of "code"

jarandaf Over a year ago

Super hornet's answer was actually wrong. But ok, no need to use any other variable (as long as you don't work further with it).

Nicky Smits Over a year ago

I didn't need testing for it to be true, but thanks ;). Haha, your answer was clear and very useful. Instead of the answer we are commenting on because it uses more code (which can confuse the OP), and it uses more computing power then needed.

jarandaf Over a year ago

Then I would recommend you to test things first: stackoverflow.com/posts/22628592/revisions I didn't know Jason, neither Json ;)

Super Hornet Over a year ago

@jaranda, I corrected my typing mistake immediately!

Collectives™ on Stack Overflow

extracting data from json string

5 Answers 5

2 Comments

Comments

Comments

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related