How did you guys solve the ‘bad request’ issue?
I’m having the same with importing domoticz history into HA via SQL Lite Web.
Tried to remove the “cr (hard returns)” but that results in a 404 error.
Trying to import Gas, Power & Water.
update statistics set sum = sum + 2090.225 where metadata_id = 59 and start_ts > unixepoch("2023-12-27 02:00:00.000000")
update statistics_short_term set sum = sum + 2090.225 where metadata_id = 59 and start_ts > unixepoch("2023-12-27 02:00:00.000000")
insert into statistics (created_ts, start_ts, state, sum, metadata_id) values
(unixepoch("2016-12-02 02:00:00.000000"), unixepoch("2016-12-02 02:00:00.000000"), 2930.762, 0.000, 59),