transformation of nested array in array by jolt

Question

I have following JSON data . I want to transform following data by Jolt nifi processor into result data

{
  "alert_array": {
    "alerts": [
      {
        "alertId": "alt001",
        "severity": "High",
        "alert_type": "Alert"
      },
      {
        "alertId": "alt002",
        "severity": "High",
        "alert_type": "Alert"
      }
    ]
  }
}

result data

{
  "alert_array": [
    {
      "Id": "alt001",
      "speed": "High",
      "type": "Alert"
    },
    {
      "Id": "alt002",
      "speed": "High",
      "type": "Alert"
    }
  ]
}

please help to write spac of jolt transformation

Barbaros Özhan · Accepted Answer · 2022-06-28 06:56:37Z

1

If you wouldn't rename the attributes, then using

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "*": "&2[&]"  // &2 represents going two levels up to get the literal "alert_array"
        }
      }
    }
  }
]

would suffice.

the demo on the site http://jolt-demo.appspot.com/ is

But in your case, you need to qualify each one individually such as

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "*": {
            "alert*": "&3[&1].&(0,1)",
            "severity": "&3[&1].speed",
            "alert_*": "&3[&1].&(0,1)"
          }
        }
      }
    }
  }
]

the demo on the site http://jolt-demo.appspot.com/ is

edited Jun 28, 2022 at 6:56

answered Jun 28, 2022 at 6:47

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

transformation of nested array in array by jolt

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related