推送一个嵌套的json数组

Question

Om跳到您的帮助前。我试图在一个嵌套的json数组中推送objekt。

json输入如下：

"result":[{"MyEnergyData_MarketDocument":{"mRID":"8000cfdc-0000-f600-b63f-84710c7967bb","createdDateTime":"2022-11-03T08:15:18Z","sender_MarketParticipantname":"","sender_MarketParticipant.mRID":{"codingScheme":null,"name":null},"period.timeInterval":{"start":"2022-06-30T22:00:00Z","end":"2022-07-04T22:00:00Z"},"TimeSeries":[{"mRID":"571313181100574632","businessType":"A04","curveType":"A01","measurement_Unit.name":"KWH","MarketEvaluationPoint":{"mRID":{"codingScheme":"A10","name":"571313181100574632"}},"Period":[{"resolution":"PT1H","timeInterval":{"start":"2022-06-30T22:00:00Z","end":"2022-07-01T22:00:00Z"},"Point":[{"position":"1","out_Quantity.quantity":"0.489","out_Quantity.quality":"A04"},{"position":"2","out_Quantity.quantity":"7.57","out_Quantity.quality":"A04"},{"position":"3","out_Quantity.quantity":"0.131","out_Quantity.quality":"A04"}

谷歌脚本如下：

var meterdatajson = Utilities.jsonParse(meterdata);
var meterdataArray = meterdatajson['result'];
var arrayProperties = [];
meterdataArray.forEach(function(el) {
arrayProperties.push([el.???????],
);});

我尝试了所有的方法，但都无法控制"开始"、"位置"one_answers"out_Quantity.quintity">

我在函数(el(中尝试了许多不同的字符串

Answer 1

您需要导航嵌套的对象。例如：

el.MyEnergyData_MarketDocument.TimeSeries[0].Period[0].Point[0].position

这会给你"；1〃；。所以你的整个循环应该是这样的：

meterdataArray.forEach(function(el) {
arrayProperties.push(
el.MyEnergyData_MarketDocument.TimeSeries[0].Period[0].Point.map(p => [
p.position,
p.out_Quantity.quantity
])
);
});

这将为您提供第一个TimeSeries/Period的[position，quantity]对数组。