I’m trying to extract date/time and value from this json:
https://environment.data.gov.uk/flood-monitoring/id/measures/E22322-rainfall-tipping_bucket_raingauge-t-15_min-mm/readings.json?_sorted&_limit=96
A data point looks like this:
“items” : [ {
“@id” : “http://environment.data.gov.uk/flood-monitoring/data/readings/E22322-rainfall-tipping_bucket_raingauge-t-15_min-mm/2024-02-08T10-00-00Z” ,
“dateTime” : “2024-02-08T10:00:00Z” ,
“measure” : “http://environment.data.gov.uk/flood-monitoring/id/measures/E22322-rainfall-tipping_bucket_raingauge-t-15_min-mm” ,
“value” : 0.36
I’m using this script to pull the data:
Preformatted text
@service
def get_rainfall():
import asyncio
log.info("Having the script")
json_items = task.executor(get_json)
for each_item in reversed(json_items["items"]):
log.info(f"doing {each_item['dateTime']} and {each_item['value']}")
state.set(
"input_number.rainfall_helper",
value=float(each_item["value"]),
dateTime=each_item["dateTime"],
)
await asyncio.sleep(1)`Preformatted text`
But I am not getting the time date in a suitable format, it looks like this:
20240150804750.00
Any suggestion of how to format correctly?
Thanks!