我試圖使用 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
提交
取消