Jolt JSON转换

Question

我想转换这个JSON:

{
  "_id": "6218e53465793fa20ea11524",
  "patientorderitems": [
    {
      "poi_id": "6218e53465793fa20ea1152a",
      "patientorderlogs": [
        {
          "pol_id": "6218e53465793fa20ea1152e",
          "useruid": "61ee4995f16eebb6b7e1c644",
          "modifiedat": "2022-02-25T17:18:28Z"
        },
        {
          "pol_id": "6218e53465793fa20ea1152c",
          "useruid": "61ee4995f16eebb6b7e1c643",
          "modifiedat": "2022-02-25T17:18:28Z"
        }
      ]
    },
    {
      "poi_id": "6218e53465793fa20ea11525",
      "patientorderlogs": [
        {
          "pol_id": "6218e53465793fa20ea11529",
          "useruid": "61ee4995f16eebb6b7e1c644",
          "modifiedat": "2022-02-25T17:18:28Z"
        }
      ]
    }
  ]
}

对此JSON：

[
  {
    "_id": "6218e53465793fa20ea11524",
    "poi_id": "6218e53465793fa20ea1152a",
    "pol_id": "6218e53465793fa20ea1152e",
    "useruid": "61ee4995f16eebb6b7e1c644",
    "modifiedat": "2022-02-25T17:18:28Z"
  },
  {
    "_id": "6218e53465793fa20ea11524",
    "poi_id": "6218e53465793fa20ea1152a",
    "pol_id": "6218e53465793fa20ea1152c",
    "useruid": "61ee4995f16eebb6b7e1c643",
    "modifiedat": "2022-02-25T17:18:28Z"
  },
  {
    "_id": "6218e53465793fa20ea11524",
    "poi_id": "6218e53465793fa20ea11525",
    "pol_id": "6218e53465793fa20ea11529",
    "useruid": "61ee4995f16eebb6b7e1c644",
    "modifiedat": "2022-02-25T17:18:28Z"
  }
]

我目前正在使用该规范，但它不适合我:

[
  {
    "operation": "shift",
    "spec": {
      "patientorderitems": {
        "*": {
          "patientorderlogs": {
            "*": {
              "@(4,_id)": "[&3]._id",
              "@(2,poi_id)": "[&3].poi_id",
              "pol_id": "[&3].pol_id",
              "useruid": "[&3].useruid",
              "modifiedat": "[&3].modifiedat"
            }
          }
        }
      }
    }
  }
]

有人能给出一个规范吗？有没有关于jolt JSON的明确文档

................................................................................................................................

Answer 1

还需要一级节点。为此，您可以通过＜code＞将最内层属性的所有值预先加上

然后添加一个额外的移位转换来删除不需要的键名和包装对象的方括号。

因此，您可以使用以下规格：

json prettyprint-override">[
  {
    "operation": "shift",
    "spec": {
      "patientorderitems": {
        "*": {
          "patientorderlogs": {
            "*": {
              "@(4,_id)": "&1.[&3]._id",
              "@(2,poi_id)": "&1.[&3].poi_id",
              "*": "&1.[&3].&" // combine all innermost attributes by "*" wildcard
            }
          }
        }
      }
    }
  },
  {
   //get rid of indexes and wrapper brackets
    "operation": "shift",
    "spec": {
      "*": {
        "*": ""
      }
    }
  }
]

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