Типичный flow с транзакцией

Base URL: https://<host>/ (пример: http://localhost:5000). Соглашения, обзор Public API, Swagger UI.

1. POST /transaction/begin          → transaction_id
2. POST /query { ..., transaction_id }  (multiple)
3. POST /transaction/{id}/commit    или /rollback

Пример curl

# 1. Begin
 curl -X POST http://localhost:5000/api/v1/db/transaction/begin \
  -H "X-API-Key: YOUR_API_KEY" -H "Content-Type: application/json" -d '{}'

# 2. Query in tx (transaction_id from step 1)
 curl -X POST http://localhost:5000/api/v1/db/query \
  -H "X-API-Key: YOUR_API_KEY" -H "Content-Type: application/json" \
  -d '{"entity":"orders","action":"insert","data":{"total":99},"transaction_id":"tx-uuid-here"}'

# 3. Commit
 curl -X POST http://localhost:5000/api/v1/db/transaction/tx-uuid-here/commit \
  -H "X-API-Key: YOUR_API_KEY" -H "Content-Type: application/json" -d '{}'

См. также: POST /query.