How to save an array?

pelu · November 20, 2023, 2:46pm

Hi folks,

is it possible to save an array directly as a value?

I need to store a lot of arrays (vectors) that come from a mqtt message (json), i.e.:

{
  "orientation": "front_left",
  "latitude": 2.9996022459576714,
  "longitude": 6.998576282545255,
  "rpm": 39,
  "testArray": [
    "Ford",
    "BMW",
    "Fiat"
  ]
}

I can parse everything with telegraf, but not the array.

Can you please tell me the best way to organize something like this.

Thanks

Anaisdg · December 7, 2023, 8:08pm

Here are some solutions/examples:

github.com/influxdata/telegraf

Parse JSON array as combined string field with json_v2

opened 08:23PM - 03 May 23 UTC

closed 04:52PM - 25 May 23 UTC

powersj

feature request

### Use Case ```json { "head": [ { "name": "test_a", "…array": ["foo", "bar", "baz"] }, { "name": "test_b", "array": [1, 2, 3] } ] } ``` ### Expected behavior ```s file,name=test_a array="foo, bar, baz" 1683143788000000000 file,name=test_b array="1, 2, 3" 1683143788000000000 ``` ### Actual behavior ```s file,name=test_a array="foo" 1683145288000000000 file,name=test_a array="bar" 1683145288000000000 file,name=test_a array="baz" 1683145288000000000 file,name=test_b array=1 1683145288000000000 file,name=test_b array=2 1683145288000000000 file,name=test_b array=3 1683145288000000000 ``` ### Additional info We need to consider other uses cases, for example when there are multiple arrays, what happens? Today is combines them into m*n metrics. Possible config: ```toml [[inputs.file.json_v2.object.field_array]] path = "" # # A string with valid GJSON path syntax, can include array's and object's rename = "new name" # A string with a new name for the tag key ``` Limitations, would only work with string and numeric values. Output would be a CSV string (e.g. field="a,b,c").

Topic		Replies	Views
How to insert a string array to influxDB with JSON format? Store telegraf	1	9858	April 1, 2019
How to get an json array into InfluxDB Table with Telegraf Telegraf influxdb , telegraf , json	3	178	February 6, 2024
MQTT.input - JSON - save/convert Int as String telegraf	0	467	March 6, 2020
Telegraf json input - parsing data Telegraf influxdb , json	1	451	May 11, 2022
Telegraf MQTT JSON Data: Convert String To Integer	2	1980	May 12, 2018

How to save an array?

Related Topics