# Can't get data from Influxdb with node-red-contrib-influxdb in 1.x InfluxQL style

**URL:** <https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149>\
**Category:** General\
**Tags:** influxdb\
**Created:** [29 July 2023 06:23 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149 "2023-07-29T06:23:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hans4711](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hans4711/32/64563_2.png) [@Hans4711](https://discourse.nodered.org/u/Hans4711)\
**Post date:** [29 July 2023 06:23 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/1 "2023-07-29T06:23:28Z")

</div>

I saving data from my node red flow to InfluxDB by using node-red-contrib-influxdb palette.  
I setup the connection parameter with "v2" option and token from Influxdb2. Working fine.  
Also I'm able to query my saved Influxdb data by using flux style query.

When I try to use influxql style query like "select id, current..... from iot" (setting up new connection with 1.x parameter und admin user and pass) I'm geting an error:

"Error: A 401 Unauthorized error occurred: {"code":"unauthorized","message":"Unauthorized"}"

---

<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:** [29 July 2023 07:15 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/2 "2023-07-29T07:15:57Z")

</div>

For v2 I believe you have to use the flux language.

---

<div class="post-metadata">

**Author:** ![Hans4711](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hans4711/32/64563_2.png) [@Hans4711](https://discourse.nodered.org/u/Hans4711)\
**Post date:** [29 July 2023 07:54 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/3 "2023-07-29T07:54:21Z")

</div>

I also try send curl request to influxdb in Influxql query style which works fine, so I'd love to see this also in node red:).

---

<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:** [29 July 2023 08:00 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/4 "2023-07-29T08:00:07Z")

</div>

I suggest submitting an issue on the node's github page asking whether this is supported, and if not if it could be added.

---

<div class="post-metadata">

**Author:** ![Hans4711](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hans4711/32/64563_2.png) [@Hans4711](https://discourse.nodered.org/u/Hans4711)\
**Post date:** [1 August 2023 07:36 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/5 "2023-08-01T07:36:02Z")

</div>

@colin, yes good idea:) done.

---

<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:** [1 August 2023 08:59 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/6 "2023-08-01T08:59:44Z")

</div>

For reference it is [request for InfluxQl style querys in InluxDB2 · Issue #139 · mblackstock/node-red-contrib-influxdb · GitHub](https://github.com/mblackstock/node-red-contrib-influxdb/issues/139)

---

<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:** [30 September 2023 09:00 UTC](https://discourse.nodered.org/t/cant-get-data-from-influxdb-with-node-red-contrib-influxdb-in-1-x-influxql-style/80149/7 "2023-09-30T09:00:09Z")

</div>

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