Transform Flat JSON to an array

[marcoconnor-virtustream]

Hi all, need help with what's probably a basic transform, but can't find an example.

Here's my input and desired output:

INPUT

{ "1": "Value1", "2": "Value2", "3": "Value3" }

Desired Output

{ "to": "table_name", "data" [ { "1": { "value": "Value1" }, "2": { "value": "Value2" }, "3": { "value": "Value3" } } ] }

Thanks!

[DhruvSingh861]

I think this will help :)

[
  {
    "operation": "shift",
    "spec": {
      "#table_name": "to",
      "*": {
        "@": "data[#3].&0.value"
      }
    }
  }
]