CODEWITHSUNDEEP
pythonpython-3.xdatabaseinfluxdbinfluxdb-python
MihaiMacarie
MihaiMacarie

Reputation: 75

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

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.

Upvotes: 0

Views: 1238

Answers (1)

Yuregir Tekeli
Yuregir Tekeli

Reputation: 26

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

Influxdb Docs - Bind Parameter

Upvotes: 1

Related Questions