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
Response
The batch ran
Example response
{
"warnings": [
{
"severity": "warning"
}
]
}Changes
No recorded changes to this operation across all 1 revision of this API.