How to query remote InfluxDB via cURL

Sometimes you want to query a remote InfluxDB server to understand the data in it. This can be done via cURL as explained in the InfluxDB docs

Parameters

• HOSTNAME: Database hostname
• PORT: Database port
• PROTOCOL: Protocol to connect to the database HTTPS, HTTP
• USERNAME: Username to connect to the database
• PASSWORD: Password to connect to the database
• DB_NAME: Database name
• QUERY_STR: Query string to be exectuted. The query string needs to be properly escaped, e.g. SELECT \"ts_ms\" FROM \"test_measurement\"

cURL Query Code

Execute the following by replacing the parameters above

curl -G 'https://<USERNAME>:<PASSWORD>@<HOSTNAME>:<PORT>/query?pretty=true' \
    --data-urlencode "db=<DB_NAME>" \
    --data-urlencode "q=<QUERY_STR>"

As example to get the SELECT \"ts_ms\" FROM \"test_measurement\" you can run:

curl -G 'https://<USERNAME>:<PASSWORD>@<HOSTNAME>:<PORT>/query?pretty=true' \
    --data-urlencode "db=<DB_NAME>" \
    --data-urlencode "q=SELECT \"ts_ms\" FROM \"test_measurement\""

Results:

{
    "results": [
        {
            "statement_id": 0,
            "series": [
                {
                    "name": "TEST",
                    "columns": [
                        "time",
                        "ts_ms"
                    ],
                    "values": [
                        [
                            "2022-11-07T08:50:20.772317361Z",
                            1667809412536
                        ],
                        [
                            "2022-11-07T08:50:20.789690226Z",
                            1667809412547
                        ],
                        [
                            "2022-11-07T08:50:20.79052872Z",
                            1667809412548
                        ],
                        [
                            "2022-11-07T08:51:53.165095297Z",
                            1667811112824
                        ],
                        ]
                }
            ]
        }
    ]
}