请求JOLT规范：将JSON数组字段值转换为对象键名

输入JSON #

{"action": {"allowPartialSuccess": false,"records": [{"recordid": "a4c6364e-4446-47d0-b014-c20ca014fdb3","ShipToCustomerTextualAddress__c": "TestAddress1","ResellerPO__c": "TestAddress1","InvoiceCDBID__c": "TestAddress1"},{"recordid": "73781a94-9660-4f69-9bde-f2bf1991317d","ShipToCustomerTextualAddress__c": "TestAddress2","ResellerPO__c": "TestAddress2","InvoiceCDBID__c": "TestAddress2"}],"type": "update"}}

期望输出JSON #

{"action": {"allowPartialSuccess": false,"records": {"a4c6364e-4446-47d0-b014-c20ca014fdb3": {"ShipToCustomerTextualAddress__c": "TestAddress1","ResellerPO__c": "TestAddress1","InvoiceCDBID__c": "TestAddress1"},"73781a94-9660-4f69-9bde-f2bf1991317d": {"ShipToCustomerTextualAddress__c": "TestAddress2","ResellerPO__c": "TestAddress2","InvoiceCDBID__c": "TestAddress2"}},"type": "update"}}

对应的JOLT转换规格 #

[
  {
    "operation": "shift",
    "spec": {
      "action": {
        "allowPartialSuccess": "action.allowPartialSuccess",
        "type": "action.type",
        "records": {
          "*": {
            "recordid": {
              "@(2)": "action.records.&"
            }
          }
        }
      }
    }
  },
  {
    "operation": "remove",
    "spec": {
      "action": {
        "records": {
          "*": {
            "recordid": ""
          }
        }
      }
    }
  }
]

规则说明 #

• Shift操作：遍历action.records数组的每个元素，以元素的recordid值作为键，将整个元素映射到action.records下的对应键位置，同时保留allowPartialSuccess和type字段不变。
• Remove操作：清除每个目标对象里的recordid字段，只保留业务相关字段。

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