Handler for SQL INSERT statements

POST /insert/sql Body: { "sql": "INSERT INTO app::collection (col1, col2) VALUES (val1, val2)" } Headers: X-App-Key (required for write authorization) The SQL INSERT must use the "app::collection" format for table references. This handler translates the SQL to JSON and calls the existing store_data handler.

POST /insert/sql

Handler for SQL INSERT statements

cURL

curl --request POST \
  --url https://api.example.com/insert/sql \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "<string>"
}
'

Body

application/json

SQL INSERT Request

sql · string · required

SQL INSERT statement Format: INSERT INTO app::collection (col1, col2) VALUES (val1, val2), (val3, val4) Example: "INSERT INTO myapp::users (name, email, age) VALUES ('Alice', '[e-mail]', 25)"

Response

200

application/json

SQL INSERT executed successfully