Adding New Key Expression and Removing Existing Key Expression

You can add new key expressions to JSON data and remove existing key expressions. This page includes an example of adding and removing keys using remove and default operations together.

Input Value

{
  "Rating": 1,
  "SecondaryRatings": {
    "Design": 4,
    "Price": 2,
    "RatingDimension3": 1
  }
}

JOLT Transformation Code

In this example, first the Rating field is removed with remove operation, then the NewlyAddedField field is added with default operation.

[
  {
    "operation": "remove",
    "spec": {
      "Rating": ""
    }
  },
  {
    "operation": "default",
    "spec": {
      "NewlyAddedField": "123"
    }
  }
]

Output Value

{
  "SecondaryRatings" : {
    "Design" : 4,
    "Price" : 2,
    "RatingDimension3" : 1
  },
  "NewlyAddedField" : "123"
}