Sensor from a script with historic data

Configuration
1

Hi, I get my water consumption from a python script that I run from an other server PyVeoliaIDF.

It give me data like this.

[
  {
    "time": "2022-08-03 14:00:00",
    "total_liter": "423159",
    "daily_liter": "503",
    "type": "Mesur\u00e9",
    "timestamp": "2022-08-17T12:23:20.540788"
  },
  {
    "time": "2022-08-04 14:00:00",
    "total_liter": "423159",
    "daily_liter": "0",
    "type": "Mesur\u00e9",
    "timestamp": "2022-08-17T12:23:20.540788"
  }
]

The full output is 14 days.
One of the point is that the measurement is not always at the same time.

example

  {
    "time": "2022-08-15 02:00:00",
    "total_liter": "423162",
    "daily_liter": "0",
    "type": "Mesur\u00e9",
    "timestamp": "2022-08-17T12:23:20.540788"
  }

I know how to call it by ssh and get only the last measurement, but how to be sure I don’t already have it ?
How can I integrate the full output with no duplicate in one sensor just in case I miss one day ?

Thanks.