从具有公共父级的嵌套数组值构造唯一数组

Question

对JQ: Nested JSON transformation来说，这可能是个很难回答的问题，但我没能把我的头绕过去。

示例JSON:

"value": [
{
  "FeatureStatus": [
    {
      "FeatureName": "Sway1",
      "FeatureServiceStatus": "ServiceOperational"
    },
    {
      "FeatureName": "Sway2",
      "FeatureServiceStatus": "ServiceDegraded"
    }
  ],
  "Id": "SwayEnterprise",
},
{
  "FeatureStatus": [
    {
      "FeatureName": "yammerfeatures",
      "FeatureServiceStatus": "ServiceOperational"
    }
  ],
  "Id": "yammer"
}
]

我想要做的是用jq创建一个输出，结果如下；

{"Sway":"Sway1":"ServiceOperational"},
{"Sway":"Sway2":"ServiceDegraded"},
{"Yammer":"yammerfeatures":"ServiceOperational"}

我的各种尝试要么以数以千计的非唯一(即带有摇摆状态的Yammer )结束，要么只有一个Id与x号的FeatureServiceStatus。

任何指示都将不胜感激。我看过了教程和食谱。我使用jq大概有2.5天了。

Answer 1

假设已添加了封闭大括号以使输入有效的JSON，则过滤器：

.value[]
| [.Id] + (.FeatureStatus[] | [ .FeatureName, .FeatureServiceStatus ])

生产：

["SwayEnterprise","Sway1","ServiceOperational"]
["SwayEnterprise","Sway2","ServiceDegraded"]
["yammer","yammerfeatures","ServiceOperational"]

然后，您可以根据需要轻松地重新格式化。