JOLT 规范 - 将数组转置为类

Question

我需要通过使用JOLT规范来转换JSON结构。我用https://jolt-demo.appspot.com来测试以下内容。

我还可以通过另一个JOLT规范运行OUTPUT，然后检索我所需的JSON输出，但我仍然不知道JOLT规格应该是什么样子，我已经看过了示例，没有进一步了解上面提到的内容。

输入-

这是输入 JSON

{
  "result": 0,
  "companys": [
    {
      "id": 3,
      "pId": 322,
      "nm": "Balfin Trading (PTY) LTD"
    },
    {
      "id": 25,
      "pId": 0,
      "nm": "FootCam"
    }
  ],
  "vehicles": [
    {
      "id": 487,
      "desc": null,
      "ic": 2,
      "nm": "GCS001",
      "pnm": null,
      "dl": [
        {
          "id": "60335",
          "ic": 0,
          "us": null,
          "md": 361,
          "tn": "",
          "vt": null,
          "io": "",
          "isb": null,
          "sim": "0726168807",
          "cc": 4,
          "dId": null,
          "sdc": null,
          "pid": 83,
          "st": null,
          "tc": 0,
          "cn": "ROAD,CAB,R SIDE VIEW,L SIDE VIEW",
          "nflt": null
        }
      ],
      "adt": null,
      "pvg": null,
      "djb": null,
      "etm": null,
      "pid": 83,
      "phone": null,
      "abbr": null,
      "vtp": null,
      "st": null,
      "dt": null,
      "dn": null,
      "linesOperation": null
    },
    {
      "id": 486,
      "desc": null,
      "ic": 2,
      "nm": "GCS002",
      "pnm": null,
      "dl": [
        {
          "id": "60334",
          "ic": 0,
          "us": null,
          "md": 361,
          "tn": "",
          "vt": null,
          "io": "",
          "isb": null,
          "sim": "0767024106",
          "cc": 4,
          "dId": null,
          "sdc": null,
          "pid": 83,
          "st": null,
          "tc": 0,
          "cn": "ROAD,CAB,R SIDE,L SIDE",
          "nflt": null
        }
      ],
      "adt": null,
      "pvg": null,
      "djb": null,
      "etm": null,
      "pid": 83,
      "phone": null,
      "abbr": null,
      "vtp": null,
      "st": null,
      "dt": null,
      "dn": null,
      "linesOperation": null
    },
    {
      "id": 491,
      "desc": null,
      "ic": 2,
      "nm": "GCS003",
      "pnm": null,
      "dl": [
        {
          "id": "60294",
          "ic": 0,
          "us": null,
          "md": 361,
          "tn": "",
          "vt": null,
          "io": "",
          "isb": null,
          "sim": "0795732047",
          "cc": 4,
          "dId": null,
          "sdc": null,
          "pid": 83,
          "st": null,
          "tc": 0,
          "cn": "ROAD,CAB,R SIDE,L SIDE",
          "nflt": null
        }
      ],
      "adt": null,
      "pvg": null,
      "djb": null,
      "etm": null,
      "pid": 83,
      "phone": null,
      "abbr": null,
      "vtp": null,
      "st": null,
      "dt": null,
      "dn": null,
      "linesOperation": null
    }
  ]
}

这是我目前拥有的雷震天赋

[
  {
    "operation": "shift",
    "spec": {
      "vehicles": {
        "*": {
          "nm": "name",
          "dl": {
            "*": {
              "id": "deviceID"
            }
          }
        }
      }
    }
   }
]

给出以下输出

{
  "name" : [ "GCS001", "GCS002", "GCS003" ],
  "deviceID" : [ "60335", "60334", "60294" ]
}

相反，我要求输出是

[{
    "name" : "GCS001", 
    "deviceID" : "60335"
},
{
    "name" : "GCS002", 
    "deviceID" : "60334"
},
{
    "name" : "GCGCS003S001", 
    "deviceID" : "60294"
}]

Answer 1

[
  {
    "operation": "shift",
    "spec": {
      "vehicles" : {
        "*" : {
          "@(0,nm)" : "[&1].name",
          "dl" : {
            "*" : {
              "@(0,id)" : "[&3].deviceID"
            }
          }
        }
      }
    }
  }
]

Answer 2

你们离得很近。我做了什么 - 将名称和设备ID放入t对象，并在另一个规范中删除了该对象的名称。

[
  {
    "operation": "shift",
    "spec": {
      "vehicles": {
        "*": {
          "nm": "t[&1].name",
          "dl": {
            "*": {
              "id": "t[&3].deviceID"
            }
          }
        }
      }
    }
   },
  {
    "operation": "shift",
    "spec": {
      "t": ""
    }
  }
]