主页 / coding / 问题 / 78947910
Accepted
Mark Avreliy
Asked: 2024-09-04 17:33:44 +0800 CST

在 JOLT 中将数字键存储为具有新键名的值

  • 772

源 JSON：

{
  "data": {
    "campaign": {
      "104": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "reach_impression": "6.0000000",
              "unique_impression": 6,
              "impression": 9
            }
          },
          "2024-07-03": {
            "metrics": {
              "reach_impression": "19.0000000",
              "unique_click": 1,
              "reach_click": "2.0000000"
            }
          }
        }
      },
      "106": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "unique_click": 29,
              "reach_click": "29.0000000",
              "click": 35
            }
          }
        }
      },
      "124": {
        "day": {
          "2024-07-01": {
            "metrics": {
              "unique_impression": 472,
              "event": 1,
              "unique_click": 25,
              "click": 49,
              "progress_100": 1,
              "impression": 690
            }
          },
          "2024-07-03": {
            "metrics": {
              "unique_click": 14,
              "reach_click": "52.0000000",
              "click": 33,
              "unique_impression": 28,
              "impression": 32
            }
          }
        }
      }
    },
    "metrics": {
      "click_average": 22107.6666666667
    }
  },
  "metadata": {
    "campaign": {
      "104": {
        "channel_id": 1,
        "real_end_date": null,
        "channel_label": "Display",
        "real_start_date": "2024-01-11 21:32:25",
        "label": "5ka_Promo_veer_2024"
      },
      "124": {
        "channel_id": 1,
        "real_end_date": null,
        "channel_label": "Display",
        "real_start_date": "2024-06-04 21:34:23",
        "label": " X5Club_Evergreen_June24"
      }
    }
  }
}

下面data.campaign有一些数字，如 124、104、106。这些数字是活动的 ID。我需要将这些值存储在字段中id，然后我们有字段day，并且在这个字段中2024-07-01，我想将这些值存储为report_date字段。在这个级别下，我们有metrics对象。在这个对象中，我想获取所有键值对。

对我来说主要的问题是如何以正确的方式将数字存储为键。

预期 JSON：

[
  {
    "id": 124,
    "report_date": "2024-07-01",
    "unique_impression": 472,
    "event": 1,
    "unique_click": 25,
    "click": 49,
    "progress_100": 1,
    "impression": 690
  },
  {
    "id": 124,
    "report_date": "2024-07-03",
    "unique_click": 14,
    "reach_click": "52.0000000",
    "click": 33,
    "unique_impression": 28,
    "impression": 32
  },
  {
    "id": 104,
    "report_date": "2024-07-01",
    "reach_impression": "6.0000000",
    "unique_impression": 6,
    "impression": 9
  },
  {
    "id": 104,
    "report_date": "2024-07-03",
    "reach_impression": "19.0000000",
    "unique_click": 1,
    "reach_click": "2.0000000"
  },
  {
    "id": 106,
    "report_date": "2024-07-01",
    "unique_click": 29,
    "reach_click": "29.0000000",
    "click": 35
  }
]
json

1 个回答

  1. Best Answer

    您可以使用以下转换，其中$通配符（在左侧）复制从其各自级别获取的对象键，并通过右侧所述的叶节点文字构造键值对，例如：

    [
  {
    "operation": "shift",
    "spec": {
      "data": {
        "campaign": {
          "*": {
            "day": {
              "*": {
                "metrics": {
                  "$3": "&4_&2.id",
                  "$1": "&4_&2.report_date",
                  "*": "&4_&2.&"
                }
              }
            }
          }
        }
      }
    }
  },
  {//make id values unquoted
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "id": "=toInteger"
      }
    }
  },
  {//get rid of object keys
    "operation": "shift",
    "spec": {
      "*": "[]"
    }
  }
]
    • 1

相关问题