Revamping JSON structure by identifying id references

Question

Revamping JSON structure by identifying id references

I recently attempted to update the city name within the JSON object provided below.


    "City":[
   {
      "Name":"Delhi",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd",
      "Towns":[
         {
            "Name":"MG Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         },
         {
            "Name":"DLF Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         }
      ]
   },
   {
      "Name":"Pune",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax",
      "Towns":[
         {
            "Name":"Hadapsar",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1x4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"
         },
         {
            "Name":"Magarpatta",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1f4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bax"
         }
      ]
   }
]

My goal was to replace the town name from "Hadapsar" to "Viman Nagar" if the cid matched that of Hadapsar Town

The desired output was:


   "City":[
   {
      "Name":"Delhi",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd",
      "Towns":[
         {
            "Name":"MG Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         },
         {
            "Name":"DLF Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         }
      ]
   },
   {
      "Name":"Pune",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax",
      "Towns":[
     {
            "Name":"Viman Nagar",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1x4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"
         },
         {
            "Name":"Magarpatta",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1f4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bax"
         }
      ]
   }
]

I attempted to use JavaScript's map function for iteration but faced challenges in replicating the exact structure.

javascript json api

Answer 1

Answer №1

It appears that using only the map method may not be sufficient to address your issue, particularly due to the presence of nested arrays. Have you considered utilizing the map method twice instead? Here's an example scenario:

var cid = "c5d58bef-f1c2-4b7c-a6d7-f64df12321ax";
var newName = "Viman Nagar";
City = City.map(function(city) {
  city.towns = city.towns.map(function(town) {
    if (town.cid === cid)
      town.name = newName;
    return town;
  });
  return city;
});

Answer 2

It appears that using only the map method may not be sufficient to address your issue, particularly due to the presence of nested arrays. Have you considered utilizing the map method twice instead? Here's an example scenario:

var cid = "c5d58bef-f1c2-4b7c-a6d7-f64df12321ax";
var newName = "Viman Nagar";
City = City.map(function(city) {
  city.towns = city.towns.map(function(town) {
    if (town.cid === cid)
      town.name = newName;
    return town;
  });
  return city;
});

Answer 3

Answer №2

Declare your array as

const locations = [{
    "City": "Mumbai"
     ...
}]

and proceed to iterate through it

let updatedLocations = locations.map(location => location.Areas.map(area => {
    if (area.Name === "Andheri") {
        return {
            ...area,
            Name: "Bandra"
        }
    } else return area
}))

Answer 4

Declare your array as

const locations = [{
    "City": "Mumbai"
     ...
}]

and proceed to iterate through it

let updatedLocations = locations.map(location => location.Areas.map(area => {
    if (area.Name === "Andheri") {
        return {
            ...area,
            Name: "Bandra"
        }
    } else return area
}))

Answer 5

Answer №3

Utilize Array#map in the following manner:

Go through each item in the array cities
For each iteration, go through the array Towns. If the current town's cid matches the one to be changed, update its Name

const changeTownName = (cities = [], cid, name) =>
  cities.map(({ Towns = [], ...props }) => ({
    ...props,
    Towns: Towns.map(town => town.cid === cid 
      ? { ...town, Name: name } 
      : { ...town }
    )
  }));

const cities = [
  { Name: 'Delhi', id: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd', Towns: [ { Name: "MG Colony", conditionId: '60d1f5eb-0222-4a84-879b-6699b0cfc1a4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd' }, { Name: "DLF Colony", conditionId: '60d1f5eb-0222-4a84-879b-7749b0cfc1a4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd' } ] },
  { Name: 'Pune', id: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax', Towns: [ { Name: "Hadapsar", conditionId: '60d1f5eb-0222-4a84-879b-6699b0cfc1x4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax' }, { Name: "Magarpatta", conditionId: '60d1f5eb-0222-4a84-879b-7749b0cfc1f4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bax' } ] }
];
console.log( changeTownName(cities, 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax', 'Viman Nagar') );

Answer 6

Utilize Array#map in the following manner:

Go through each item in the array cities
For each iteration, go through the array Towns. If the current town's cid matches the one to be changed, update its Name

const changeTownName = (cities = [], cid, name) =>
  cities.map(({ Towns = [], ...props }) => ({
    ...props,
    Towns: Towns.map(town => town.cid === cid 
      ? { ...town, Name: name } 
      : { ...town }
    )
  }));

const cities = [
  { Name: 'Delhi', id: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd', Towns: [ { Name: "MG Colony", conditionId: '60d1f5eb-0222-4a84-879b-6699b0cfc1a4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd' }, { Name: "DLF Colony", conditionId: '60d1f5eb-0222-4a84-879b-7749b0cfc1a4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bd' } ] },
  { Name: 'Pune', id: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax', Towns: [ { Name: "Hadapsar", conditionId: '60d1f5eb-0222-4a84-879b-6699b0cfc1x4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax' }, { Name: "Magarpatta", conditionId: '60d1f5eb-0222-4a84-879b-7749b0cfc1f4', cid: 'c5d58bef-f1c2-4b7c-a6d7-f64df12321bax' } ] }
];
console.log( changeTownName(cities, 'c5d58bef-f1c2-4b7c-a6d7-f64df12321ax', 'Viman Nagar') );

Answer 7

Answer №4

For those looking to transform a city into cities, here is some helpful code:

cities.forEach(city => {
    city.Towns = city.Towns.map(el => {
        if (el.Name === 'Hapdasar') {
            el.Name = 'Viman Nagar';
        }
        return el;
    })
});

Answer 8

For those looking to transform a city into cities, here is some helpful code:

cities.forEach(city => {
    city.Towns = city.Towns.map(el => {
        if (el.Name === 'Hapdasar') {
            el.Name = 'Viman Nagar';
        }
        return el;
    })
});

Answer 9

Answer №5

Make sure to iterate through each city and its corresponding towns in the array. If the town's cid matches the specified cid, update the town's name with the new one provided;

const myNewTownName = "Central City";
const cid = "a1b2c3d4-e5f6-7g8h9-i0j1k2l3m4n5;
for(let i = 0; i < myObj.Cities.length; i++){
    const city = myObj.Cities[i];
    for(let j = 0; j < city.Towns.length; j++){
        const town = city.Towns[j];
        if(cid === town.cid){
            town.Name = myNewTownName;
        }
        city.Towns[j] = town;//Update city with the modified town
    }
    myObj.Cities[i] = city; //Update myObj with the modified city
}

Answer 10

Make sure to iterate through each city and its corresponding towns in the array. If the town's cid matches the specified cid, update the town's name with the new one provided;

const myNewTownName = "Central City";
const cid = "a1b2c3d4-e5f6-7g8h9-i0j1k2l3m4n5;
for(let i = 0; i < myObj.Cities.length; i++){
    const city = myObj.Cities[i];
    for(let j = 0; j < city.Towns.length; j++){
        const town = city.Towns[j];
        if(cid === town.cid){
            town.Name = myNewTownName;
        }
        city.Towns[j] = town;//Update city with the modified town
    }
    myObj.Cities[i] = city; //Update myObj with the modified city
}

Answer 11

Answer №6

One way to achieve the desired result is by utilizing nested .forEach loops to iterate through both the outer and inner arrays. An if block can then be used to inspect the cid value for the specified town.

const data = {
"City":[
   {
      "Name":"Delhi",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd",
      "Towns":[
         {
            "Name":"MG Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         },
         {
            "Name":"DLF Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         }
      ]
   },
   {
      "Name":"Pune",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax",
      "Towns":[
         {
            "Name":"Hadapsar",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1x4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"
         },
         {
            "Name":"Magarpatta",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1f4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bax"
         }
      ]
   }
]

} // end data;


const targetCid = "c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"; // cid for Hadapsar;

const objArray = data.City;

objArray.forEach(element => {
  
  element.Towns.forEach(element => {  
  
    if (element.cid == targetCid) {
      element.Name = "Viman Nagar";
    } // end if;
  
  }); // next object in Towns array;

});  // next object in objArray;
  


document.getElementById('output').textContent = JSON.stringify(data, undefined, 2);

#output {
 white-space: pre;
}

<pre id="output"></pre>

Answer 12

One way to achieve the desired result is by utilizing nested .forEach loops to iterate through both the outer and inner arrays. An if block can then be used to inspect the cid value for the specified town.

const data = {
"City":[
   {
      "Name":"Delhi",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd",
      "Towns":[
         {
            "Name":"MG Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         },
         {
            "Name":"DLF Colony",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1a4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bd"
         }
      ]
   },
   {
      "Name":"Pune",
      "id":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax",
      "Towns":[
         {
            "Name":"Hadapsar",
            "conditionId":"60d1f5eb-0222-4a84-879b-6699b0cfc1x4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"
         },
         {
            "Name":"Magarpatta",
            "conditionId":"60d1f5eb-0222-4a84-879b-7749b0cfc1f4",
            "cid":"c5d58bef-f1c2-4b7c-a6d7-f64df12321bax"
         }
      ]
   }
]

} // end data;


const targetCid = "c5d58bef-f1c2-4b7c-a6d7-f64df12321ax"; // cid for Hadapsar;

const objArray = data.City;

objArray.forEach(element => {
  
  element.Towns.forEach(element => {  
  
    if (element.cid == targetCid) {
      element.Name = "Viman Nagar";
    } // end if;
  
  }); // next object in Towns array;

});  // next object in objArray;
  


document.getElementById('output').textContent = JSON.stringify(data, undefined, 2);

#output {
 white-space: pre;
}

<pre id="output"></pre>

Revamping JSON structure by identifying id references

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Answer №6

Similar questions

Tips for fading out two elements after completing a drag and drop action

Selenium - Activating a flash button

Transmitting an HTML file along with JSON data and enabling the browser to refresh the JSON data without reloading the entire

PHP web service login portal

Is the Site Header displayed depending on the scroll position and direction of scrolling?

Fixing the issue of 'Unrecognized character < in JSON at position 0 at JSON.parse'

AngularJS - Organize Item Hierarchy with Separate Containers for Each Group

What could be the reason for the error message when using rs.send with a string input?

The conditional rendering issue in Mui DataGrid's renderCell function is causing problems

Convert an R data frame into a simple JSON format

Ways to display a price near a whole number without using decimal points

What could be the reason for JSON.parse not returning the expected outcome?

The process of integrating a Loader in Javascript

Creating controller functions for rendering a form and handling the form data

Tips for incorporating a Forgot/Reset password option into your #Firebase platform

Can a PHP script be executed through an Ajax event?

Creating a selectAll checkbox that triggers the ng-click function on each individual checkbox

I seem to be having trouble properly parsing JSON data with the Gson library

React error: "Unable to locate property 'bind' within the undefined"

Using JQuery to eliminate the current div in an image slider