在结构的中间添加一个JSON字段

Question

我尝试在JSON结构中添加一个新字段，我需要在数组之前确定它的位置，但是规范在最后定位该字段。这是我的JSON原版和转换代码，这些代码是在JOLT转换web中编写的：

输入

{
  "Id": ">COS",
  "equipment": "ALA",
  "elementId": "M15463",
  "zone": "AMBA",
  "hub": "AVA",
  "terminalServer": "XS0156",
  "Area": "null",
  "timestamp": "1576155950000",
  "collectedData": [
    {
      "name": "llljljiouohh",
      "instance": "X1.M1.YE9.ON18",
      "value": "5",
      "unit": "db"
    }
  ]
}

JSON规范：

[
  {
    "operation": "default",
    "spec": {
      "timestamp_dt": "2022-10-14 15:00"
    }
  }
]

**结果：**

{
  "Id": ">COS",
  "equipment": "ALA",
  "elementId": "M15463",
  "zone": "AMBA",
  "hub": "AVA",
  "terminalServer": "XS0156",
  "Area": "null",
  "timestamp": "1576155950000",
  "collectedData": [
    {
      "name": "llljljiouohh",
      "instance": "X1.M1.YE9.ON18",
      "value": "5",
      "unit": "db"
    }
  ],
  "timestamp_dt": "2022-10-14 15:00"
}

期望

{
  "Id": ">COS",
  "equipment": "ALA",
  "elementId": "M15463",
  "zone": "AMBA",
  "hub": "AVA",
  "terminalServer": "XS0156",
  "Area": "null",
  "timestamp": "1576155950000",
  "timestamp_dt": "2022-10-14 15:00",
  "collectedData": [
    {
      "name": "llljljiouohh",
      "instance": "X1.M1.YE9.ON18",
      "value": "5",
      "unit": "db"
    }
  ]
}

有什么建议吗？谢谢!

Answer 1

您可以在shift转换中按所需的顺序分别写入每个键值对，例如

[
  {
    "operation": "default",
    "spec": {
      "timestamp_dt": "2022-10-14 15:00"
    }
  },
  {
    "operation": "shift",
    "spec": {
      "Id": "&",
      "equipment": "&",
      "elementId": "&",
      "zone": "&",
      "hub": "&",
      "terminalServer": "&",
      "Area": "&",
      "timestamp": "&",
      "timestamp_dt": "&",
      "collectedData": "&"
    }
  }
]