我正在使用JOLT将SON数组转换为SON数组,但无法按预期进行转换.我有以下输入json(简化):
{
"object": {
"settings": [
{
"key": {
"id": 1
},
"rec": {
"value": "value 1"
}
},
{
"key": {
"id": 2
},
"rec": {
"value": "value 2"
}
},
{
"key": {
"id": 3
},
"rec": {
"value": "value 3"
}
}
],
"customer": [
{
"key": {
"id": 4
},
"rec": {
"address": "some address"
}
}
]
},
"date": "2024"
}
我想将所有对象的记录转换为这样的扁平数组
[ {
"date" : "2024",
"id" : 4,
"address" : "some address"
}, {
"date" : "2024",
"id" : 1,
"value" : "value 1"
}, {
"date" : "2024",
"id" : 2,
"value" : "value 2"
}, {
"date" : "2024",
"id" : 3,
"value" : "value 3"
} ]
我最新的try 是以下震动:
[
{
"operation": "shift",
"spec": {
"object": {
"customer": {
"*": {
"@3,date": "[&1].[0].date",
"key": {
"id": "[&2].[0].id"
},
"rec": {
"address": "[&2].[0].address"
}
}
},
"settings": {
"*": {
"@3,date": "[&1].[1].date",
"key": {
"id": "[&2].[1].id"
},
"rec": {
"value": "[&2].[1].value"
}
}
}
}
}
},
{
"operation": "shift",
"spec": {
"*": {
"@0": {
"*": "[&1]"
}
}
}
}
]
但结果是:
[ [ {
"date" : "2024",
"id" : 4,
"address" : "some address"
}, {
"date" : "2024",
"id" : 1,
"value" : "value 1"
} ], {
"date" : "2024",
"id" : 2,
"value" : "value 2"
}, {
"date" : "2024",
"id" : 3,
"value" : "value 3"
} ]
请帮忙修复.提前感谢.