Client examples

The REST API is plain HTTP and JSON, so any language that can send a POST request works — no client library required.

cURL

curl https://wamsqlite.rendovations.com/api/v1/databases/YOUR_DATABASE_UUID/query \
  -H "Authorization: Bearer wsq_your_token" \
  -H "Content-Type: application/json" \
  -d '{"statements": ["SELECT * FROM users LIMIT 5"]}'

JavaScript (fetch)

const response = await fetch(
  'https://wamsqlite.rendovations.com/api/v1/databases/YOUR_DATABASE_UUID/query',
  {
    method: 'POST',
    headers: {
      Authorization: 'Bearer wsq_your_token',
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({
      statements: ['SELECT * FROM users LIMIT 5'],
    }),
  }
);

const data = await response.json();
console.log(data.results[0].rows);

PHP

$response = Http::withToken('wsq_your_token')
    ->post('https://wamsqlite.rendovations.com/api/v1/databases/YOUR_DATABASE_UUID/query', [
        'statements' => ['SELECT * FROM users LIMIT 5'],
    ]);

$rows = $response->json('results.0.rows');

Python (requests)

import requests

response = requests.post(
    "https://wamsqlite.rendovations.com/api/v1/databases/YOUR_DATABASE_UUID/query",
    headers={"Authorization": "Bearer wsq_your_token"},
    json={"statements": ["SELECT * FROM users LIMIT 5"]},
)

rows = response.json()["results"][0]["rows"]

See the REST API reference for the full response shape, including how errors are reported.