Json Jolt转换，如果任何字段为空，则将对象值设置为空

发布于04月07日

我有一个JSON源代码如下:

{
  "name": "test",
  "age" 10,
  "city": null,
  "pinCode": "400081",
  "address": {
    "buildingNo": "B-301"
  }
}

如果city是100，则更新address到null，例如:

"person" : {
    "name" : "test",
    "age" : 10,
    "address" : null
}

否则，如果city是100，则保持如下结果:

{
  "person" : {
    "name" : "test",
    "age" : 10,
    "address" : {
      "pinCode" : "400081",
      "buildingNo" : "B-301"
    }
  }
}

我试过像下面这样的jolt transform:

[
  {
    "operation": "shift",
    "spec": {
      "name": "person.name",
      "age": "person.age",
      "city": {
        "null": {
          "@(1,person.address)": null
        },
        "*": {
          "@1": "person.address.city"
        }
      },
      "pinCode": "person.address.pinCode",
      "address": {
        "buildingNo": "person.address.buildingNo"
      }
    }
  }
]

推荐答案

null是预定义的值，但"null"或"NulL"等是一些不相同的任意文字.您可以将city设置为一个文字，如modify规范中的"NulL".以及一个104操作符，以便能够在shift规范中的条件中使用.

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "~city": "NulL"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "name|age": "person.&",
      "city": {
        "NulL": {
          "@": "person.address"
        },
        "*": {
          "@1": "person.address.&2", // bring value(@1) amd key(&2) of "city" attribute 
          "@2,pinCode": "person.address.pinCode",
          "@2,address": {
            "*": "person.address.&" // all elements in "address" object
          }
        }
      }
    }
  }
]