JOLT转换以根据条件删除json对象

发布于10月11日

请帮助我回答下面的问题. 我有一个基于条件使用Jolt转换JSON的需求. 下面是我的输入JSON.

{
  "body": {
    "Activity": [
      {
        "attributeCode": "ABC",
        "attributeValue": "1200"
      },
      {
        "attributeCode": "DEF",
        "attributeValue": "1400"
      },
      {
        "attributeCode": "GHI",
        "attributeValue": "1600"
      }
    ],
    "NonActivity": {
      "bill": "23Oct11",
      "activityNumber": "6100"
    }
  },
  "header": {
    "id": "010400",
    "referenceNumber": "6100"
  },
  "action": "CREATE"
}

如果操作不是CREATE，那么我想完全删除"Activity[]"，如下所示:

{
  "body": {
    "NonActivity": {
      "bill": "23Oct11",
      "activityNumber": "6100"
    }
  },
  "header": {
    "id": "010400",
    "referenceNumber": "6100"
  },
  "action": "CREATE"
}

到目前为止，下面是我try 的内容，但问题是，当没有创建操作时，我得到的是一个空:


[
  {
    "operation": "shift",
    "spec": {
      "action": {
        "CREATE": {
          "@2": ""
        },
        "*": {
          "@(2,body.Activity[&])": ""
        }
      }
    }
  }
]

推荐答案

您可以使用以下转换规范:

[
  {
    "operation": "shift",
    "spec": {
      "body": {
        "@1,action": {
          "CREATE": { // if outer "action" == "CREATE"
            "@2": "&3" // @2 -- > the whole value taken from the 2 levels above(eg. the value of the "body")
                       // &3 -- > the label taken from 3 levels above( eg. "body" )   
          },
          "*": { // if outer "action" != "CREATE"
            "*|@2,NonActivity": "&3.NonActivity"
          }
        }
      },
      "*": "&" // the elements at the top level other than "body"
    }
  }
]

考虑到您可能具有"活动"和"非活动"之外的元素，最好使用以下元素:

[
  {
    "operation": "shift",
    "spec": {
      "body": {
        "Activity": "&1.&.@(2,action)", // assign a label by action's value nested within "Activity" object
        "*": "&1.&"
      },
      "*": "&"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "body": {
        "Activity": { "CREATE": "&2.&1" },
        "*": "&1.&"
      },
      "*": "&"
    }
  }
]

In case there is no field like "action": "CREATE" in the input, is there a way to tell JOLT to leave the input as is个

可以，但您可以通过添加修改默认规范并重新安排，如下所示来告诉Jolt这样做:

[
  {
    "operation": "modify-default-beta",
    "spec": {
      "action": "ReMoVe"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "body": {
        "Activity": "&1.&.@(2,action)", 
        "*": "&1.&"
      },
      "*": "&"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "body": {
        "Activity": { "CREATE": "&2.&1" },
        "*": "&1.&"
      },
      "*": "&",
      "action": { "ReMoVe": { "": "" }, "*": { "@1": "&2" } }
    }
  }
]