JOLT JSON 转换未按预期工作
我试图使用 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回答
-
青春有我
最终与以下规格一起工作...[ { "operation": "shift", "spec": { "Result": "Result", "Content": { "*": { "MovieDetails": { "*": { "Value": "Content[&3].MovieDetails.@(1,Key)" } } } } } }]
随时随地看视频慕课网APP
相关分类
Python