转换数组数据的问题

Question

我正在尝试转换以下JSON数组数据结构-

从…

[
  {
    "date": "2019-01-01",
    "marks": [
      {
        "quantity": {
          "shoes": 1,
          "belt": 2,
          "socks": 3
        }
      }
    ]
  },
  {
    "date": "2019-01-02",
    "marks": [
      {
        "quantity": {
          "shoes": 4,
          "belt": 5,
          "socks": 6
        }
      }
    ]
  }
]

至

rows: [
  {
    values: [ '2019-01-01', 1, 2, 3]
  },
  {
    values: [ '2019-01-02', 4, 5, 6]
  }
]

到目前为止我能尝试的密码是-

function myFunction() {
  var response = [
    {
      "date": "2019-01-01",
      "marks": [
        {
          "quantity": {
            "shoes": 1,
            "belt": 2,
            "socks": 3
          }
        }
      ]
    },
    {
      "date": "2019-01-02",
      "marks": [
        {
          "quantity": {
            "shoes": 4,
            "belt": 5,
            "socks": 6
          }
        }
      ]
    }
  ];
  var transform = response.map(function(dailyMarks) {
    var row = [];
    Object.keys(response).asArray().forEach(function (field) {
      switch (field) {
        case 'shoes':
          return row.push(dailyMarks.shoes);
        case 'belt':
          return row.push(dailyMarks.belt);
        case 'socks':
          return row.push(dailyMarks.socks);
        case 'date':
          return row.push(dailyMarks.date);
        default:
          return row.push('');
      }
    });
    return { values: row };
  });
  Logger.log(transform);
}

但是，我遇到了这个错误-

TypeError:无法在对象1,2中找到函数asArray (第XX行，文件“代码”)

我很确定我做错了什么，但还不知道在哪里。

目标是简单地转换上述数据结构-方法并不重要。

任何帮助都将不胜感激！谢谢。

Answer 1

在ES5中，

​

var arr1 = [
  {
    date: '2019-01-01',
    marks: [
      {
        quantity: {
          shoes: 1,
          belt: 2,
          socks: 3,
        },
      },
    ],
  },
  {
    date: '2019-01-02',
    marks: [
      {
        quantity: {
          shoes: 4,
          belt: 5,
          socks: 6,
        },
      },
    ],
  },
];
var out = [];
arr1.forEach(function(obj) {
  obj.marks.forEach(function(mark) {
    out.push({
      values: [obj.date].concat(
        Object.keys(mark.quantity).map(function(key) {
          return mark.quantity[key];
        })
      ),
    });
  });
});
console.log({ rows: out });

​

Answer 2

您可以为订单获取一个键数组，并对标记数组进行平面映射。

​

var data = [{ date: "2019-01-01", marks: [{ quantity: { shoes: 1, belt: 2, socks: 3 } }] }, { date: "2019-01-02", marks: [{ quantity: { shoes: 4, belt: 5, socks: 6 } }] }],
    keys = ['shoes', 'belt', 'socks'],
    rows = data.map(({ date, marks }) =>
        ({ values: [date, ...marks.flatMap(({ quantity }) => keys.map(k => quantity[k]))] })),
    result = { rows };

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

​

Answer 3

​

var list=[{"date":"2019-01-01","marks":[{"quantity":{"shoes":1,"belt":2,"socks":3}}]},{"date":"2019-01-02","marks":[{"quantity":{"shoes":4,"belt":5,"socks":6}}]}];

let result = list.map(( {date, marks} ) => { return {value: [date, ...Object.values(marks[0].quantity)]};});
let wrap = {rows: result};
console.log(wrap);

​