"Error parsing query: missing parameter" InfluxDB Python API query while using parameters

Question

I have a UDP InfluxDB connection:

client = InfluxDBClient(host='localhost', database='adatabase', use_udp=True, udp_port=1234)

Then, I have the following function:

    def getData(self, measurement, field="*", tag="", timeStart=0, timeEnd=0):
    parameters = {"selectedMeasurement": measurement,
                  "selectedField": field}
    print(parameters)
    result = self.client.query('SELECT LAST($selectedField) FROM $selectedMeasurement;', params=parameters)
    print(list(result.get_points()))
    return list(result.get_points())

But I get the following error:

influxdb.exceptions.InfluxDBClientError: 400: {"error":"error parsing query: missing parameter: selectedField"}

I don't understand where the problem is. Also tried with bind_params. I use hardcoded fields and measurements, the code works fine.

davegravy · Accepted Answer · 2021-01-15 09:51:42Z

1

Influxdb allows to use bind_params ($variable) in the WHERE statement, not in SELECT.

Influxdb Docs - Bind Parameter

edited Jan 15, 2021 at 9:51

davegravy

94414 silver badges33 bronze badges

answered Dec 21, 2020 at 11:40

Yuregir Tekeli

263 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

"Error parsing query: missing parameter" InfluxDB Python API query while using parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related