How to save an array?

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 get an json array into InfluxDB Table with Telegraf Telegraf influxdb , telegraf , json	3	891	February 6, 2024
How to insert a string array to influxDB with JSON format? Store telegraf	1	10151	April 1, 2019
MQTT JSON Output has a field with an array of numeric values Telegraf mqtt , json	2	1470	October 18, 2021
Telegraf json input not saving all object in array	2	799	March 26, 2021
How to parse json array to influx Db Telegraf	3	81	October 16, 2024

How to save an array?

Related topics