Get
Returns a saved query by its id: the stored SQL, the semantic model it targets, and the authorship and version metadata recorded when it was last written. The version in the response is what a subsequent update sends as expected_version.
Authorizations
OAuth 2.0 Client Credentials flow. The tokenUrl shown is for the production environment. For other environments, replace prod with the target environment name (e.g., auth.staging.oleria.io for staging).
Path Parameters
The opaque saved-query identifier.
Response
The saved query.
A stored SQL query with authorship metadata.
Opaque stable identifier. Clients key on this, never the name.
"550e8400-e29b-41d4-a716-446655440000"
Free-form label, unique within the tenant (case-insensitive).
"Disabled MFA accounts"
The stored SQL text.
"SELECT account_id, mfa_status FROM oleria_account WHERE mfa_status = :status"
Semantic model the query targets.
"oleria_identity"
The principal (user or service client) that created or last modified the saved query, identified by a stable, opaque id.
The principal (user or service client) that created or last modified the saved query, identified by a stable, opaque id.
Monotonic version — 1 on create, incremented on every update. Doubles as the optimistic-concurrency token on update.
3
"2026-06-01T10:00:00Z"
"2026-06-04T09:30:00Z"
Optional free-form context about the query.
"Accounts where MFA is disabled — weekly review"

