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 avoiding simultaneous state transitions in Angular UI Router

Error: JSDOM - The document variable has not been declared

Loop through each HTML element and store it in a JavaScript array

The issue arises when the logout component fails to render even after the user has been authenticated. This problem resembles the one discussed in the React Router

Tips for resolving the issue: SyntaxError - Unexpected token import

After resizing, reordering, hiding, or showing columns in the kendo grid, the grid's data source will be set to

Using jQuery idle timeout to abort jQuery AJAX calls in Laravel 5.2

What is the significance of declaring a constant array in JavaScript?

ajax is triggering the error handler

Tips for formatting the body of a post request

Update the headers of the axios.create instance that is exported by Axios

Including a hyperlink in VUE Bootstrap for seamless user navigation

Exploring the possibilities of node-webkit: node-odbc encounters a setback

Is it possible to animate multiple SVGs on a webpage with just the click of a button?

Guide on using jq to parse an array of JSON objects

A guide to playing a series of audio files in succession using the Ionic Media plugin

Having trouble with React button conditional rendering not functioning properly

Combining items from the identical array in pairs using distinct identifiers

Angular Material Popup - Interactive Map from AGM

Step-by-step guide on utilizing User scripts with the $window.open function in AngularJS