JOLT变换-模式匹配

2024-05-20 • 问答

Input:
{
  "items": [
    {
      "itemId": "1234500AA","additionalData": "12345|20001|3000"
    }
  ]
}

Spec:
Spec:
[
  {
    "operation": "shift","spec": {
      "items": {
        "*": {
          "itemId": "ID","additionalData": {
            "*|*|*": {
              "$(0,1)": ["cartMenuItems[&3].baseProductId","cartMenuItems[&3].mdmId"],"$(0,2)": "cartMenuItems[&3].code",3)": "cartMenuItems[&3].sku"
            }
          }
        }
      }
    }
  }
]

Ouput Expected:
{
  "ID" : "1234500AA","cartMenuItems" : [ {
    "baseProductId" : "12345","mdmId" : "12345","code" : "20001","sku" : "3000"
  } ]
}

但是，出现如下错误： JOLT Chainr在构造索引为0的Transform classname：com.bazaarvoice.jolt.Shiftr时遇到异常。

震动似乎不喜欢| （因为您需要对其进行转义），可以替换|：

[
  {
    "operation": "modify-overwrite-beta","spec": {
      "items": {
        "*": {
          "additionalDataTemp": "=split('\\|',@(1,additionalData))","additionalData": "=concat(@(1,additionalDataTemp[0]),'_',additionalDataTemp[1]),additionalDataTemp[2]))"
        }
      }
    }
  },{
    "operation": "shift","spec": {
      "items": {
        "*": {
          "itemId": "ID","additionalData": {
            "*_*_*": {
              "$(0,1)": ["cartMenuItems[&3].baseProductId","cartMenuItems[&3].mdmId"],"$(0,2)": "cartMenuItems[&3].code",3)": "cartMenuItems[&3].sku"
            }
          }
        }
      }
    }
  }
]

或者另一种方式是：

[
  {
    "operation": "modify-overwrite-beta","spec": {
      "items": {
        "*": {
          "additionalData": "=split('\\|',"baseProductId": "@(1,additionalData[0])","mdmId": "@(1,"code": "@(1,additionalData[1])","sku": "@(1,additionalData[2])"
        }
      }
    }
    },"*": "cartMenuItems.&"
        }
      }
    }
    },{
    "operation": "remove","spec": {
      "cartMenuItems": {
        "additionalData": ""
      }
    }
    }

]

JOLT变换-模式匹配

wduke8818 回答：JOLT变换-模式匹配

大家都在问