请求提供含嵌套数组的JSON转换JOLT规范

输入JSON #

{"hasMore":"true","totalResults":2000,"count":2,"limit":2,"offset":0,"columns":["CITY","ADDRESS_COUNTRY"],"data":[["Waltham","US"],["Delhi","IND"]]}

期望输出JSON #

{"hasMore":"true","totalResults":2000,"count":2,"limit":2,"offset":0,"columns":["CITY","ADDRESS_COUNTRY"],"data":[{"inner_array":["Waltham","US"]},{"inner_array":["Delhi","IND"]}]}

JOLT转换规范 #

[
  {
    "operation": "shift",
    "spec": {
      "*": "&",
      "data": {
        "*": {
          "@": "data[&1].inner_array"
        }
      }
    }
  }
]

规范说明 #

• *: "&"：保留所有顶层原有字段（hasMore、totalResults等），确保这些字段原样输出。
• data节点下的*：遍历data数组中的每一个子数组元素。
• "@": "data[&1].inner_array"：将当前遍历到的子数组（@代表当前元素），映射到data数组对应索引位置（&1表示父级的索引）的inner_array键下，完成子数组的包裹需求。

内容的提问来源于stack exchange，提问作者Nitinamg