API Data in Energy Dashboard

Hello,

i am trying to find the best way to show my data from my PV/Battery in the Energy Dashboard.
API Request is working, but i have no idea, how the best way is to integrate data into the dasboard

with curl i get this data back

{“power_consumption”:{“value”:null,“time”:“2023-07-06T08:29:20.002Z”},“power_consumption_calc”:{“value”:530,“time”:“2023-07-06T08:35:25.003Z”},“power_production”:{“value”:982,“time”:“2023-07-06T08:35:25.003Z”},“power_storage”:{“value”:-508,“time”:“2023-07-06T08:35:25.003Z”},“power_grid”:{“value”:56,“time”:“2023-07-06T08:35:25.003Z”},“power_charging_stations”:{“value”:null,“time”:“2023-07-06T08:29:20.002Z”},“power_heating”:{“value”:null,“time”:“2023-07-06T08:29:20.002Z”},“power_appliances”:{“value”:530,“time”:“2023-07-06T08:29:20.002Z”},“state_of_charge”:{“value”:98,“time”:“2023-07-06T08:29:20.002Z”},“self_sufficiency”:{“value”:95,“time”:“2023-07-06T08:35:25.003Z”},“max_network_utilization”:17000.0,“consumers_total_count”:0,“consumers_online_count”:0,“producers_total_count”:1,“producers_online_count”:1,“storages_total_count”:1,“storages_online_count”:1,“heatings_total_count”:0,“heatings_online_count”:0,“charging_points_total_count”:0,“charging_points_online_count”:0,“grids_total_count”:1,“grids_online_count”:1}

also http request is possible:

{
“power_consumption”: {
“value”: null,
“time”: “2023-07-06T08:29:20.002Z”
},
“power_consumption_calc”: {
“value”: 2326,
“time”: “2023-07-06T08:56:45.007Z”
},
“power_production”: {
“value”: 2716,
“time”: “2023-07-06T08:56:45.007Z”
},
“power_storage”: {
“value”: -256,
“time”: “2023-07-06T08:56:45.007Z”
},
“power_grid”: {
“value”: -134,
“time”: “2023-07-06T08:56:45.007Z”
},
“power_charging_stations”: {
“value”: null,
“time”: “2023-07-06T08:29:20.002Z”
},
“power_heating”: {
“value”: null,
“time”: “2023-07-06T08:29:20.002Z”
},
“power_appliances”: {
“value”: 2326,
“time”: “2023-07-06T08:29:20.002Z”
},
“state_of_charge”: {
“value”: 99,
“time”: “2023-07-06T08:41:45.007Z”
},
“self_sufficiency”: {
“value”: 100,
“time”: “2023-07-06T08:56:20.003Z”
},
“max_network_utilization”: 17000,
“consumers_total_count”: 0,
“consumers_online_count”: 0,
“producers_total_count”: 1,
“producers_online_count”: 1,
“storages_total_count”: 1,
“storages_online_count”: 1,
“heatings_total_count”: 0,
“heatings_online_count”: 0,
“charging_points_total_count”: 0,
“charging_points_online_count”: 0,
“grids_total_count”: 1,
“grids_online_count”: 1
}

has anyone a good advice how to get this data in entity ids and get it automated into the energy dashboard?

regards
markus