Question 287550 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

JOLT Remove based on value and keep rest of the json keys

Below is my JSON and i need JOLT to remove if destSiteName is unknown. Need to keep the rest of the object.

{
  "destSiteName": "unknown",
  "customer_code": "code1"
}
Tags:

2

Answers


  1. 0 
    {
  "operation": "shift",
  "spec": {
    "destSiteName": {
      "unknown": null,
      "*": "&"
    },
    "*": "&"
    }
  },
  {
    "operation": "remove",
    "spec": {
      "destSiteName": ""
   }
 }
    Login or Signup to reply.
  2. 0

    You might use a shift transformation which contains two conditionals

    • whether outermost attribute is "destSiteName" or not ( "*" )

    or

    • whether value of "destSiteName" is "unknown" or not ( "*" )
    [
  {
    "operation": "shift",
    "spec": {
      "destSiteName": {
        "unknown": "",
        "*": { "@1": "&2" }
      },
      "*": "&"
    }
  }
]
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search