I have JSON:
{
"row0" : {
"ID" : 136501,
"impressionsAll" : 15002401,
"clicksAll" : 312718
},
"row1" : {
"ID" : 388288,
"impressionsAll" : 28007952,
"clicksAll" : 334596
}
}
How can I exclude row0 and row1 from top level? Names can be different, but always start with row.... And can I transform it to array? Desired output:
[
{
"ID" : 136501,
"impressionsAll" : 15002401,
"clicksAll" : 312718
},
{
"ID" : 388288,
"impressionsAll" : 28007952,
"clicksAll" : 334596
}
]
>Solution :
You can just use such a shift transformation
[
{
"operation": "shift",
"spec": {
"*": ""
}
}
]
