Problem when writing data in a database [unable to parse:invalid boolean]

InfluxDB 1
1

Hi all,

I am new using influx and started with version 1.8.10 since I had a compatibility issue with Grafana and version 2.

When I send the post request I receive the following response:

{
    "error": "unable to parse 'radars,link_id=4616271,time=1625650083 speed=20.5,travel_time=749,link_points=40.69,encoded_poly_line=kqj,borough=Brooklyn,links_name=BQE 1625650083': invalid boolean"
}

Could anyone help me with this issue?

For further info, I am using an open data source available from New York. Have a look here

I will use as tags the id of the radar and the timestamp in unix time format.

Thanks in advance community!
JC.

2

Hello @juancarloscg,
Can you please share your entire cURL request? You might need to fix the timestamp precision of your timestamp.

curl -i -XPOST 'http://localhost:8086/api/v2/write?bucket=db/rp&precision=ns' \
  --header 'Authorization: Token username:password' \
  --data-raw 'cpu_load_short,host=server01,region=us-west value=0.64 1434055562000000000'

Notice how your timestamp is:
1625650083
vs
1434055562000000000

So your precision would be seconds.