通过 JOLT 处理器转换键值中的 JSON 数据

Question

我有以下输入，我想通过 jolt 处理器转换预期输出中的数据

输入

json prettyprint-override">{
  "tenantId": "master",
  "transactionId": "838",
  "alertArray": [
    {
      "alertType": "info",
      "priority": "low",
      "data": "new",
      "properties": [
        {
          "ConnectorID": "1",
          "ConnectorType": "IEC_60309",
          "IDTag": "A5270529",
          "abc": "xyz",
          "pqr": "rst",
          "bals": "ahjdgcd"
        }
      ]
    }
  ]
}

预期产量

{
  "tenantId": "master",
  "transactionId": "838",
  "alertArray": [
    {
      "alertType": "info",
      "priority": "low",
      "data": "new",
      "properties": [
        {
          "key": "ConnectorID",
          "value": "2"
        },
        {
          "key": "ConnectorType",
          "value": "IEC_60309"
        },
        {
          "key": "DTag",
          "value": "A5270529"
        },
        {
          "key": "abc",
          "value": "xyz"
        },
        {
          "key": "pqr",
          "value": "rst"
        },
        {
          "key": "bals",
          "value": "ahjdgcd"
        }
      ]
    }
  ]
}

我们有包含属性的数据，数组包含一对数据，我想把这对数据转换成键和值

Answer 1

您可以在深入研究properties数组下的属性后使用此移位转换，并使用@和 符号分别匹配val和key对

[
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "alertA*": {
        "*": {
          "*": "&2[&1].&", //&2 is to substitute "alertArray" after going tree 2 levels up along with its indexes([&1]), and the rightmost & is replicates the current level's values 
          "pro*": {
            "*": {
              "*": {
                "$": "&5[&4].&3[#2].key", // &5 : "alertArray", [&4] : indexes of "alertArray", &3 : "properties", indexes of "properties"
                "@": "&5[&4].&3[#2].value"
              }
            }
          }
        }
      }
    }
  }
]

该网站上的演示http://jolt-demo.appspot.com/是：