JSON object to array with JOLT

Question

I have the following JSON object

Input:

{
  "17.39.108.85:80": [],
  "10.204.32.9:443": [
    {
      "status": "DOWN"
    }
  ]
}

and trying to transform it into a list/array as below :

Desired Output:

[
  {
    "17.39.108.85:80": []
  },
  {
    "10.204.32.9:443": [
      {
        "status": "DOWN"
      }
    ]
  }
]

What's the best way to use Jolt.

Barbaros Özhan · Accepted Answer · 2023-01-18 21:12:05Z

2

You can use this spec:

Currently, your input is correct, but you need to put each key into an array.

You can get each key in the object and send it to an array with [#2].

Note: #2 is the index of each key. for example: 17.39.108.85:80 is 0 and 10.204.32.9:443 is 1.

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "@": "[#2].&"
      }
    }
  }
]

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

answered Jan 18, 2023 at 19:37

2,7392 gold badges13 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you mohammadReza and @Barbaros Özhan This worked beautifully.