Solved
Jolt Transform Structure
Hi, I'm trying to develop a Jolt Spec for the following transform:
JSON Input:
[
{
"randomkeyname1": "randomvalue1"
},
{
"randomkeyname11": "randomvalue11",
"randomkeyname22": "randomvalue22"
},
{
"randomkeyname111": "randomvalue111",
"randomkeyname222": "randomvalue222",
"randomkeyname333": "randomvalue333"
}
]
JSON Output:
[
{
"data": [
{
"key": "randomkeyname1",
"value": "randomkeyvalue1"
}
]
},
{
"data": [
{
"key": "randomkeyname11",
"value": "randomkeyvalue11"
},
{
"key": "randomkeyname22",
"value": "randomkeyvalue22"
}
]
},
{
"data": [
{
"key": "randomkeyname111",
"value": "randomkeyvalue111"
},
{
"key": "randomkeyname222",
"value": "randomkeyvalue222"
},
{
"key": "randomkeyname333",
"value": "randomkeyvalue333"
}
]
}
]
I've tried many things but I'm newbie to this and didn't find anyone with similar issue.
The closest result that I managed to get was with the following Spec:
[{
"operation": "shift",
"spec": {
"*": {
"*": {
"$": "data[#2].key",
"@": "data[#2].value"
}
}
}
}]
Which gave me the following output:
{
"data" : [ {
"key" : [ "randomkeyname1", "randomkeyname11", "randomkeyname111" ],
"value" : [ "randomvalue1", "randomvalue11", "randomvalue111" ]
}, {
"key" : [ "randomkeyname22", "randomkeyname222" ],
"value" : [ "randomvalue22", "randomvalue222" ]
}, {
"key" : "randomkeyname333",
"value" : "randomvalue333"
} ]
}
Note: I don't know how many values, key names nor root level arrays I'm getting, is somewhat random.
I appreciate any help or ideas, thanks in advance!

