我试图使用 JOLT 将 json 从一种 JSON 格式转换为另一种 JSON 格式,但我无法获得预期的输出。我在下面列出了我的工作。任何帮助将不胜感激。谢谢。我的 input.json{ "Result": { }, "Content": [ { "MovieDetails": [ { "Key": "TicketNumber", "Value": "DF-0001" }, { "Key": "MovieName", "Value": "Test" } ] }, { "MovieDetails": [ { "Key": "TicketNumber", "Value": "DF-0002" }, { "Key": "MovieName", "Value": "Test2" } ] }, { "MovieDetails": [ { "Key": "TicketNumber", "Value": "DF-0003" }, { "Key": "MovieName", "Value": "Test3" } ] } ]}我的预期输出.json{"Result": {},"Content": [ { "MovieDetails": { "TicketNumber": "DF-0001", "MovieName": "Test1" }, "MovieDetails": { "TicketNumber": "DF-0002", "MovieName": "Test2" }. "MovieDetails": { "TicketNumber": "DF-0003", "MovieName": "Test3" } }]} 我的实际输出.json{"Result": {},"Content": [ { "MovieDetails": { "TicketNumber": ["DF-0001","DF-0002","DF-0003"], "MovieName": ["Test1","Test2","Test3"] } }]} 我的 Spec.json[ { "operation": "shift", "spec": { "Result": { "*": "Result.&" }, "Content": { "*": { "MovieDetails": { "*": { "Value": "Content.MovieDetails.@(1,Key)" } } } } } }]
1 回答

青春有我
TA贡献1784条经验 获得超8个赞
最终与以下规格一起工作...
[
{
"operation": "shift",
"spec": {
"Result": "Result",
"Content": {
"*": {
"MovieDetails": {
"*": {
"Value": "Content[&3].MovieDetails.@(1,Key)"
}
}
}
}
}
}
]
添加回答
举报
0/150
提交
取消