Hi, i am trying to use python in visual studio code to read the data from my influxdb and write in to an excel. Below is the filters in my influx sql query. However, the python can’t get any data from the db. I am wondering if i write the sql script correctly in the python script.
This is the sql query in the influxdb
SELECT *
FROM “Backgrind_status”
WHERE
time >= now() - interval ‘30 days’
AND
(“LED_state” IS NOT NULL OR “DateTime” IS NOT NULL)
AND
“device” IN (‘BG3’)
This is the script in my python
