Hi Everyone. I am new here and new to Node-Red and Influxdb for that matter. I had some intro programming courses 20 years ago and was never my favorite. With that being said, I am trying to take license plate data from a camera via MQTT that is coming in as a JSON object and put it into an influ…

[function] I could only attach two so here is the function block I have.

Hi. From a quick glance the only thing I see wrong is you don't return the msg at the end of the function. Add return msg At the very end of the function.

[parsed] Now, that's what I get. Is that what I want? Don't know! But I will dump it into the influx database and find out!

Look at the help text for the influx node to see what it expects. Influxdb is intended to be a time series database, so it would be unusual to store data such as you show.

Indeed. It is used to record numeric data over time. Text data is normally only used for filtering, classification, grouping, etc when you want to look at the data.

But you can also have string field data (up to 65k). I use those regularly for raw hex data, events or log messages. :sunglasses: Properly tagged, of course, so I can utilize and filter my data.

[image] kuema: But you can also have string field data Certainly you can, but it is unusual for an apparent beginner with influxdb to do that, hence my query.

@thezfunk Is there a particular reason why you chose influxdb? As others have pointed out, you may find MYSQL or MariaDB a better 'fit' for storing your proposed data, and also present you with fewer problems when you later try to retrieve it.

You guys are asking good questions. I actually am much more comfortable with SQL type databases. I have a MariaDB running on my Synology all the time keeping track of a couple of different things. This is a side project for work. Without going into the weeds...I was supposed to come up with some…

[image] thezfunk: I chose to take LPR data, capture it and parse out the important bits like country, state/region, and plate number. Then, I can build dashboards showing frequency of plate numbers, busiest times of day, etc. Personally I think I would use a conventional db for that. I sugge…

Parsing and Formatting JSON Object for InfluxDB

General

TotallyInformation 6 August 2023 10:19 12

I suspect that is because Grafana has deep ties to InfluxDB (for the old-style queries, not Flux ones). That makes it trivial to create even complex dashboards because it is mostly click-and-select.

But if you are familiar with SQL, you probably don't need that helping hand and as Colin says, it works fine with other DB's too.

Topic		Replies	Views
JSON objects not importing into influxDB General	11	385	6 December 2022
NodeRed Json to Influxdb General	16	5587	1 June 2020
Node-RED data to influxDB General	9	6042	17 October 2019
Inject JSON messages to InfluxDB General	2	516	20 October 2020
Send JSON data to influxdb from Node-red General	15	1024	1 March 2023

Parsing and Formatting JSON Object for InfluxDB

Related topics