v1

latestOpenAPI 3.1.0MIT2026-07-17116965.4 KB
Index

Bulk table operations

Sends multiple operatons like inserts, updates, replaces or deletes. For each operation it's object must have same format as in their dedicated method. The method expects a raw string as the batch in NDJSON. Each operation object needs to be serialized to JSON and separated by endline (\n).

An example of raw input:

{"insert": {"table": "movies", "doc": {"plot": "A secret team goes to North Pole", "rating": 9.5, "language": [2, 3], "title": "This is an older movie", "lon": 51.99, "meta": {"keywords":["travel","ice"],"genre":["adventure"]}, "year": 1950, "lat": 60.4, "advise": "PG-13"}}}
\n
{"delete": {"table": "movies","id":700}}

Responds with an object telling whenever any errors occured and an array with status for each operation:

{
  'items':
  [
    {
      'update':{'table':'products','id':1,'result':'updated'}
    },
    {
      'update':{'table':'products','id':2,'result':'updated'}
    }
  ],
  'errors':false
}
post/bulk

Response

item updated

itemsobject[]

List of results

errorsboolean

Errors occurred during the bulk operation

errorstring

Error message describing an error if such occurred

current_lineinteger

Number of the row returned in the response

skipped_linesinteger

Number of rows skipped in the response

Example response

{
  "current_line": 0,
  "skipped_lines": 6,
  "error": "error",
  "items": [
    "{}",
    "{}"
  ],
  "errors": true
}