Help passing data (inc historic) to influxdb

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.

image

[{"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"}]

If you provide data for the same timestamp, measurement and tags then it will overwrite the existing data for that timestamp.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.