用多个嵌套对象Flatten数组

Question

我有一个这样的数组，我希望它是平坦的，以便用它生成一个excel，但我不能得到超过两个层次的平坦。这是我的数据:

[
{
"idClient":1,
"clientName":"Client One",
"numItems":72,
"projects":[
{
"idProject":1,
"projectName":"Project One",
"numItems":72,
"languages":[
{
"sourceLanguage":26,
"sourceLanguageName":"Spanish",
"numItems":72,
"targets":[
{
"targetLanguage":74,
"targetLanguageName":"English",
"numItems":36,
"numItemsSold":30,
},
{
"targetLanguage":20,
"targetLanguageName":"French",
"numItems":36,
"numItemsSold":7,
}
]
}
]
}
]
},
{
"idClient":1,
"clientName":"Client One",
"numItems":50,
"projects":[
{
"idProject":1,
"projectName":"Project Two",
"numItems":50,
"languages":[
{
"sourceLanguage":26,
"sourceLanguageName":"Spanish",
"numItems":50,
"targets":[
{
"targetLanguage":74,
"targetLanguageName":"English",
"numItems":30,
"numItemsSold":3,
},
{
"targetLanguage":20,
"targetLanguageName":"French",
"numItems":20,
"numItemsSold":7,
}
]
}
]
}
]
}
]

我想要的是生成一个简单的字符串列表，每个目标一行，类似于:

[
{"Client One", "Proyect One", "Spanish", "English", "36", "30" },
{"Client One", "Proyect One", "Spanish", "French", "36", "7" },
{"Client One", "Proyect Two", "Spanish", "English", "30", "3" },
{"Client One", "Proyect Two", "Spanish", "English", "20", "7" },
]

在互联网和stackoverflow上，我发现了一些有趣的函数，就像这个，但我不能超越语言属性:

const fn = arr =>
arr.flatMap(({ projects, ...rest }) =>
projects.map(o => ({
...rest,
...o,
}))
);

任何帮助将不胜感激。由于以防

Answer 1

我认为您将不得不flatMaptargets以上的所有数组，像这样:

let data = [
{
"idClient":1,
"clientName":"Client One",
"numItems":72,
"projects":[
{
"idProject":1,
"projectName":"Project One",
"numItems":72,
"languages":[
{
"sourceLanguage":26,
"sourceLanguageName":"Spanish",
"numItems":72,
"targets":[
{
"targetLanguage":74,
"targetLanguageName":"English",
"numItems":36,
"numItemsSold":30,
},
{
"targetLanguage":20,
"targetLanguageName":"French",
"numItems":36,
"numItemsSold":7,
}
]
}
]
}
]
},
{
"idClient":1,
"clientName":"Client One",
"numItems":50,
"projects":[
{
"idProject":1,
"projectName":"Project Two",
"numItems":50,
"languages":[
{
"sourceLanguage":26,
"sourceLanguageName":"Spanish",
"numItems":50,
"targets":[
{
"targetLanguage":74,
"targetLanguageName":"English",
"numItems":30,
"numItemsSold":3,
},
{
"targetLanguage":20,
"targetLanguageName":"French",
"numItems":20,
"numItemsSold":7,
}
]
}
]
}
]
}
]
const fn = arr =>
arr.flatMap(({ projects, ...rest }) =>
projects.flatMap(({languages, ...rest1}) => 
languages.flatMap(({targets, ...rest2}) => {
return targets.map(t => ({...t, ...rest, ...rest1, ...rest2}))
})
)
);

data = fn(data);
console.log(data);

这将为您提供扁平的键值对。