如何使用Jolt遍历列表替换元素实现银行卡号掩码处理

输入JSON #

{
  "clients": [
    {
      "clientId": "166734",
      "info": {
        "cards": [
          "378282246310005",
          "371449635398431"
        ]
      }
    }
  ]
}

Jolt转换规则 #

[
  {
    "operation": "shift",
    "spec": {
      "clients": {
        "*": {
          "clientId": "clients[&1].clientId",
          "info": {
            "cards": {
              "*": "clients[&3].info.cards[&1]"
            }
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "clients": {
        "*": {
          "info": {
            "cards": {
              "*": "=concat(substring(@(1),0,4), '*****', substring(@(1), -4))"
            }
          }
        }
      }
    }
  }
]

输出结果 #

{
  "clients": [
    {
      "clientId": "166734",
      "info": {
        "cards": [
          "3782*****0005",
          "3714*****8431"
        ]
      }
    }
  ]
}

规则说明 #

• Shift操作：保留原有JSON层级结构，确保clientId和cards的父子关系不变，为后续修改卡号格式铺垫。
• Modify-overwrite-beta操作：遍历所有银行卡号，通过substring截取卡号前4位和后4位，再用concat拼接中间的*****，完成掩码替换。

内容的提问来源于stack exchange，提问作者Alice