Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

request for InfluxQl style querys in InluxDB2 #139

Open
solarc3po opened this issue Jul 30, 2023 · 2 comments
Open

request for InfluxQl style querys in InluxDB2 #139

solarc3po opened this issue Jul 30, 2023 · 2 comments

Comments

@solarc3po
Copy link

solarc3po commented Jul 30, 2023

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:

  • please anhance node-red-contrib-influxdb to recive results for InnfluxQL style querys
  • provide configuration "Ver2 influxQL" in dropdown
  • provide field for API Token (as in vers2 Flux Style)

Many thanks in advance
BR J

@mblackstock
Copy link
Owner

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
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants