Блог

У меня есть SAP Idoc с дополнительными специфичными для клиента полями в виде JSON

 {
  "E1EDL20": [
    {
      "VBELN": "1234567890",
      "VSTEL": "ZO01",
      "LGNUM": "123",
      "NTGEW": "100.660",
      "ANZPK": "00002",
      "/XYZ/XYZ1234_E1EDL20": {
        "ACTION": "POSTED",
        "CONSIGNMENT": "12345678",
        "FREIGHT_ORDER_EXTERNAL": "S123456789",
        "IN_YARD": "X",
        "IN_YARD_DATE": "20201123",
        "IN_YARD_TIME": "100923"
      },
      "E1ADRM1": [
        {
          "PARTNER_Q": "LF",
          "PARTNER_ID": "0000100000",
          "/XYZ/XYZ1234_E1ADRM1": {
            "SUPPLIER": "X"
          }
        },
        {
          "PARTNER_Q": "OSP",
          "PARTNER_ID": "ZO01",
          "/XYZ/XYZ1234_E1ADRM1": {
            "SUPPLIER": "X"
          }
        }
      ]
    }
  ]
}
 

Затем я попытался удалить корневой массив, переименовать поля и выполнить преобразование типов строк в Integer, Double и Boolean и объединение поля даты и времени в метку времени. Вот моя спецификация.

 [
  // Our E1EDL20 array has only one entry -> remove array
  {
    "operation": "cardinality",
    "spec": {
      "E1EDL20": "ONE"
    }
  },
  // Move all contained fields to root level and properly rename them
  {
    "operation": "shift",
    "spec": {
      "E1EDL20": {
        "VBELN": "deliveryInternal",
        "VSTEL": "receivingPoint",
        "LGNUM": "warehouseNumber",
        "NTGEW": "netWeight",
        "ANZPK": "numberOfPackages",
        "/XYZ/XYZ1234_E1EDL20": {
          "ACTION": "action",
          "CONSIGNMENT": "consignment",
          "FREIGHT_ORDER_EXTERNAL": "freightOrderExternal",
          // Rename Content of the field to Boolean String
          "IN_YARD": {
            "X": { "#true": "inYard" },
            "*": { "#false": "inYard" }
          },
          "IN_YARD_DATE": "inYardDateTmp",
          "IN_YARD_TIME": "inYardTimeTmp"
        },
        // Suppliers
        "E1ADRM1": {
          "*": {
            "PARTNER_Q": "supplier[amp;1].type",
            "PARTNER_ID": "supplier[amp;1].number",
            "/XYZ/XYZ1234_E1ADRM1": {
              "SUPPLIER": {
                "X": { "#true": "supplier[amp;2].supplier" },
                "*": { "#false": "supplier[amp;2].supplier" }
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      // Type conversions, String to Double or Integer
      "netWeight": ["=toDouble", null],
      "numberOfPackages": ["=toInteger", null],
      // Type conversions, String to Boolean
      "inYard": ["=toBoolean"],
      "supplier": {
        "*": {
          "belomSupplier": ["=toBoolean"]
        }
      }
    }
  },
  {
    // Create Timestamp for inYardDate
    "operation": "modify-default-beta",
    "spec": {
      "temp_DateYear": "=substring(@(1,inYardDateTmp),0,4)",
      "temp_DateMonth": "=substring(@(1,inYardDateTmp),4,6)",
      "temp_DateDay": "=substring(@(1,inYardDateTmp),6,8)",
      "temp_TimeHours": "=substring(@(1,inYardTimeTmp),0,2)",
      "temp_TimeMinutes": "=substring(@(1,inYardTimeTmp),2,4)",
      "temp_TimeSeconds": "=substring(@(1,inYardTimeTmp),4,6)",
      // Prior to this line, only temporary fields were created from substrings as preparation for the timestamp concatenateion
      "inYardDate": "=concat(@(1,temp_DateYear),'-',@(1,temp_DateMonth),'-',@(1,temp_DateDay),'T',@(1,temp_TimeHours),':',@(1,temp_TimeMinutes),':',@(1,temp_prodTimeSeconds),'Z')"
    }
},
  {
    // Remove temporary substring fields
    "operation": "remove",
    "spec": {
      "temp_DateYear": "",
      "temp_DateMonth": "",
      "temp_DateDay": "",
      "temp_TimeHours": "",
      "temp_TimeMinutes": "",
      "temp_TimeSeconds": "",
      "inYardDateTmp": "",
      "inYardTimeTmp": ""
    }
    }
]
 

Я ожидал после преобразования JOLT следующего вывода.

 {
  "deliveryInternal" : "1234567890",
  "receivingPoint" : "ZO01",
  "warehouseNumber" : "123",
  "netWeight" : 100.66,
  "numberOfPackages" : 2,
  "action" : "POSTED",
  "consignment" : "12345678",
  "freightOrderExternal" : "S123456789",
  "inYard" : true,
  "inYardDate" : "2020-11-23T10:09:Z",
  "supplier" : [ {
    "type" : "LF",
    "number" : "0000100000",
    "supplier" : true
  }, {
    "type" : "OSP",
    "number" : "ZO01",
    "supplier" : true
  } ]
}
 

Но я получаю следующий вывод.

 {
  "deliveryInternal" : "1234567890",
  "receivingPoint" : "ZO01",
  "warehouseNumber" : "123",
  "netWeight" : 100.66,
  "numberOfPackages" : 2,
  "action" : "POSTED",
  "consignment" : "12345678",
  "freightOrderExternal" : "S123456789",
  "inYard" : true,
  "supplier" : [ {
    "type" : "LF",
    "number" : "0000100000"
  }, {
    "type" : "OSP",
    "number" : "ZO01"
  } ],
  "inYardDate" : "2020-11-23T10:09:Z"
}
 

У кого-нибудь есть идея, как можно решить проблему?

Вы просто пытаетесь добавить supplier: true к своим поставщикам? Я не мог видеть никаких других различий, кроме этого. Если это так, вы можете добавить это в конец спецификации вашей цепочки:

 {
    // Add supplier = true to supplier elements
    "operation": "shift",
    "spec": {
      "supplier": {
        "*": {
          "#true": "supplier[amp;1].supplier",
          "*": "supplier[amp;1].amp;"
        }
      },
      "*": "amp;"
    }
}