Jolt转换JSON数组保留其余字段

Question

如何在Jolt转换JSON数组中保留其他字段，我正在尝试使用通配符，但在最终输出中没有添加字段？

这是我正在使用的输入示例

[
  {
    "foundduring": "D-DC",
    "user_type": "type1",
    "location": "location1"
  },
  {
    "foundduring": "D-DG",
    "user_type": "type2",
    "location": "location2"
  },
  {
    "foundduring": "D-DI",
    "user_type": "type3",
    "location": "location3"
  }
]

我使用了下面的Jolt转换，并尝试了通配符:

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "foundduring": {
          "D-DC": {
            "#CycleCount": "[&3].foundduring"
          },
          "D-DG": {
            "#Pick": "[&3].foundduring"
          },
          "D-DI": {
            "#Issue": "[&3].foundduring"
          }
        },
        "@": "&"
      }
    }
  }
]

下面是我的预期输出，其中发生了移位操作，然后需要保持所有其他字段不变

[
  {
    "foundduring" : "CycleCount",
    "user_type" : "type1",
    "location" : "location1"
  },
   {
    "foundduring" : "Pick",
    "user_type" : "type2",
    "location" : "location2"
  },
   {
    "foundduring" : "Issue",
    "user_type" : "type3",
    "location" : "location3"
  }
]

即将到来的实际输出:

[
  {
    "foundduring": "CycleCount"
  },
  {
    "foundduring": "Pick"
  },
  {
    "foundduring": "Issue"
  }
]

Answer 1

你可以考虑另一个图书馆乔森。

https://github.com/octomix/josson

反序列化

Josson josson = Josson.fromJsonString(
    "[" +
    "  {" +
    "    \"foundduring\": \"D-DC\"," +
    "    \"user_type\": \"type1\"," +
    "    \"location\": \"location1\"" +
    "  }," +
    "  {" +
    "    \"foundduring\": \"D-DG\"," +
    "    \"user_type\": \"type2\"," +
    "    \"location\": \"location2\"" +
    "  }," +
    "  {" +
    "    \"foundduring\": \"D-DI\"," +
    "    \"user_type\": \"type3\"," +
    "    \"location\": \"location3\"" +
    "  }" +
    "]");
    

转型

JsonNode node = josson.getNode(
    "field(foundduring.caseValue('D-DC','CycleCount','D-DG','Pick','D-DI','Issue'))");
System.out.println(node.toPrettyString());

输出

[ {
  "foundduring" : "CycleCount",
  "user_type" : "type1",
  "location" : "location1"
}, {
  "foundduring" : "Pick",
  "user_type" : "type2",
  "location" : "location2"
}, {
  "foundduring" : "Issue",
  "user_type" : "type3",
  "location" : "location3"
} ]

Answer 2

考虑使用“*”通配符而不是“@”，例如

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "foundduring": {
          "D-DC": {
            "#CycleCount": "[&3].&2"
          },
          "D-DG": {
            "#Pick": "[&3].&2"
          },
          "D-DI": {
            "#Issue": "[&3].&2"
          }
        },
        "*": "[&1].&"
      }
    }
  }
]

顺便说一句，不需要获取密钥名称"发现期间"，只需使用

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