I am trying to query data from InfluxDB 1.8.4 (with Flux enabled) in R Studio. I can't figure out what's wrong with my code:
dburl <- "http://localhost:8086/api/v2/query"
influxquery <- sprintf(
'from(bucket: "plcview/autogen")
|> range(start: 2017-06-27T04:16:58.278Z, stop: now())
|> filter(fn: (r) => r._measurement == "MONITORING")
|> map(fn:(r) => ({ r with _time: uint(v:r._time) }))'
)
httr::POST(url=dburl,
add_headers('Content-Type: application/vnd.flux',
'Accept: application/csv',
'Accept-Encoding: application/gzip'),
body=list(q=influxquery))
The data I am trying to get looks like this:
time MONITORING equipmentNumber workplace
---- ---------- --------------- ---------
2017-06-27T02:16:58.599Z 1 L4212M1017 3
2017-06-27T02:16:58.6Z 1 L4212M1017 4
2017-06-27T02:16:58.6Z 1 L4212M1017 1
2017-06-27T02:16:58.6Z 1 L4212M1017 2
2017-06-27T02:17:03.14Z 0 L4212M1017 1
2017-06-27T02:17:03.14Z 0 L4212M1017 2
2017-06-27T02:17:03.14Z 0 L4212M1017 4
2017-06-27T02:17:20.007Z 1 L4212M1017 1
2017-06-27T02:17:36.988Z 1 L4212M1017 4
2017-06-27T02:17:36.988Z 1 L4212M1017 2
I always get this error message:
Response [http://localhost:8086/api/v2/query]
Date: 2021-04-08 14:19
Status: 400
Content-Type: application/json
Size: 53 B
{"error":"invalid character '-' in numeric literal"}
I can push the same request through (with all those parameters) using Postman. Why doesn't it work in R? Is it maybe a problem with the way R stores the data? I thought it could be the Timestamp form my time series data in rfc339 format (which has '-' to separate the dates, could that be the reason?).
Any ideas? I am new to Influx and R so I appreciate any help I can get.
Thank you guys!