Update
Partial update with optimistic concurrency. The caller sends the expected_version it last read; a mismatch returns 409 VERSION_CONFLICT. On success version is incremented and last_modified_by / last_modified_at are set.
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.
Body
Partial update. expected_version must equal the query's current version (optimistic concurrency); a mismatch returns 409 VERSION_CONFLICT. Omitted fields are left unchanged.
The version the caller last read.
3
1 - 200"Disabled MFA — prod"
20001 - 100000Semantic model the query targets. Validated against the available models (/v1/schema/models) at save.
"oleria_identity"
Response
The updated 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"

