我尝试了几天从influxDB拉一些日期,我得到下面缺失的参数"q"有了400个错误,或者如果我在参数中改变一些东西,在响应上得到404错误如果过去有人遇到过同样的问题或者有人帮助了解我该如何解决这个问题?
url='https://<hostname>8086/query'
values=[]
headers = {
'Content-Type': 'application/x-www-form-urlencoded',
}
params = {
'db': 'tail_screw_20',
}
data = 'q=select time, "RH(%)", "T(C)" from PM_histo WHERE time >= '2022-05-04T11:00:00Z'
and time <= '2022-05-04T11:10:00Z' order by time asc'
response = requests.get(url=url, params=params, headers=headers,verify=False,data=data)
print(response.text)
print(response)
错误:
{"error":"缺少必需的参数"q"}& lt;响应[400]在
编辑查询:
url='https://<localHost>:8086/query?db=tail_screw_20'
client = influxdb_client.InfluxDBClient(
url=url,
token='None',
ssl=False,
verify_ssl=False,
)
query_api = client.query_api()
result = query_api.query('''
from(bucket:"PM_histo") |> range(start: _start)
|> filter(fn: (r) => r["time"] == "time")
|> filter(fn: (r) => r["RH(%)"] == "RH(%)")
|> filter(fn: (r) => r["T(C)"] == "T(C)")
|> sort(columns: ["_time"], desc: _asc)
''')
resultsA = query_api.query_csv(query=result)
print(resultsA)
错误:
HTTP响应正文:b'{"error":"缺少必需的参数"q"}n'
这个问题通常与data=data传递的参数问题有关。
请检查数据变量,它应该是一个元组/字典吗?https://docs.python-requests.org/en/latest/user/quickstart/more-complicated-post-requests