Store complete msg object in InfluxDB

Hello,

I have a crypto value object that want to store in a InfluxDB server:

image

I have configured a 1.8v Influx server:

image

But I get this error:

Error: A 400 Bad Request error occurred: {"error":"unable to parse 'msg.payload BIDR=[object Object],BTC=[object Object],BVND=[object Object],IDRT=[object Object],RVN=[object Object],SHIB=[object Object],USDT=[object Object],XEC=[object Object]': invalid boolean"}

How could I save all object values in the InfluxDB server?

I will appreciate your help.

Kind regards.

Welcome to the forum @jlazkano

You can't just send a complex object to an influxdb. First you need to understand more about influx. Please go and browse the influx docs for the version of influx you are using (1.8 or 2.0).

Once you understand about influx measurements, fields, and tags (or the equivalent in v2.0), and know how you want to structure the database, then look at the help text for the influx node and work out what payload you need to send.

Postgres, mongo or other document type database is more suited to this task.

Thanks for the replies.

I add a InfluxDB node for each currency:

image

Now it works, thanks for your help.

Kind regards.

I'm not sure this actually "works" as you would expect... it looks like this would create 3 measurements, with 1 tag/value for each currency. Wouldn't it be better to restructure your payload to be a single measurement, with tags/values for each currency?

Sorry if this is a noob question -- it has been years since I looked at Influxdb, so perhaps there is a distinction here that does not really matter to the app that will be displaying this data.