mblackstock / node-red-contrib-influxdb

Node-RED nodes to save and query data from an influxdb time series database
Other
64 stars 44 forks source link

request for InfluxQl style querys in InluxDB2 #139

Open solarc3po opened 1 year ago

solarc3po commented 1 year ago

As I understand node-red-contrib-influxdb version right now, there is no way to provide InfluxQL Style querys (like "select * from iot") for InfluxDB2 database. I try ver1.x configuration but no succes "error no valide autorisation" When I use a simple curl call from Linux Terminal and provide -t parameter with valid API Token all works fine with InfluxDB2 and InfluxQL style query.

Request:

Many thanks in advance BR J

mblackstock commented 8 months ago

It's not clear to me how to do this with the Javascript Client Library library we use for accessing influxdb 2.x servers as mentioned in the README yet. It seems to support only flux queries? Suggestions are welcome.

With InfluxDb 3.x on the horizon, perhaps yet another client library is in the works. I'm again thinking it might be worth considering breaking this node down into multiple nodes for different versions, especially given that flux will be put into maintenance mode.

FiloCara commented 6 months ago

Hello,

I wanted to share that I was able to run InfluxQL queries with InfluxDB V2. The key was to select the version "1.x" in the configuration node. However, this only works after creating the DBRP mapping and setting up a 1.x basic authentication.