从数组进行JOLT转换

Question

我正在进行转换，在我将输入定义为数组之前，它工作正常。我当前的（工作！）示例是：INPUT

{
  "trainerName": "Nahuel",
  "trainingName": "1st Training",
  "trainee1firstName": "Martin",
  "trainee2firstName": "Para"
}

使用此JOLT规范：

[
  {
    "operation": "shift",
    "spec": {
      "trainerName": "trainerName",
      "trainingName": "training.[0].trainingName",
      "trainee1*": "training.[0].trainees.[0].&(0,1)",
      "trainee2*": "training.[0].trainees.[1].&(0,1)"
    }
  }
]

输出是：

{
  "trainerName" : "Nahuel",
  "training" : [ {
    "trainingName" : "1st Training",
    "trainees" : [ {
      "firstName" : "Martin"
    }, {
      "firstName" : "Para"
    } ]
  } ]
}

这很完美，但是:我真正期望的输入是这样的:

[
  {
    "rowNumber": 1,
    "trainerName": "Nahuel",
    "trainingName": "1st Training",
    "trainee1firstName": "Martin",
    "trainee2firstName": "Para"
  },
  {
    "rowNumber": 2,
    "trainerName": "Nahuel",
    "trainingName": "2nd Training",
    "trainee1firstName": "Greg",
    "trainee2firstName": "Thomas"
  }
]

我需要这样的输出:

{
    "trainerName": "Nahuel",
    "training": [{
            "trainingName": "1st Training",
            "trainees": [{
                "firstName": "Martin"
            }, {
                "firstName": "Para"
            }]
        },
        {
            "trainingName": "2nd Training",
            "trainees": [{
                "firstName": "Greg"
            }, {
                "firstName": "Thomas"
            }]
        }
    ]
}

我将在每个数组对象中接收“trainerName”，但我只需要使用一个。

你能帮我找出解决办法吗？我正在寻找几种解决方案，但找不到适合此示例的解决方案。

非常感谢提前！贝斯！

Answer 1

你的说明几乎是正确的。您需要拥有< code>[

也为trainName采取的第一元素使用修改覆盖测试操作。

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "trainerName": "trainerName",
        "trainingName": "training.[&1].trainingName",
        "trainee1*": "training.[&1].trainees.[0].&(0,1)",
        "trainee2*": "training.[&1].trainees.[1].&(0,1)"
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "trainerName": "=firstElement(@(1,trainerName))"
    }
  }
]