Create sensor data from json file

Configuration
1

I receive energy data from my P1 cable in the form of a json. This is the part of the output of said data, but seperated monthly:

[
   {
      "CONSUMPTION_DELTA_KWH": 73.28300000000135,
      "CONSUMPTION_GAS_DELTA_M3": 15.736000000000104,
      "CONSUMPTION_GAS_M3": 1749.255,
      "CONSUMPTION_KWH_HIGH": 3458.681,
      "CONSUMPTION_KWH_LOW": 4372.907,
      "PRODUCTION_DELTA_KWH": 2.510000000000218,
      "PRODUCTION_KWH_HIGH": 4725.154,
      "PRODUCTION_KWH_LOW": 1968.589,
      "TIMESTAMP_UTC": 1672527600,
      "TIMESTAMP_lOCAL": "2023-01-01 00:00:00"
   },
   {
      "CONSUMPTION_DELTA_KWH": 289.6369999999947,
      "CONSUMPTION_GAS_DELTA_M3": 125.817,
      "CONSUMPTION_GAS_M3": 1733.519,
      "CONSUMPTION_KWH_HIGH": 3412.274,
      "CONSUMPTION_KWH_LOW": 4345.865,
      "PRODUCTION_DELTA_KWH": 12.928000000000011,
      "PRODUCTION_KWH_HIGH": 4723.441,
      "PRODUCTION_KWH_LOW": 1967.792,
      "TIMESTAMP_UTC": 1669849200,
      "TIMESTAMP_lOCAL": "2022-12-01 00:00:00"
   }
]

How can I fill a sensor so, for instance, the “CONSUMPTION_GAS_M3” can be used in charts etc? I can create a sensor per month, but that creates 12 extra sensors and is unusable in charts. I’m sure there is a simpler way to achieve this.

2

To achieve what exactly? What is your expectation?
Which integration do you use to get this data?

3

You can put the whole output in attributes of a single (!) sensor and then use advanced graphs to collect the data, e.g. apex charts or plotly

4

This is historical data that I pull directly from my energy meter in a json API web call. Currently this data is not present in HA and I’m looking for a way to convert this to a monthly bar chart in Apex Charts.