Jolt规范将json转换成名称值对

Question

我正在尝试将下面的JSON转换为名称值对：

{
  "Size": "2",
  "done": "true",
  "records": [
    {
      "Id": "a7g6s0000004GZuAAM",
      "NN": "00096411.0",
      "Name": "ISOLIN TRADE & INVEST",
      "RecordType": {
        "attributes": {
          "type": "TestType"
        },
        "Name": "Term"
      }
    },
    {
      "Id": "a7g6s0000004GZzAAM",
      "Number": "00096412.0",
      "Name": "ISOLIN"
    }
  ]
}

应为输出JSON:

{
  "Size" : "2",
  "done" : "true",
  "Items" : [ {
    "Fields" : [ {
      "Name" : "Id",
      "Value" : "a7g6s0000004GZuAAM"
    }, {
      "Name" : "NN",
      "Value" : "00096411.0"
    }, {
      "Name" : "Name",
      "Value" : "ISOLIN TRADE & INVEST"
    }, {
      "Name" : "RecordType_Name",
      "Value" : "Term"
    } ]
  }, {
    "Fields" : [ {
      "Name" : "Id",
      "Value" : "a7g6s0000004GZzAAM"
    }, {
      "Name" : "Number",
      "Value" : "00096412.0"
    }, {
      "Name" : "Name",
      "Value" : "ISOLIN"
    } ]
  } ]
}

我使用了以下jolt规范，但是< code>RecordType元素的转换不符合预期:

颠簸规格 ：

json prettyprint-override">[
  {
    "operation": "remove",
    "spec": {
      "records": {
        "*": {
          "attributes": " "
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "records": {
        "*": {
          "*": {
            "$": "Items.&2.[#2].Name",
            "@": "Items.&2.[#2].Value"
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "Items": {
        "*": {
          "*": "Items.[#2].Fields[]"
        }
      }
    }
  }
]

如何将其转换为所需的格式？

Answer 1

我认为不需要移除转换，最好为每个Field建立索引。

解决方案的诀窍是使用以下命令将RecorType属性与其他属性区分开来

“记录类型”：{“名称”：“字段

如

[
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "records": {
        "*": {
          "*": "Field&1.&", 
          "RecordType": {
            "Name": "Field&2.&1\\_&" 
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "Field*": {
        "*": {
          "$": "Items[0].&2.[#2].Name",
          "@": "Items[0].&2.[#2].Value"
        }
      }
    }
  }
]