请求生成JOLT映射规则：实现指定字段到目标JSON路径的映射

以下是满足需求的JOLT转换规则：

[
  {
    "operation": "shift",
    "spec": {
      "PURCHASE_ORDER_DISPATCH": {
        "MsgData": {
          "Transaction": {
            "PO_POD_HDR_EVW1": {
              "PO_ID": "integration-inbound:IntegrationDetails.integrationEntities.integrationEntity.integrationEntityDetails.poDetails.poHeader.externalId",
              "PO_POD_LN_EVW1": {
                "WG_REQ_ID": "integration-inbound:IntegrationDetails.integrationEntities.integrationEntity.integrationEntityDetails.poDetails.poHeader.poDescription",
                "PO_POD_SHP_EVW1": {
                  "FREIGHT_TERMS": "integration-inbound:IntegrationDetails.integrationEntities.integrationEntity.integrationEntityDetails.poDetails.poHeader.deliveryTermCode"
                }
              }
            }
          }
        }
      },
      "#UPSERT": "integration-inbound:IntegrationDetails.integrationEntities.integrationEntity.integrationEntityHeader.action"
    }
  }
]

规则说明： #

• shift操作：负责将输入JSON中指定路径的字段精准映射到输出的目标路径，完全匹配你需要的三个字段转换关系。
• #UPSERT：通过JOLT常量语法直接生成固定字段action并赋值为UPSERT，无需额外操作。

输入JSON： #

{
  "PURCHASE_ORDER_DISPATCH": {
    "MsgData": {
      "Transaction": {
        "PO_POD_HDR_EVW1": {
          "VENDOR_SETID": "WCOS",
          "PO_ID": 25052,
          "PO_POD_LN_EVW1": {
            "WG_REQ_ID": 25694,
            "PO_POD_SHP_EVW1": {
              "FREIGHT_TERMS": "FOBDEST",
              "BUSINESS_UNIT": "OFIC"
            }
          }
        }
      }
    }
  }
}

预期输出JSON： #

{
  "integration-inbound:IntegrationDetails": {
    "integrationEntities": {
      "integrationEntity": {
        "integrationEntityHeader": {
          "action": "UPSERT"
        },
        "integrationEntityDetails": {
          "poDetails": {
            "poHeader": {
              "poDescription": 25694,
              "deliveryTermCode": "FOBDEST",
              "externalId": 25052
            }
          }
        }
      }
    }
  }
}

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