I pull inverter data from the manufacturer's cloud service and would like to store it in a local Influxdb instance. The data pulled down is the data for one day and comprises up to 280 datapoints. This is delivered as a single payload of nested arrays. I use the split node to create a single payl…

Is it working? If not then what error? Did you remember to set the time precision in the node to seconds?

Colin, Thanks for your help but the issue is probably Influxdb rather than Node-RED. I had been seeing data points in Influxdb, but could not see any data point timestamps. Now that I've added the timestamp at the end of the object, the same Influxdb out node no longer seems to be able to post th…

[image] Bodad: at least I'm unable to find any data points Have you dropped the measurement, added a few points, and then examined the contents using the influx command line to see what is in the database? Select * from the_measurement Or something like that. If you don't provide a time wh…

Oh, it is influx 2, so you have to use the flux language to query it. Same principle though.

Colin, yes it's Influx 2.3. I decided to migrate to it from 1.8 by setting up a new project, leaving my existing projects' data being sent to the old instance. When I've got my head round the new way of doing things, I'll modify the existing nodes sending to 1.8 as appropriate. I have posted onto…

Do you mean you have been doing all this, outputting to your production system and potentially messing up your stored data? Temporarily change your flow to output to a test measurement till you get it working. Add a few samples then inspect the database and see what is there. Did you answer the qu…

[image] Colin: outputting to your production system Colin, no. I have built a new Raspberry Pi as a development platform with a dev instance of Node-RED and the Influxdb 2.3 instance. I'm pulling data down from the cloud into dev flows and pushing the data to the new database bucket. The p…

OK, so do what I suggested, drop the measurement, or use a new test one, add a few samples then inspect the database and see what has been added.

Colin, I have done that. Sometimes the data is visible in Data Explorer and sometimes not but when it is visible, it does not seem to recognise the timestamp. I'm struggling to work out why the data simply does not appear in the bucket (with or without timestamp) with no error messages. Changing …

Working with Influxdb 2.x timestamp

General

grant1 7 August 2022 23:51 18

@Bodad I have done something similar a few weeks ago. Did you try my flow? Using Node-RED to transfer data from InfluxDB 1.7 to 2.3, but receiving ENOBUFS error when dataset is too large - #9 by grant1

Topic		Replies	Views
Time Stamp and Influx DB problem General	48	10946	20 June 2022
Influxdb showing arbitrary timestamps General	14	551	12 December 2022
Store data in InfluxDB show in Chronograf General database	34	956	27 July 2022
Need help inputting CSV data from OBD2 into influx from Chevy bolt General	23	2410	8 January 2020
Node Red Custom Date Time insert into influx FLUX issue General	19	398	25 May 2023

Working with Influxdb 2.x timestamp

Related topics