---
title: "Query key verification data"
method: POST
path: "/v2/analytics.getVerifications"
tags: ["analytics"]
---

# Query key verification data

`POST /v2/analytics.getVerifications`

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.

## Request body

- V2AnalyticsGetVerificationsRequestBody
  - `query` string, required — SQL query to execute against your analytics data. Only SELECT queries are allowed.

## Response `200`

Query executed successfully

- V2AnalyticsGetVerificationsResponseBody
  - `meta` Meta, required — Metadata object included in every API response. This provides context about the request and is essential for debugging, audit trails, and support inquiries. The `requestId` is particularly important when troubleshooting issues with the Unkey support team.
    - `requestId` string, required — A unique id for this request. Always include this ID when contacting support about a specific API request. This identifier allows Unkey's support team to trace the exact request through logs and diagnostic systems to provide faster assistance.
  - `data` object[], required — Array of verification rows returned by the query. Fields vary based on the SQL SELECT clause.

## Other responses

- `400` — Invalid SQL query or blocked operation
- `401` — Missing or invalid authentication
- `403` — Insufficient permissions
- `404` — Referenced API or identity not found
- `422` — Query exceeds resource limits (timeout, memory, rows scanned, or result size)
- `429` — Query quota exceeded
- `500` — Query execution failed
- `503` — Connection to the database failed

## Changes

- **2026-02-27** `551df53dd45d` — 1 info
  - media type `application/json` was changed to a more specific media type `application/problem+json` for the response status `429`

[Change history](https://skmtc.dev/unkeyed/apis/unkey-api/changes/v2/analytics.getVerifications/post.md)

---

[API](https://skmtc.dev/unkeyed/apis/unkey-api.md) · [All operations](https://skmtc.dev/unkeyed/apis/unkey-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/unkeyed/unkey-api/revisions/0f7e331eeffa/schema)