Bonjour,
Je cherche à intégrer les données d’un compteur d’eau Diehl G3 LoRaWAN.
Je récupère des données decodées 2 fois par jour sous forme du JSON ci dessous :
{
"device_id":"32211",
"deveui":"90dffb818724b4f2",
"device_name":"Compteur EF",
"datetime":"2024-12-07T08:15:26+00:00",
"timestamp":"1733559326",
"payload_deciphered":"BA090308000004000DFC0300E400000000000000859D000000C59D00D6B39D9000BC7400E3970085C10459000003441A216349",
"data":{
"columns":[
"at",
"type",
"ref",
"value"
],
"values":[
[
1733529600,
"Meter",
"Multi_Fluid|0|IVolume",
261.133
],
[
1733558400,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733554800,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733551200,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733547600,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.002
],
[
1733544000,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.005
],
[
1733540400,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733536800,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733533200,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733529600,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.024
],
[
1733526000,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.005
],
[
1733522400,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733518800,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.047
],
[
1733515200,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.012
],
[
1733511600,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.005
],
[
1733508000,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.003
],
[
1733504400,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733500800,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.017
],
[
1733497200,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.001
],
[
1733493600,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733490000,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.08
],
[
1733486400,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.004
],
[
1733482800,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0
],
[
1733479200,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.002
],
[
1733475600,
"Measure",
"Multi_Fluid|0|IVolumeConsumptionH",
0.021
]
]
},
"customElement":[
]
}
Le champs : « Multi_Fluid|0|IVolume » comprend l’index à minuit
La section suivante :
1733558400,
« Measure »,
« Multi_Fluid|0|IVolumeConsumptionH »,
0
Correspond à une consommation horaire et le timestamp associé.
A ce jour, mon fichier de configuration YAML n’exploite que l’index
# ---------------------------------------
# Compteur EF
# ---------------------------------------
- name: "Compteur Eau"
unique_id: 90dffb818724b4f2
state_topic: "Wiotys/90dffb818724b4f2"
value_template: >
{% set values = value_json.data["values"] %}
{% for item in values %}
{% if item[2] == 'Multi_Fluid|0|IVolume' %}
{{ item[3] }}
{% endif %}
{% endfor %}
unit_of_measurement: "m³"
state_class: "total_increasing"
device_class: "water"
J’aimerai exploiter les données de consommation horaire. Est il possible de spécifier un timestamp pour une donnée de sensor mqtt?
Ma configuration
RPI4
System Information
| version | core-2024.12.3 |
|---|---|
| installation_type | Home Assistant OS |
| dev | false |
| hassio | true |
| docker | true |
| user | root |
| virtualenv | false |
| python_version | 3.13.0 |
| os_name | Linux |
| os_version | 6.6.51-haos-raspi |
| arch | aarch64 |
| timezone | Europe/Paris |
| config_dir | /config |
Home Assistant Community Store
| GitHub API | ok |
|---|---|
| GitHub Content | ok |
| GitHub Web | ok |
| HACS Data | ok |
| GitHub API Calls Remaining | 5000 |
| Installed Version | 2.0.1 |
| Stage | running |
| Available Repositories | 1491 |
| Downloaded Repositories | 13 |
Home Assistant Cloud
| logged_in | false |
|---|---|
| can_reach_cert_server | ok |
| can_reach_cloud_auth | ok |
| can_reach_cloud | ok |
Home Assistant Supervisor
| host_os | Home Assistant OS 14.0 |
|---|---|
| update_channel | stable |
| supervisor_version | supervisor-2024.11.4 |
| agent_version | 1.6.0 |
| docker_version | 27.2.0 |
| disk_total | 109.3 GB |
| disk_used | 7.4 GB |
| healthy | true |
| supported | true |
| host_connectivity | true |
| supervisor_connectivity | true |
| ntp_synchronized | true |
| virtualization | |
| board | rpi4-64 |
| supervisor_api | ok |
| version_api | ok |
| installed_addons | Zigbee2MQTT (1.42.0-2), Mosquitto broker (6.4.1), File editor (5.8.0), Get HACS (1.3.1), Advanced SSH & Web Terminal (19.0.0), Duck DNS (1.18.0), MQTT Explorer (browser-1.0.3) |
Dashboards
| dashboards | 3 |
|---|---|
| resources | 10 |
| views | 11 |
| mode | storage |
Recorder
| oldest_recorder_run | 5 décembre 2024 à 13:35 |
|---|---|
| current_recorder_run | 15 décembre 2024 à 09:57 |
| estimated_db_size | 42.73 MiB |
| database_engine | sqlite |
| database_version | 3.45.3 |