如何将自定义的JSON对象转换为高级图表系列数据？

Question

我有一个来自API结尾的自定义JSON格式，我需要将它转换成High图表系列数据格式，

我的定制Json格式：

[{
        "personId": "7b9b19a8-0052-4036-9d27-721371a3a077",
        "pid": "PID-2",
        "averageCycleTime": 1.28,
        "idealCycleTime": 1.28,
        "cycleDetails": [{
                "cycleId": "fdc074a0-e839-4a93-bdca-93562788fd8d",
                "visionCycleId": "2",
                "cycleDuration": 12.5,
                "actionDetails": null
            },
            {
                "cycleId": "85d5b577-306f-4d69-9649-732ddfc7b228",
                "visionCycleId": "1",
                "cycleDuration": 12.5,
                "actionDetails": null
            }
        ]
    },
    {
        "personId": "f2a2d7b1-e099-4f78-8bfd-804158d21b09",
        "pid": "PID-1",
        "averageCycleTime": 1.28,
        "idealCycleTime": 1.28,
        "cycleDetails": [{
                "cycleId": "5860c566-cbf9-4d36-be1e-21e27402e8c1",
                "visionCycleId": "1",
                "cycleDuration": 12.5,
                "actionDetails": null
            },
            {
                "cycleId": "7acf1cab-7d55-412e-8381-102d5aad0a3a",
                "visionCycleId": "2",
                "cycleDuration": 12.5,
                "actionDetails": null
            }
        ]
    }
]

从上面有关"cycleDetails“键值的JSON详细信息来看，应该将其放在下面

series: [{
        name: 'Cycle-1',
        data: [{y:5, videoID : 'Video1'}, {y: 3, videoID : 'Video2'}],
    }, {
        name: 'Cycle-2',
        data: [{y:5, videoID : 'Video1'}, {y: 3, videoID : 'Video2'}]
    }]

** CycleDuration on Y和cycleId on。

Answer 1

试试这个：

const customJson = [
  {
    personId: '7b9b19a8-0052-4036-9d27-721371a3a077',
    pid: 'PID-2',
    averageCycleTime: 1.28,
    idealCycleTime: 1.28,
    cycleDetails: [
      {
        cycleId: 'fdc074a0-e839-4a93-bdca-93562788fd8d',
        visionCycleId: '2',
        cycleDuration: 12.5,
        actionDetails: null,
      },
      {
        cycleId: '85d5b577-306f-4d69-9649-732ddfc7b228',
        visionCycleId: '1',
        cycleDuration: 12.5,
        actionDetails: null,
      },
    ],
  },
  {
    personId: 'f2a2d7b1-e099-4f78-8bfd-804158d21b09',
    pid: 'PID-1',
    averageCycleTime: 1.28,
    idealCycleTime: 1.28,
    cycleDetails: [
      {
        cycleId: '5860c566-cbf9-4d36-be1e-21e27402e8c1',
        visionCycleId: '1',
        cycleDuration: 12.5,
        actionDetails: null,
      },
      {
        cycleId: '7acf1cab-7d55-412e-8381-102d5aad0a3a',
        visionCycleId: '2',
        cycleDuration: 12.5,
        actionDetails: null,
      },
    ],
  },
];

const series = customJson.map((value, key) => {
  return {
    name: `Cycle-${key + 1}`,
    data: value.cycleDetails.map((v) => ({
      y: v.cycleDuration,
      videoId: v.cycleId,
    })),
  };
});