如何使用JOLT Notation实现JSON格式转换？

输入JSON #

{
  "sid": "1",
  "poste": "MapRecord[{altitude=473.0, latitude=49.92665, poste=Libramont, longitude=5.36080}]",
  "mtime": "2023-07-12T01:00:00Z",
  "tsa": "17.2",
  "tha": "16.2",
  "hra": "90.2",
  "tsf": "15.8",
  "tss": "21.4",
  "ens": "0.0",
  "dvt": "319.6",
  "vvt": "0.9",
  "plu": "0.0",
  "hct": "60.0"
}

期望输出JSON #

{
  "Date": "2023-03-14 01:00:00",
  "stationname": "Libramont",
  "data": [
    {
      "code": "tsa",
      "value": "9.0"
    },
    {
      "code": "tha",
      "value": "7.8"
    },
    {
      "code": "hra",
      "value": "85.0"
    },
    {
      "code": "tsf",
      "value": "0.0"
    },
    {
      "code": "tss",
      "value": "0.0"
    },
    {
      "code": "ens",
      "value": "0.0"
    },
    {
      "code": "dvt",
      "value": "0"
    },
    {
      "code": "vvt",
      "value": "4.8"
    },
    {
      "code": "plu",
      "value": "0.1"
    },
    {
      "code": "hct",
      "value": "26.0"
    }
  ]
}

转换需求 #

• 将tsa、tha、hra等度量字段转为键值对形式存入data数组
• 移除poste字段的冗余内容，从中提取出stationname（如示例中的Libramont）
• 空值统一转换为0
• 对日期字段进行格式化，将原mtime的YYYY-MM-DDTHH:MM:SSZ格式转为YYYY-MM-DD HH:MM:SS格式

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