Json 如何在jolt中使用shift和modifyoverwritebeta

发布于01月25日

我想知道如何使用SHIFT和MODIFY-OVERWRITE-BETA进行以下输入.请给我explain how it works分的答案.

Input:个

[
  {
    "data": {
      "firstName": "Leanne",
      "lastName": "Graham",
      "id": 111
    }
  },
  {
    "data": {
      "firstName": "Ervin",
      "lastName": "Howell",
      "id": 222
    }
  }
]

Desired output:个

{
  "111": {
    "fullName": "Leanne Graham"
  },
  "222": {
    "fullName": "Ervin Howell"
  }
}

推荐答案

你可以用不同的方法来解决这个问题.

1. This spec is more understandable:个

在shift操作中，以值id为关键字对列表进行排序:@(1,id)
modify-overwrite-beta运算中的连接firstName和lastName:=concat(@(1,firstName),' ',@(1,lastName))
删除remove操作中未使用的关键点:id, firstName, lastName

[
  {
    "operation": "shift",
    "spec": {
      "*": { // index of the array: 1, 2
        "*": { // data object
          "*": "@(1,id).&" // value of id in the current object: 111, 222
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": { // ids: 111, 222
        "fullName": "=concat(@(1,firstName),' ',@(1,lastName))"
      }
    }
  },
  {
    "operation": "remove",
    "spec": {
      "*": { // ids: 111, 222
        "id": "",
        "firstName": "",
        "lastName": ""
      }
    }
  }
]

2. This spec is shorter:个

modify-overwrite-beta运算中的连接firstName和lastName:=concat(@(1,firstName),' ',@(1,lastName))
获取值id作为键，然后将fullname放入其中:key @(1,id).fullName,value @(0,fullName)

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "*": {
          "fullName": "=concat(@(1,firstName),' ',@(1,lastName))"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "@(0,fullName)": "@(1,id).fullName"
        }
      }
    }
  }
]

The following image can help more:个