Jolt将复杂json转换成平面json

Question

我希望Jolt将一个复杂的json转换为下面所需的json。

输入JSON:

{
  "Rating": 1,
  "SecondaryRatings": [
    {
      "Design": 4,
      "Price": 2,
      "RatingDimension3": 1,
      "Arr1": [
        {
          "Val1": 34
        },
        {
          "Val2": 45
        }
      ]
    },
    {
      "Design": 44,
      "Price": 23,
      "RatingDimension3": 12,
      "Arr1": [
        {
          "Val1": 56
        },
        {
          "Val2": 22
        }
      ]
    }
  ]
}

输出量的希望值

json prettyprint-override">[
  {
    "Design": 4,
    "Price": 2,
    "RatingDimension3": 1,
    "rating-primary": 1,
    "Val1": 34,
    "Val2": 45
  },
  {
    "Design": 44,
    "Price": 23,
    "RatingDimension3": 12,
    "rating-primary": 1,
    "Val1": 56,
    "Val2": 22
  }
]

我试过遵循Jolt Spec

[
  {
    "operation": "shift",
    "spec": {
      "SecondaryRatings": {
        "*": {
          "*": {
            "*": {
              "@(2,Design)": "[&3].Design",
              "@(2,Price)": "[&3].Price",
              "@(2,RatingDimension3)": "[&3].RatingDimension3",
              "Val1": "[&3].Val1",
              "Val2": "[&3].Val2",
              "@(4,Rating)": "[&3].rating-primary"
            }
          }
        }
      }
    }
  }
]

但得到了以下输出

[ 
 {
   "Design" : [ 4, 4, 4, 4, 4 ],
   "Price" : [ 2, 2, 2, 2, 2 ],
   "RatingDimension3" : [ 1, 1, 1, 1, 1 ],
   "rating-primary" : [ 1, 1, 1, 1, 1 ],
   "Val1" : 34,
   "Val2" : 45
 }, 
 {
   "Design" : [ 44, 44, 44, 44, 44 ],
   "Price" : [ 23, 23, 23, 23, 23 ],
   "RatingDimension3" : [ 12, 12, 12, 12, 12 ],
   "rating-primary" : [ 1, 1, 1, 1, 1 ],
   "Val1" : 56,
   "Val2" : 22
  } 
]

因此，正如所见，除了最后一个级别值之外，所有其他值都具有具有重复值的数组。任何人都可以帮助解决 Jolt 规范中缺失或错误的地方吗？

Answer 1

您可以直接遍历外部数组的索引（SecondaryRatings）而不是内部数组的索引

[
  {
    "operation": "shift",
    "spec": {
      "SecondaryRatings": {
        "*": {
          "*": "[&1].&",
          "@(2,Rating)": "[&].rating-primary",
          "Arr1": {
            "*": {
              "*": "[&3].&"
            }
          }
        }
      }
    }
  }
]

在这种情况下，除了Rating之外，无需单独编写所有元素