JOLT根据值删除并保留其余的json键

idv4meu8  于 2023-11-20  发布在  其他
关注(0)|答案(2)|浏览(147)

下面是我的JSON,我需要JOLT删除,如果destSiteName是未知的。需要保留对象的其余部分。

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

字符串

dm7nw8vv

dm7nw8vv1#

您可以使用包含两个条件的shift转换

  • 最外层属性是否为**"destSiteName""*"**)

*"destSiteName"的值是否为"unknown""*"

[
  {
    "operation": "shift",
    "spec": {
      "destSiteName": {
        "unknown": "",
        "*": { "@1": "&2" }
      },
      "*": "&"
    }
  }
]

字符串

rseugnpd

rseugnpd2#

{
  "operation": "shift",
  "spec": {
    "destSiteName": {
      "unknown": null,
      "*": "&"
    },
    "*": "&"
    }
  },
  {
    "operation": "remove",
    "spec": {
      "destSiteName": ""
   }
 }

字符串

相关问题