# Help passing data (inc historic) to influxdb

**URL:** <https://discourse.nodered.org/t/help-passing-data-inc-historic-to-influxdb/70350>\
**Category:** General\
**Created:** [9 November 2022 19:39 UTC](https://discourse.nodered.org/t/help-passing-data-inc-historic-to-influxdb/70350 "2022-11-09T19:39:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vigalent](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/vigalent/32/69263_2.png) [@vigalent](https://discourse.nodered.org/u/vigalent)\
**Post date:** [9 November 2022 19:39 UTC](https://discourse.nodered.org/t/help-passing-data-inc-historic-to-influxdb/70350/1 "2022-11-09T19:39:02Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/9/a93be716a609dd732f0f0e44caaa8a5a9f37838f.png)

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

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [9 November 2022 19:51 UTC](https://discourse.nodered.org/t/help-passing-data-inc-historic-to-influxdb/70350/2 "2022-11-09T19:51:07Z")

</div>

> [@vigalent](#):
>
> will influx recognize a value with the same timestamp and ignore or overwrite the existing data

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [8 January 2023 19:51 UTC](https://discourse.nodered.org/t/help-passing-data-inc-historic-to-influxdb/70350/3 "2023-01-08T19:51:56Z")

</div>

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