I am attempting to write data to InfluxDB 3.0 using an annotated CSV file and the influxdb3 CLI tool. Despite following the documentation for annotated CSVs, I consistently receive a 400 Bad Request error. Most existing troubleshooting guides I’ve found appear to be for InfluxDB 2.0 and don’t seem to apply here.
command i am using to insert
influxdb3 write --token MY_TOKEN --file docData.csv --database newTest
#datatype measurement,tag,double,dateTime:RFC3339 m,host,usedPercent,time mem,host1,64.23,2020-01-01T00:00:00Z mem,host2,72.01,2020-01-01T00:00:00Z
The reason for error is that influxdb3 write does not support annotated CSV. It only accepts line protocol data. You will have to convert .csv to .lp format, alternatively you can use Explorer UIto import CSV file.
