Problem accessing influxdb (v1) from HTTP with special chars

1

Works fine with measurements which do not contain special characters, but when I try to use Microsoft HTTP60 objects to get at influx data where the measurement is “°C” the query returns no data. If I paste exactly the same URL into my browser and access it, I get the data.
The HTTP call is:

http://homeassistant:8086/query?db=homeassistant&q=SELECT “value” FROM “homeassistant”.“autogen”.“°C” WHERE “entity_id”=‘universal_binary_sensor_air_temperature’ AND time>‘2024-06-23T00:00:00Z’ AND time<‘2024-06-24T00:00:00Z’

Now if the measurement field is “W” (no special characters) it works like a hose both places. How to fix? Autogen has made me a database with LOTS of special character measurement names (thanks a bunch!).

I assume microsoft’s http object is doing something stupid by way of urlencoding and sending the GET request. This is from excel/vba so going CURL is a royal pain.

2

OK, I seem to have fixed it by changing the VBA HTTP object from “msxml2.XMLHTTP60” to “MSXML2.serverXMLHTTP”. I have no idea why that works, but it does.