convert JSON Array to JSON Array of selected keys

advertisements

I have a JSON array as below:

[{
"id": 1,
"name": "Leanne Graham",
"username": "Bret",
"email": "[email protected]",
"address": {
  "street":"201 S 4th St.",
  "suite": "Apt. 556",
  "city": "Gwenborough",
  "zipcode": "92998-3874",
  "geo": {
    "lat": "-37.3159",
    "lng": "81.1496"
  }
},
"company": {
  "name": "Romaguera-Crona",
  "catchPhrase": "Multi-layered client-server neural-net",
  "bs": "harness real-time e-markets"
},
"hobbies":[
        {
          "books":"fiction",
          "sports":"football",
          "music":"rock"
        },

        {
          "books":"action",
          "sports":"cricket",
          "music":"jazz"
        },
        {
          "books":"action",
          "sports":"cricket",
          "music":"cool"
        },

]},{
"id":2,
"name": "Leanne Graham",
"username": "Bret",
"email": "[email protected]",
"address": {
  "street": "Kulas Light",
  "suite": "Apt. 556",
  "city": "Gwenborough",
  "zipcode": "92998-3874",
  "geo": {
    "lat": "-37.3159",
    "lng": "81.1496"
  }
},
"phone": ["1-770-736-8031 x56442", "4087917884", "4089088939"],
"website": "hildegard.org",
"dept":[{"name":"divya", "address":"abc"},{"name":"divya1", "address":"abc1"}],
"hobbies":[
          {
            "books":"fiction",
            "sports":"football",
            "music":"rock"
          },

          {
            "books":"action",
            "sports":"cricket",
            "music":"jazz"
          },
          {
            "books":"action",
            "sports":"cricket",
            "music":"cool"
          },
]}]

I wanted to use only specific keys only in Hobbies key. Let's say I need only books and sports from Hobbies key. How can I do this in Nodejs? The result should be like below:

[{
"id": 1,
"name": "Leanne Graham",
"username": "Bret",
"email": "[email protected]",
"address": {
  "street":"201 S 4th St.",
  "suite": "Apt. 556",
  "city": "Gwenborough",
  "zipcode": "92998-3874",
  "geo": {
    "lat": "-37.3159",
    "lng": "81.1496"
  }
},
"company": {
  "name": "Romaguera-Crona",
  "catchPhrase": "Multi-layered client-server neural-net",
  "bs": "harness real-time e-markets"
},
"hobbies":[
        {
          "books":"fiction",
          "sports":"football",

        },

        {
          "books":"action",
          "sports":"cricket",

        },
        {
          "books":"action",
          "sports":"cricket",

        },

] },{
"id":2,
"name": "Leanne Graham",
"username": "Bret",
"email": "[email protected]",
"address": {
  "street": "Kulas Light",
  "suite": "Apt. 556",
  "city": "Gwenborough",
  "zipcode": "92998-3874",
  "geo": {
    "lat": "-37.3159",
    "lng": "81.1496"
  }
},
"phone": ["1-770-736-8031 x56442", "4087917884", "4089088939"],
"website": "hildegard.org",
"dept":[{"name":"divya", "address":"abc"},{"name":"divya1", "address":"abc1"}],
"hobbies":[
          {
            "books":"fiction",
            "sports":"football",

          },

          {
            "books":"action",
            "sports":"cricket",

          },
          {
            "books":"action",
            "sports":"cricket",

          },
]}].

Please note that this is just one example. my input is an array of JSON and the keys that I wanted to keep. keys for this example are "id", "name", "hobbies.books", "hobbies.sports" etc.

Given you are using node, I wouldn't reinvent the wheel. So you could use something like the lodash pick function, alongside map. For example:

const filteredHobbies = theObject.hobbies.map(item => _.pick(item, ['books', 'sports']))

Related Articles

Convert an array to a key value

I have a comma separated string which i explode into an array. If the array is of un-known length and i want to make it into a key value pair array where each element in the array has the same key, how do i do this? i'm assuming i'd have to use array

how to convert multi array to json multi array

i have foreach loop that returns multi-array from the database and i want to convert this array to multi array in json , how to do this ? php array example Array ( [0] => Array ( [it_code] => 2894 [it_quantity] => 300 [it_price] => 0 [it_notes

Convert json to array with js knockout

I have json file 'stars.json': {"person": [ { "name": "a" }, { "name": "b" }, { "name": "c" }, { "name": "d" } ] } then I would like to send data to kendo element: $

Unable to convert json to javascript object / array

I have this following lines in my page, and i want it to converti into javascript array/object. But I cannot help myself <script language="javascript" src="json2.js"></script> <script> json={"status":"e

How to convert json to array by JS

I need to convert JSON data from [{"Date":"2014","Amount1":90,"Amount2":800}, {"Date":"2015","Amount1":110,"Amount2":300},{"Date":"2016","Amount1"

How to convert an array to JSON format

I have a string array, e.g. p[]={"John","Kevin","Lex"} I want to convert it to JSON so that the data appears in key-value pair like: { "name":"John", "name":"Kevin" } How can I achieve

convert table array to json

i want to convert this array as shown below array_countries=array("20"=>array("cntryValue"=>"3","cntryLabel"=>"Egypt","value"=>"7","label"=>"Tanta"),

Convert the array to JSON in the appropriate format

I'm trying to convert my array to JSON. My JSON is stored in the database and will later be decoded for permission checking. Example, How I want it to be stored in the database: { "admin": 1, "create_posts": 1, "edit_posts":

how to convert an array with keys / values ​​to JSON c #

I'm completey new to C# and I've already given myself a headache. I know this is probably kids stuff to you, but I've spent an hour+ googleing around and can't seem to work it out. All I'm trying to do is convert an array into JSON. I know PHP well,

Good way to convert JSON to Array

i am trying to convert a json response to array in action script 3. This is my JSON response: [{ "id": 1, "klistid": 8017, "name": "List item name", "description": "List item description", "

Convert an array to a json array using php

I have a PHP array like below: Array ( [0] => stdClass Object ( [id] => 1 [area] => Arappalayam ) [1] => stdClass Object ( [id] => 2 [area] => Kalavasal ) ) Now, I need to convert this array into Json array like below : $local_source = [

Convert Json to variable array (object)

I am trying to convert json to a variable without using json_decode. For Example: $json = '{ "username": "username", "password": "pass", "movies": [ { "a": "xx", "b": "xx