Save a query
curl --request PUT \
--url https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"name": "active-users",
"statement": "SELECT count(*) FROM users WHERE active;"
}
'import requests
url = "https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries"
payload = {
"name": "active-users",
"statement": "SELECT count(*) FROM users WHERE active;"
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({name: 'active-users', statement: 'SELECT count(*) FROM users WHERE active;'})
};
fetch('https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries', 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://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
'name' => 'active-users',
'statement' => 'SELECT count(*) FROM users WHERE active;'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries"
payload := strings.NewReader("{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}")
req, _ := http.NewRequest("PUT", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"query": {
"name": "<string>",
"statement": "<string>",
"created_by": "<string>",
"updated_at": "2023-11-07T05:31:56Z"
}
}{
"error": "<string>",
"message": "<string>"
}{
"error": "<string>",
"message": "<string>"
}{
"error": "<string>",
"message": "<string>"
}Query & data
Save a query
Save a query under a name, shared by everyone on the account. Saving again with the same name replaces it. Name up to 80 characters, statement up to 20,000 characters, up to 100 saved queries per database.
PUT
/
api
/
v1
/
databases
/
{database_id}
/
saved-queries
Save a query
curl --request PUT \
--url https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries \
--header 'Content-Type: application/json' \
--header 'X-API-Key: <api-key>' \
--data '
{
"name": "active-users",
"statement": "SELECT count(*) FROM users WHERE active;"
}
'import requests
url = "https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries"
payload = {
"name": "active-users",
"statement": "SELECT count(*) FROM users WHERE active;"
}
headers = {
"X-API-Key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {'X-API-Key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({name: 'active-users', statement: 'SELECT count(*) FROM users WHERE active;'})
};
fetch('https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries', 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://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
'name' => 'active-users',
'statement' => 'SELECT count(*) FROM users WHERE active;'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries"
payload := strings.NewReader("{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}")
req, _ := http.NewRequest("PUT", url, payload)
req.Header.Add("X-API-Key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries")
.header("X-API-Key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["X-API-Key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"active-users\",\n \"statement\": \"SELECT count(*) FROM users WHERE active;\"\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"query": {
"name": "<string>",
"statement": "<string>",
"created_by": "<string>",
"updated_at": "2023-11-07T05:31:56Z"
}
}{
"error": "<string>",
"message": "<string>"
}{
"error": "<string>",
"message": "<string>"
}{
"error": "<string>",
"message": "<string>"
}Authorizations
Path Parameters
Body
application/json
Last modified on October 5, 2026