Query a dataset with SQL

Run a SQL query in Parseable. The dataset is selected inside the SQL statement itself, typically in the FROM clause.

Authorization

apiKey

X-API-Key<token>

In: header

Request Body

application/json

query*string

startTime*string

endTime*string

Response Body

`application/json`

curl -X POST "http://localhost:8000/api/v1/query" \
  -H "Content-Type: application/json" \
  -d '{
    "query": "SELECT * FROM \"example-dataset\" WHERE level = \'error\'",
    "startTime": "2023-01-01T00:00:00Z",
    "endTime": "2023-01-01T23:59:59Z"
  }'

curl -X POST "http://localhost:8000/api/v1/query" \  -H "Content-Type: application/json" \  -d '{    "query": "SELECT * FROM \"example-dataset\" WHERE level = \'error\'",    "startTime": "2023-01-01T00:00:00Z",    "endTime": "2023-01-01T23:59:59Z"  }'

Empty

Query a dataset with SQL

Authorization

Request Body

Response Body

200application/json

`application/json`