Long term historical data HA to Influx to HA

Retrieving data from influxdb is easy when sticking to the docs.

However, retrieving data only works for a sensor state, not for any history.
I tried the same thing and came to the conclusion that this all does not work, by definition.
Similar issue here where I posted the unfortunate answer.