求Jolt转换规范：将嵌套JSON字符串转为目标JSON结构

开发者阿泽

2026-6-21

Jolt转换规范实现需求

源JSON

{
  "version": "123",
  "payload": {
    "details": {
      "payload_json": "{\"FName\":\"rishi\",\"LName\":\"dx\",\"Id\":\"ABC123\",\"aadharId\":\"XYZ22\"}"
    }
  }
}

目标JSON

{
  "firstName": "rishi",
  "lastName": "dx",
  "id": "ABC123",
  "officialIds": [
    {
      "type": "aadhar",
      "value": "XYZ22"
    }
  ]
}

正确的Jolt转换规范

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "payload": {
        "details": {
          "payload_json": "=parseJson"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "payload": {
        "details": {
          "payload_json": {
            "FName": "firstName",
            "LName": "lastName",
            "Id": "id",
            "aadharId": "officialIds[0].value"
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "officialIds": {
        "[0]": {
          "type": "aadhar"
        }
      }
    }
  }
]

规范说明

解析JSON字符串：第一个modify-overwrite-beta操作调用parseJson函数，把payload_json字段的字符串内容解析为JSON对象，这是后续字段映射的必要前提。
字段映射：第二个shift操作将解析后的字段对应到目标结构，同时把aadharId的值放入officialIds数组第一个元素的value字段中。
添加固定字段：第三个modify-overwrite-beta操作给officialIds数组的第一个元素添加固定的type字段，值设为aadhar。