Sign in
analytics

Query key verification data

Execute custom SQL queries against your key verification analytics. For complete documentation including available tables, columns, data types, query examples, see the schema reference in the API documentation.

post/v2/analytics.getVerifications

Request body

querystring required

SQL query to execute against your analytics data. Only SELECT queries are allowed.

Example request

{
  "query": "SELECT COUNT(*) as total FROM key_verifications_v1 WHERE outcome = 'VALID' AND time >= now() - INTERVAL 7 DAY"
}

Response

Query executed successfully

dataobject[] required

Array of verification rows returned by the query. Fields vary based on the SQL SELECT clause.

Example response

{
  "meta": {
    "requestId": "req_123"
  },
  "data": [
    {
      "outcome": "VALID",
      "count": 1234,
      "time": 1696118400000
    },
    {
      "outcome": "RATE_LIMITED",
      "count": 56,
      "time": 1696118400000
    }
  ]
}

Changes