我正在尝试将包含数组的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,"participant_id": 1234,"participant_name": "Team A"
"participant_position": "HOME"
},{
"id": 3435,"participant_id": 5678,"participant_name": "Team B"
"participant_position": "AWAY"
}
我尝试过的SPEC:
[
{
"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感到很陌生,并尝试了一些SPECS,但没有成功。我在嵌套部分遇到了麻烦。谢谢您的帮助。