Projects

Run several SQL statements with an explicit transaction

Runs up to 100 statements against the project's schema with the project service key. Each entry is exactly one statement. transaction "all" (default) runs them in one transaction: the first failure rolls back every statement and answers 400 SQL_BATCH_STATEMENT_FAILED naming its index. transaction "each" gives every statement its own transaction and reports each outcome, so later statements still run; status is "partial" when any failed.

post/projects/v1/{project_id}/sql/batch

Request

  • Base URL: https://api.run402.com
  • URL: https://api.run402.com/projects/v1/{project_id}/sql/batch
  • Auth: HTTP bearer

Path parameters

project_idstring required

Run402 project ID. Public IDs are not UUIDs.

Example:prj_1741340000_0042

Request body

transaction'all' | 'each'

Response

The batch ran

status'ok' | 'partial'
schemastring
transaction'all' | 'each'

Example response

{
  "warnings": [
    {
      "severity": "warning"
    }
  ]
}

Changes

No recorded changes to this operation across all 1 revision of this API.