Analytics

Run one read-only SELECT against the org-scoped analytics views

POST/v1/analytics/sql

The statement is validated against a relation and function allowlist and runs as a role that can read only the organisation-scoped analytics views. A rejected statement answers `{ success: false, error }` with the reason.

Requires the session token of a signed-in Alfa user as a bearer token.

Request body

sqlstringrequired
at least 1 characters

Responses

200Success.
400The request is malformed: invalid JSON, an unexpected body or an unknown query parameter. Problem details
401The bearer token is missing, expired or invalid. Problem details
403The caller may not perform this operation, or has no active organisation. Problem details
404The resource does not exist or is not visible to the caller. Problem details
422The request failed validation; `errors` lists each invalid field. Problem details
429Too many requests, or the AI service is busy. Retry after a short wait. Problem details
500An unexpected error. Quote the `correlationId` to support. Problem details

Request

curl -X POST "https://api.welovealfa.com/v1/analytics/sql" \
  -H "Authorization: Bearer $ALFA_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"sql":"string"}'