Been trying to format this data for influxdb but can't figure out how to go about changing the (interval_end ) timestamp correctly (still very much a newbie). The data is requested every 24hours and will contain figures that overlap from previous days, so will influx recognize a value with the same timestamp and ignore or overwrite the existing data. Any help appreciated.
[{"consumption":0,"interval_start":"2022-10-31T23:30:00Z","interval_end":"2022-11-01T00:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T23:00:00Z","interval_end":"2022-10-31T23:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T22:30:00Z","interval_end":"2022-10-31T23:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T22:00:00Z","interval_end":"2022-10-31T22:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T21:30:00Z","interval_end":"2022-10-31T22:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T21:00:00Z","interval_end":"2022-10-31T21:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T20:30:00Z","interval_end":"2022-10-31T21:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T20:00:00Z","interval_end":"2022-10-31T20:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T19:30:00Z","interval_end":"2022-10-31T20:00:00Z"},{"consumption":0.022,"interval_start":"2022-10-31T19:00:00Z","interval_end":"2022-10-31T19:30:00Z"},{"consumption":0.027,"interval_start":"2022-10-31T18:30:00Z","interval_end":"2022-10-31T19:00:00Z"},{"consumption":0.008,"interval_start":"2022-10-31T18:00:00Z","interval_end":"2022-10-31T18:30:00Z"},{"consumption":0.02,"interval_start":"2022-10-31T17:30:00Z","interval_end":"2022-10-31T18:00:00Z"},{"consumption":0.003,"interval_start":"2022-10-31T17:00:00Z","interval_end":"2022-10-31T17:30:00Z"},{"consumption":0.009,"interval_start":"2022-10-31T16:30:00Z","interval_end":"2022-10-31T17:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T16:00:00Z","interval_end":"2022-10-31T16:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T15:30:00Z","interval_end":"2022-10-31T16:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T15:00:00Z","interval_end":"2022-10-31T15:30:00Z"},{"consumption":0.01,"interval_start":"2022-10-31T14:30:00Z","interval_end":"2022-10-31T15:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T14:00:00Z","interval_end":"2022-10-31T14:30:00Z"},{"consumption":0.007,"interval_start":"2022-10-31T13:30:00Z","interval_end":"2022-10-31T14:00:00Z"},{"consumption":0.009,"interval_start":"2022-10-31T13:00:00Z","interval_end":"2022-10-31T13:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T12:30:00Z","interval_end":"2022-10-31T13:00:00Z"},{"consumption":0.007,"interval_start":"2022-10-31T12:00:00Z","interval_end":"2022-10-31T12:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T11:30:00Z","interval_end":"2022-10-31T12:00:00Z"},{"consumption":0.024,"interval_start":"2022-10-31T11:00:00Z","interval_end":"2022-10-31T11:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T10:30:00Z","interval_end":"2022-10-31T11:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T10:00:00Z","interval_end":"2022-10-31T10:30:00Z"},{"consumption":0.042,"interval_start":"2022-10-31T09:30:00Z","interval_end":"2022-10-31T10:00:00Z"},{"consumption":0.025,"interval_start":"2022-10-31T09:00:00Z","interval_end":"2022-10-31T09:30:00Z"},{"consumption":0.01,"interval_start":"2022-10-31T08:30:00Z","interval_end":"2022-10-31T09:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T08:00:00Z","interval_end":"2022-10-31T08:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T07:30:00Z","interval_end":"2022-10-31T08:00:00Z"},{"consumption":0.009,"interval_start":"2022-10-31T07:00:00Z","interval_end":"2022-10-31T07:30:00Z"},{"consumption":0.069,"interval_start":"2022-10-31T06:30:00Z","interval_end":"2022-10-31T07:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T06:00:00Z","interval_end":"2022-10-31T06:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T05:30:00Z","interval_end":"2022-10-31T06:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T05:00:00Z","interval_end":"2022-10-31T05:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T04:30:00Z","interval_end":"2022-10-31T05:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T04:00:00Z","interval_end":"2022-10-31T04:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T03:30:00Z","interval_end":"2022-10-31T04:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T03:00:00Z","interval_end":"2022-10-31T03:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T02:30:00Z","interval_end":"2022-10-31T03:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T02:00:00Z","interval_end":"2022-10-31T02:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T01:30:00Z","interval_end":"2022-10-31T02:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T01:00:00Z","interval_end":"2022-10-31T01:30:00Z"},{"consumption":0,"interval_start":"2022-10-31T00:30:00Z","interval_end":"2022-10-31T01:00:00Z"},{"consumption":0,"interval_start":"2022-10-31T00:00:00Z","interval_end":"2022-10-31T00:30:00Z"}]