Json Jolt Transform
I want to parse some data from JSON using Jolt Spec. I have JSON data:
[
{
"ID": "828",
"CASE_ID": "33487784",
"PIN": "43001005357",
"INP_DATE": "1762200000000"
},
{
"ID": "829",
"CASE_ID": "33457761",
"PIN": "59001024356",
"INP_DATE": "1762200000000"
}
]
Jolt Spec:
[
{
"operation": "shift",
"spec": {
"*": {
"PIN": "keys[&1]"
}
}
},
{
"operation": "modify-overwrite-beta",
"spec": {
"PINS": "=join(',', @(1,keys))"
}
},
{
"operation": "remove",
"spec": {
"keys": ""
}
}
]
and now have result:
{
"PINS" : "43001005357,59001024356"
}
But I want this:
{
"PINS" : "'43001005357','59001024356'"
}
I used https://jolt-demo.appspot.com/ web-site for compile.
Please help.