InfluxDB node

Meepus · March 30, 2021, 1:45pm

Hello

Is there an InfluxDB node?
If not is there plans to implement one?

Thanks

RicardoE105 · March 30, 2021, 2:12pm

@Meepus Welcome to the community.

That node does not exist. It’s currently not planned. Depending on the votes we might plan to add it.

Meepus · March 30, 2021, 2:28pm

Ok. Thank you

tanay · March 30, 2021, 7:49pm

I love InfluxDB. You have my vote @Meepus!

naskdev · March 2, 2022, 2:02am

Hello,
I just finished implementing a node for InfluxDB 2.x:

Write data to InfluxDB 2.x.
Query data from InfluxDB 2.x.

You can find it published on npm.

MarvinJWendt · March 21, 2022, 11:05am

I’d really like to see a InfluxDB2 added to the default nodes. InfluxDB is one of the most popular time-series OSS databases, that is commonly used in home-automation. The implementation of a node should not be that complicated, as they feature full-spec SDKs.

Saad_Mujeeb · May 15, 2022, 1:38pm

I am creating a node for this now… will keep the updates posted here

Saad_Mujeeb · May 15, 2022, 1:40pm

@naskdev @MarvinJWendt the main features we are looking for is that node should be able to read and write data to influxdb, and also add filters for the read operations. is there anything else ?

Saad_Mujeeb · May 15, 2022, 1:49pm

my bad. someone else has already created it

naskdev · May 15, 2022, 2:00pm

Hello @Saad_Mujeeb
Indeed, I have already created a node for InfluxDB 2.X
You can find it published on npm

Saad_Mujeeb · May 15, 2022, 2:12pm

yeah sorry for that… i saw it later. thanks btw

smo · May 19, 2022, 5:00pm

Just tried last night, I went crazy trying to make it work, seems that not even with a normal HTTP Request I can make it work… Im on 0.176.0.

Can someone shared a workflow that actually works using influxdb2? thanks

Jon · May 19, 2022, 6:01pm

Hey @smo,

Welcome to the community

Can you share the workflow you currently have and any error you are getting?

smo · May 20, 2022, 9:25am

Jon · May 20, 2022, 9:46am

Hey @smo,

What error are you getting?

smo · May 20, 2022, 9:54am

Bad timestamp looks like when sending data using line protocol for influxdb the request is attaching stuff at the end or not sending the body properly. Probably is to do with the string scaping you doing before sending it.

I have tested in postman curl and other ways and works perfectly, issue is in http request n8n. Hopefully gets solved soon.

Also http node if you specify a header credentials then you can’t attach raw headers?

It will be nice to only choose body to se it as raw data and leave other sections like headers using the form

Jon · May 20, 2022, 10:03am

I can’t actually see where the timestamp is being set in that workflow I will get a local instance of Influx set up and see if I can work it out.

smo · May 20, 2022, 10:16am

Yes feel free to call me if you like, the request is sent here

Jon · May 20, 2022, 11:12am

What happens if you try to send the data as a binary object does that work? I found if I use a set node then convert to binary and send that I get a 204 response back from Influx which looks like it could be a good thing but I don’t see it in the Influx interface which could be because I am using cloud I am not sure. I did find that Postman does the same thing though so it could be a temporary solution until we (or someone else) makes a node.

I also changed it to use Header auth to make life a bit easier on that send.

smo · May 20, 2022, 11:37am

That’s probably a good idea haha . I’ll try just now.

Also something I noticed but probably for a different discussion is that Shopify Trigger doesn’t work but using a normal Weebhook does