manidlou
commented
7 years ago @Lazarus118, in order to get the food value, if we assume that you already know the structure of your json file, and that's something like what you posted,
{
"data": [
{
"email": " ",
"products": [],
"username": " "
},
{
"email": " ",
"products": [
{
"actual_food_amount": "15",
"amount": "20",
"drink": "Local Drink ",
"food": "Dasheen meal w/ codfish",
"id": 2,
"location": "Orchard Restaurant"
}
]
}
]
}then you can do something like the following to get an array of all the food values
'use strict';
const jf = require('jsonfile')
// return an array of all the food values async
function getFood(file, cb) {
var fvals = []
jf.readFile(file, (err, obj) => {
if (err) return cb(err)
obj.data.forEach((dat) => {
if (dat.products && Array.isArray(dat.products) && dat.products.length > 0) {
dat.products.forEach((prod) => {
if (prod.food && prod.food.length > 0 && fvals.indexOf(prod.food) === -1) {
fvals.push(prod.food)
}
})
}
})
return cb(null, fvals)
})
}
// return an array of all the food values sync
function getFoodSync(file) {
try {
var fvals = []
jf.readFileSync(file).data.forEach((dat) => {
if (dat.products && Array.isArray(dat.products) && dat.products.length > 0) {
dat.products.forEach((prod) => {
if (prod.food && prod.food.length > 0 && fvals.indexOf(prod.food) === -1) {
fvals.push(prod.food)
}
})
}
})
return fvals
} catch (err) {
throw err
}
}then, you can use the functions simply like this,
// get food vals async
getFood('/path/to/your/json/file', (err, vals) => {
if (err) {
console.error(err)
} else {
console.dir(vals)
}
})
// get food vals sync
try {
console.dir(getFoodSync('/path/to/your/json/file'))
} catch (err) {
console.error(err)
}
lazarusvc
jprichardson
Okay but what if it's in the format :
{ "data": [ { "email": " ", "products": [ ], "username": " " }, { "email": " ", "products": [ { "actual_food_amount": "15", "amount": "20", "drink": "Local Drink ", "food": "Dasheen meal w/ codfish", "id": 2, "location": "Orchard Restaurant" } ] } } and I want to read "food"