Jolt transformation array

0
votes

I have this JSON for input: 

{
  "id": 1031435,
  "event_id": "Formula_257",
  "formula_id": 257,
  "ts_start": 1583164200084000,
  "ts_end": 1583164484960000,
  "type": "formula",
  "details": {
    "6aa0734f-6d6a-4b95-8a2b-2dde346f9df7": {
      "PowerActiveTriPhase": 183836912
    }
  },
  "ack_ts": null,
  "ack_user": null
}

and I need to get this kind of output: 

{
  "id": 1031435,
  "event_id": "Formula_257",
  "formula_id": 257,
  "ts_start": 1583164200084000,
  "ts_end": 1583164484960000,
  "type": "formula",
  "equipment_id":"6aa0734f-6d6a-4b95-8a2b-2dde346f9df7",
  "parameter":"PowerActiveTriPhase",
  "value":183836912,
  "ack_ts": null,
  "ack_user": null
}

What kind of spec do I need to use?

Thanks a lot!

1
jsonjolt

1 Answers

0
votes

This should work

[
  {
    "operation": "shift",
    "spec": {
      "id": "id",
      "event_id": "event_id",
      "formula_id": "formula_id",
      "ts_start": "ts_start",
      "ts_end": "ts_end",
      "type": "type",
      "details": {
        "*": {
          "$": "equipment_id",
          "*": {
            "$": "parameter",
            "@": "value"
          }
        }
      },
      "ack_ts": "ack_ts",
      "ack_user": "ack_user"
    }
  }
]