How do I reformat JSON in javascript?

Question

Currently my ajax request is getting JSON in this format:

    {
        id: 1,
        teamname: "Chicago Blackhawks",
        league: NHL
        wins: 5
        losses: 10
        account_id: 3444,
    },
    {
        id: 2,
        teamname: "Chicago Bulls",
        league: NBA
        wins: 15
        losses: 2
        account_id: 3444,
    }

but to use an autocomplete jquery plugin, I need it in this format:

[
   { value: 'Chicago Blackhawks', data: { category: 'NHL' } },
   { value: 'Chicago Bulls', data: { category: 'NBA' } }
]

Basically I need to only get two fields and format it under value and data -> category instead of name and league. What is the best way to go about this?

JSON is just a notation. Parse it into a native JavaScript Object and then apply any transformations desired as normal — Paul S.
– Paul S., Commented Dec 6, 2015 at 3:03

Community · Accepted Answer · 2017-05-23 12:15:50Z

4

Your data contains some typos, but once you fix those you get:

var data  = [{
    id: 1,
    teamname: "Chicago Blackhawks",
    league: "NHL",
    wins: 5,
    losses: 10,
    account_id: 3444,
},
{
    id: 2,
    teamname: "Chicago Bulls",
    league: "NBA",
    wins: 15,
    losses: 2,
    account_id: 3444,
}];

From which you can extract your desired list:

var newData = data.map(function(d) {
  return {
    value: d.teamname,
    data: {category: d.league}
  };
});

newData[0];
//=> Object {value: "Chicago Blackhawks", data: "NHL"}

Ack. Thanks Salman for the correction.

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Dec 6, 2015 at 2:56

Hunan Rostomyan

2,1762 gold badges22 silver badges31 bronze badges

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

2 Comments

Hunan Rostomyan Over a year ago

@AndrewD What does your data list look like?

cvdv Over a year ago

thanks I figured it out and this worked perfectly! I was using a made up data list for this question and I copied your answer which is why it was returning undefined values

Salman Oskooi · Accepted Answer · 2015-12-06 03:20:47Z

1

In order to get the data key in your resulting objects to have object notation you should modify the code from @Hunan's answer just a bit, like so:

var newData = data.map(function(d) {
  return {
    value: d.teamname,
    data: {"category": d.league}
  };
});

answered Dec 6, 2015 at 3:20

Salman Oskooi

3663 silver badges8 bronze badges

1 Comment

Hunan Rostomyan Over a year ago

Thanks man. I had overlooked the category. Updated my answer.

Azad · Accepted Answer · 2015-12-06 03:23:33Z

1

try this,

var jsonData  = [{
    id: 1,
    teamname: "Chicago Blackhawks",
    league: "NHL",
    wins: 5,
    losses: 10,
    account_id: 3444,
},
{
    id: 2,
    teamname: "Chicago Bulls",
    league: "NBA",
    wins: 15,
    losses: 2,
    account_id: 3444,
}];

function formatJson(jsonData){

  var rslt = [];
  for(var i = 0; i < jsonData.length; i++)
    rslt.push({ value: jsonData[i].teamname, data: { category: jsonData[i].league} });

   return rslt;
}

var mydata = formatJson(jsonData);

answered Dec 6, 2015 at 3:23

Azad

5,2725 gold badges32 silver badges59 bronze badges

Comments

mjwjon · Accepted Answer · 2015-12-06 03:24:19Z

Assuming that your JSON is valid and @Anik1991 is correct. You can do the following:

var json = '{"teams":[{"id": 1,"teamname": "Chicago Blackhawks","league": "NHL","wins": 5,"losses": 10,"account_id": 3444},{"id": 2,"teamname": "Chicago Bulls","league": "NBA","wins": 15,"losses": 2,"account_id": 3444}]}';

// convert your JSON to an object so you can retrieve values you need
var obj = JSON.parse(json);

// create a new array to store your values in the desired format
var newObj = [];

//for each team in obj, push the values you need as an object
obj['teams'].forEach(function(team){
  newObj.push({
    value: team.teamname,
    data: {
      category: team.league
    }
  });
});

// Finally use JSON.stringify to convert newObj to JSON
console.log(JSON.stringify(newObj));

See https://jsfiddle.net/hsxgrom6/

Collectives™ on Stack Overflow

How do I reformat JSON in javascript?

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related