# Node-red influxdb json insert

**URL:** <https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718>\
**Category:** General\
**Created:** [12 January 2019 14:41 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718 "2019-01-12T14:41:42Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![moebius](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/moebius/32/2872_2.png) [@moebius](https://discourse.nodered.org/u/moebius)\
**Post date:** [12 January 2019 21:42 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/21 "2019-01-12T21:42:41Z")

</div>

Influxdb has no "update" - to update a row, just insert again with the identical timestamp.

---

<div class="post-metadata">

**Author:** ![turkdoktoru](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/turkdoktoru/32/5111_2.png) [@turkdoktoru](https://discourse.nodered.org/u/turkdoktoru)\
**Post date:** [13 January 2019 07:37 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/22 "2019-01-13T07:37:41Z")

</div>

Hmm.  
then I will use grafana to show individual data to the user.  
I use the distinct method to display the last saved.

---

<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:** [13 January 2019 09:47 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/23 "2019-01-13T09:47:14Z")

</div>

> [@turkdoktoru](#):
>
> then I will use grafana to show individual data to the user.  
> I use the distinct method to display the last saved.

You have not made it clear whether you still have a question, or if all is now ok.

---

<div class="post-metadata">

**Author:** ![turkdoktoru](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/turkdoktoru/32/5111_2.png) [@turkdoktoru](https://discourse.nodered.org/u/turkdoktoru)\
**Post date:** [13 January 2019 11:07 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/24 "2019-01-13T11:07:28Z")

</div>

unfortunately my problem is not solved.  
I'll show the user the data in the picture.  
but there are several of the same devices in the "nodename" field.  
According to the "nodename" field I want to make the last record distinct

"cihaz1" available more than one. I want to show this to the user as a single record.  
now on grafana I'm working on select distinct

 ![mqtt](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/f/f55383107ecc66bababde605e4f7d96e6e09e455.png)

---

<div class="post-metadata">

**Author:** ![moebius](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/moebius/32/2872_2.png) [@moebius](https://discourse.nodered.org/u/moebius)\
**Post date:** [13 January 2019 11:37 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/26 "2019-01-13T11:37:39Z")

</div>

you can just show the last record - also you should take a rbe node into consideration to get rid of the current redundancies.

---

<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:** [13 January 2019 14:19 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/27 "2019-01-13T14:19:19Z")

</div>

Have you got the nodename stored as a tag and endeks, nodeabone as fields?

---

<div class="post-metadata">

**Author:** ![turkdoktoru](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/turkdoktoru/32/5111_2.png) [@turkdoktoru](https://discourse.nodered.org/u/turkdoktoru)\
**Post date:** [13 January 2019 18:43 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/28 "2019-01-13T18:43:47Z")

</div>

I kept it all as a string.  
I'm going to the mongodb database.  
thread lockable

---

<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:** [13 January 2019 21:47 UTC](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718/29 "2019-01-13T21:47:28Z")

</div>

> [@turkdoktoru](#):
>
> I kept it all as a string.

Please make it clear what you are responding to. Is that in response to my question as to how you have stored the values in influx? If so I don't understand what you are saying.

[Previous page](https://discourse.nodered.org/t/node-red-influxdb-json-insert/6718.md?page=1)
