使用颠簸变换取消嵌套数组

Question

我正在尝试转换一个包含数组的JSON对象，并将数据卸载为单独的JSON。基本上，我需要为数组的每个元素创建一个对象，并复制所有外部数据。示例：

输入

{
  "id": 3435,
  "startTime": "2019-10-30T10:00:00Z",
  "sportType": "FOOTBALL",
  "participants": [
    {
      "id": 1234,
      "name": "Team A",
      "position": "HOME"
    },
    {
      "id": 5678,
      "name": "Team B",
      "position": "AWAY"
    }
  ]
}

预期产出

{
  "id": 3435,
  "startTime": "2019-10-30T10:00:00Z",
  "sportType": "FOOTBALL",
  "participant_id": 1234,
  "participant_name": "Team A"
  "participant_position": "HOME"
},
{
  "id": 3435,
  "startTime": "2019-10-30T10:00:00Z",
  "sportType": "FOOTBALL",
  "participant_id": 5678,
  "participant_name": "Team B"
  "participant_position": "AWAY"
}  

我尝试的规格:

[
  {
    "operation": "shift",
    "spec": {
      "id": "newID",
      "startTime": "startTime",
      "sportType": "sportType",
      "participants": {
        "*": {
          "id": "participant.&1.participant_id",
          "name": "participant.&1.participant_name",
          "position": "participant.&1.participant_position"
        }
      }
    }
  }
]

我对 Jolt 很陌生，并尝试了几个不起作用的规格。我在取消嵌套部分时遇到问题。谢谢你的帮助。

Answer 1

这个规范应该有效:

[
  {
    "operation": "shift",
    "spec": {
      "participants": {
        "*": {
          "id": "[#2].participant_id",
          "name": "[#2].participant_name",
          "position": "[#2].participant_position",
          "@(2,id)": "[#2].id",
          "@(2,startTime)": "[#2].startTime",
          "@(2,sportType)": "[#2].sportType"
        }
      }
    }
  }
]

为了完整起见，ForkRecord和FlattenJson做了与上述规范类似的事情，使用这些规范可能比尝试找出JOLT规范更容易。