curl --request GET \
--url https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id} \
--header 'Authorization: Bearer <token>'import requests
url = "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"query_id": "550e8400-e29b-41d4-a716-446655440000",
"name": "Disabled MFA accounts",
"query_string": "SELECT account_id, mfa_status FROM oleria_account WHERE mfa_status = :status",
"model": "oleria_identity",
"created_by": {
"type": "user",
"id": "ol_a1b2c3d4-e5f6-7890-abcd-ef1234567890"
},
"last_modified_by": {
"type": "user",
"id": "ol_a1b2c3d4-e5f6-7890-abcd-ef1234567890"
},
"version": 3,
"created_at": "2026-06-01T10:00:00Z",
"last_modified_at": "2026-06-04T09:30:00Z",
"description": "Accounts where MFA is disabled — weekly review"
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}{
"code": "SAVED_QUERY_NOT_FOUND",
"message": "Saved query not found"
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}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.
curl --request GET \
--url https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id} \
--header 'Authorization: Bearer <token>'import requests
url = "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://devx.{environment}.oleria.io/v1/query/saved-queries/{query_id}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"query_id": "550e8400-e29b-41d4-a716-446655440000",
"name": "Disabled MFA accounts",
"query_string": "SELECT account_id, mfa_status FROM oleria_account WHERE mfa_status = :status",
"model": "oleria_identity",
"created_by": {
"type": "user",
"id": "ol_a1b2c3d4-e5f6-7890-abcd-ef1234567890"
},
"last_modified_by": {
"type": "user",
"id": "ol_a1b2c3d4-e5f6-7890-abcd-ef1234567890"
},
"version": 3,
"created_at": "2026-06-01T10:00:00Z",
"last_modified_at": "2026-06-04T09:30:00Z",
"description": "Accounts where MFA is disabled — weekly review"
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}{
"code": "SAVED_QUERY_NOT_FOUND",
"message": "Saved query not found"
}{
"code": "QUERY_PARSE_ERROR",
"message": "Failed to parse SQL query",
"details": {
"line": 3,
"column": 15,
"hint": "Unexpected token near 'SELCT'"
},
"reasons": [
{
"code": "MUTATION_NOT_ALLOWED",
"message": "Only SELECT queries are permitted. Mutation statements are not allowed."
}
]
}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.
Show child attributes
Show child attributes
The principal (user or service client) that created or last modified the saved query, identified by a stable, opaque id.
Show child attributes
Show child attributes
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"

