json - 如何使用 JOLT 转换组合两个数组

Question

我对颠簸转换不是很熟悉，我正在寻求帮助。

输入JSON如下：

{
  "2021-03-01": {
    "hours": 0
  },
  "2021-03-02": {
    "hours": 0
  },
  "2021-03-03": {
    "hours": 6.31
  },
  "2021-03-04": {
    "hours": 6.49
  },
  "2021-03-05": {
    "hours": 0
  }
}

所需的输出如下：

[
  {
    "day": "2021-03-01",
    "hours": 0
  },
  {
    "day": "2021-03-02",
    "hours": 0
  },
  {
    "day": "2021-03-03",
    "hours": 6.31
  },
  {
    "day": "2021-03-04",
    "hours": 6.49
  },
  {
    "day": "2021-03-05",
    "hours": 0
  }
]

任何帮助表示赞赏。谢谢

标签： jsonjolt

Answer 1

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "hours": "obj.hours",
        "$": "obj.day"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "day": {
          "*": "[&].day"
        },
        "hours": {
          "*": "[&].hours"
        }
      }
    }
  }
]