Extract data from specific JSON field, use it as variable, and update the field value?

Question

I need to change the origin value to lat/lang coordinate (from another geoJson file) instead of country name:

index = [
  {
    "Name": "Aish Merahrah",
    "Origin": "Egypt",
    "Description": "Made with fenugreek seeds and maize; dough allowed to 
ferment overnight, then flattened and baked."
  },
  {
    "Name": "Ajdov Kruh",
    "Origin": "Slovenia",
    "Description": "Made with buckwheat flour and potato."
  }
]

so the result would be something like:

  {
    "Name": "Ajdov Kruh",
    "Origin": "46.151241, 14.995463",
    "Description": "Made with buckwheat flour and potato."
  }

I'm not sure about the workflow, do I need to extract the JSON value variable and somehow use that variable to obtain lat & lang data? Btw I need to use only JS/JQuery and Node.

Are you asking how to extract the lat/lOng, or how to modify the contents of `index`? — Scott Hunter, Jun 14 '18 at 11:09
@ScottHunter Modify the content of index (by changing **origin value** to lat/lang) depends on its original country name. — pploypiti, Jun 14 '18 at 11:13
How are you getting the values for lat/lang? How do you know that the value is for Slovenia and not some other place? Where is the connection? — Nikhil Aggarwal, Jun 14 '18 at 11:21
@NikhilAggarwal the json array is something like `"Slovenia": "46.151241, 14.995463", "Egypt": "26.820553, 30.802498"` so yeah the field name is connected. — pploypiti, Jun 14 '18 at 11:24

score 2 · Answer 1 · answered Jun 14 '18 at 11:27

Use Array.forEach

let index = [{"Name":"Aish Merahrah","Origin":"Egypt","Description":"Made with fenugreek seeds and maize; dough allowed to ferment overnight, then flattened and baked."},{"Name":"Ajdov Kruh","Origin":"Slovenia","Description":"Made with buckwheat flour and potato."}];
let lat = {"Slovenia": "46.151241, 14.995463", "Egypt": "26.820553, 30.802498"};
index.forEach(o => o.Origin = lat[o.Origin] ?  lat[o.Origin] :  o.Origin); 
console.log(index);

score 0 · Accepted Answer · answered Jun 14 '18 at 11:13

0

Assuming your geoJson has the following structure (country name as key and lat/long as value):

geolocation = {"Slovenia": "46.151241, 14.995463", "Egypt": "1, 1"}

You can use Array.prototype.map to iterate on index and replacing Origin of each object with the values from geolcoation.

index = [
  {
    "Name": "Aish Merahrah",
    "Origin": "Egypt",
    "Description": "Made with fenugreek seeds and maize; dough allowed to ferment overnight, then flattened and baked."
  },
  {
    "Name": "Ajdov Kruh",
    "Origin": "Slovenia",
    "Description": "Made with buckwheat flour and potato."
  }
]
geolocation = {"Slovenia": "46.151241, 14.995463", "Egypt": "1, 1"};
result = index.map(function(obj) { obj['Origin'] = geolocation[obj['Origin']]; return obj }); 
console.log(result);

You can even use forEach to iterate above and it will still change the index, since changes are done in reference objects.

answered Jun 14 '18 at 11:13

kiddorails

12,961
2
32
41

Thx :) Is there any way I could use file path instead of the array? like `index = './index.json'` or sorta? – pploypiti Jun 14 '18 at 11:34
depends, `index.js` file has to export an array in that structure using `module.exports` ; only and only then you can do `index = require('./index.js')` – kiddorails Jun 14 '18 at 11:36
Sorry, I mean index.json, does it works in the same way? – pploypiti Jun 14 '18 at 11:37
I meant json*** – pploypiti Jun 14 '18 at 11:39
try searching for it, answers like https://stackoverflow.com/a/10011078/1376448 can help. it's out of scope of this question – kiddorails Jun 14 '18 at 11:42

score 0 · Answer 3 · answered Jun 14 '18 at 11:15

Just iterate over the object indices and then edit the values with your values.

Assume the given JSON data:

// Creates an Object
let index = [
  {
    "Name": "Aish Merahrah",
    "Origin": "Egypt",
    "Description": "Made with fenugreek seeds and maize; dough allowed to ferment overnight, then flattened and baked."
  },
  {
    "Name": "Ajdov Kruh",
    "Origin": "Slovenia",
    "Description": "Made with buckwheat flour and potato."
  }
]

console.log(`Original Origin 1: ${index[0].Origin}\nOriginal Origin 2: ${index[1].Origin}`);

// Iterate over indices
for(let i=0;i<index.length;i++) {
  // Edit the value
  index[i].Origin = "1234/1234"
}

/*
// Using forEach
index.forEach((elem) => {
  elem.Origin = "Your Value";
});
*/

console.log(`Edited Origin 1: ${index[0].Origin}\nEdited Origin 2: ${index[1].Origin}`);

Extract data from specific JSON field, use it as variable, and update the field value?

3 Answers3