RArafftechnologies
Managed Databases

Save a query

Changed on

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

Request

  • Base URL
    https://api.rafftechnologies.com
  • URL
    https://api.rafftechnologies.com/api/v1/databases/{database_id}/saved-queries
  • Auth
    API key in header X-API-Key

Path parameters

database_idstring required

Database ID (UUID) or short id (the database_id field, e.g. a1b2c3d4)

Request body

namestring required
statementstring required

Example request

{
  "name": "active-users",
  "statement": "SELECT count(*) FROM users WHERE active;"
}

Response

Saved query

successboolean

Changes