Saved SQL
Get saved SQL
GET
/
v1
/
saved-sql-queries
/
{id}
Get saved SQL
curl --request GET \
--url https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id} \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text){
"data": {
"id": "e9999999-9999-4999-8999-999999999999",
"customer_id": "o2222222-2222-2222-2222-222222222222",
"adapter": "sicarv4",
"name": "Top sellers last week",
"sql": "SELECT clave, SUM(cantidad) AS qty FROM ventas GROUP BY clave ORDER BY qty DESC LIMIT 20",
"device_id": null,
"created_by": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"created_at": "2026-09-12T10:00:00.000Z",
"updated_at": "2026-09-14T11:00:00.000Z"
}
}{
"error": {
"code": "unauthorized",
"message": "Unauthorized"
}
}{
"error": {
"code": "not_found",
"message": "Not found"
}
}⌘I
Get saved SQL
curl --request GET \
--url https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id} \
--header 'Authorization: Bearer <token>'const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "https://sand-api.orquestr.dev/cloud/v1/saved-sql-queries/{id}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text){
"data": {
"id": "e9999999-9999-4999-8999-999999999999",
"customer_id": "o2222222-2222-2222-2222-222222222222",
"adapter": "sicarv4",
"name": "Top sellers last week",
"sql": "SELECT clave, SUM(cantidad) AS qty FROM ventas GROUP BY clave ORDER BY qty DESC LIMIT 20",
"device_id": null,
"created_by": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"created_at": "2026-09-12T10:00:00.000Z",
"updated_at": "2026-09-14T11:00:00.000Z"
}
}{
"error": {
"code": "unauthorized",
"message": "Unauthorized"
}
}{
"error": {
"code": "not_found",
"message": "Not found"
}
}
