InfluxDB Query Failed, Code 400

Hi,
I’m having trouble getting my iotawatt to log to influxdb. There seems to be an error with the query, but I can’t figure out what it is or why it is happening. Looking at termshark, I see the error as:

invalid character 'd' looking for beginning of value

The query from iotawatt is:

db=iotawatt&epoch=s&q=SELECT LAST(Watts) FROM IotaWatt

My influxdb version is 1.8.10

Here are the relevent settings from my iotawatt

Here are my logs since the last restart

SD initialized.
3/23/23 16:20:51z Real Time Clock is running. Unix time 1679588451 
3/23/23 16:20:51z Reset reason: Software/System restart
3/23/23 16:20:51z Trace:  1:2[2], 9:0[2], 9:0, 9:1, 8:4, 8:6, 8:8, 9:3, 9:5, 9:9, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:3, 1:1[2], 1:2[3], 9:0[3], 9:0, 9:1, 8:4, 8:6, 8:8, 9:3, 9:5, 9:9, 1:3, 10:2, 10:3
3/23/23 16:20:51z ESP8266 ID: 15844538, RTC PCF8523 (68)
3/23/23 16:20:51z IoTaWatt 5.0, Firmware version 02_08_02
3/23/23 16:20:51z SPIFFS mounted.
3/23/23 12:20:51 Local time zone: -5:00, using DST/BST when in effect.
3/23/23 12:20:51 device name: IotaWatt
3/23/23 12:20:51 HTTP server started
3/23/23 12:20:51 influxDB_v1: Starting, interval:5, url:http://192.168.0.50:8086/api/v2
3/23/23 12:20:51 timeSync: service started.
3/23/23 12:20:51 statService: started.
3/23/23 12:20:51 dataLog: service started.
3/23/23 12:20:51 dataLog: Last log entry 03/23/23 12:20:45
3/23/23 12:20:55 WiFi connected. SSID=tmktmk, IP=192.168.0.103, channel=2, RSSI -44db
3/23/23 12:20:55 Updater: service started. Auto-update class is MINOR
3/23/23 12:20:56 historyLog: service started.
3/23/23 12:20:56 historyLog: Last log entry 03/23/23 12:20:00
3/23/23 12:20:56 Grid: Started
3/23/23 12:20:56 Grid: Last log entry 03/23/23 12:20:45
3/23/23 12:20:57 Updater: Auto-update is current for class MINOR.
3/23/23 12:30:48 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 12:52:01 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 12:53:06 influxDB_v1: Start posting at 03/23/23 12:53:10
3/23/23 12:55:46 influxDB_v1: stopped, Last post 03/23/23 12:53:05
3/23/23 13:08:09 influxDB_v1: stopped, Last post 02/06/06 01:28:16
3/23/23 13:20:34 influxDB_v1: stopped, Last post 02/06/06 01:28:16

Any help that anyone could provide would be very much appreciated. Thank you!

Somehow I got this working. I should not have been using the V2 API. (I did try this originally, and a few other times, but I guess something else was wrong at that time.) For other’s potential benefit, here are my working settings:

I should have noticed that. It’s OK to have the /v2/api but not with an ending slash as you had it. It shouldn’t matter but the code isn’t recognizing it. It will be fixed in a later release, but for now simply leaving it off is the best bet and IoTaWatt will add the correct endpoint.