How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Oracle Database Bulk Operations API

Bulk insert, delete, and update operations

Oracle Database Bulk Operations API is one of 29 APIs that Oracle Database publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 5 JSON Schema definitions.

Tagged areas include Bulk Operations. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, an API reference, and 5 JSON Schemas.

This API exposes 4 operations across 4 paths, and defines 8 schemas. It is described by OpenAPI 3.2.0, at version 1.0.0.

Requests are made against a single base URL, https://{host}:{port}/ords/{schema}/soda/{version}.

4 operations 4 paths 8 schemas 4 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
1.0.0
Server
https://{host}:{port}/ords/{schema}/soda/{version}
Authentication
OAuth 2.0, HTTP Basic
Terms of Service
Resource Areas
1

Authentication & Security 2

Oracle Database Bulk Operations API declares 2 security schemes for authenticating requests. It supports OAuth 2.0 (oauth2) using the clientCredentials flow. It accepts HTTP basic authentication (basicAuth). By default, every request must be authenticated.

Paths & Operations 4

Across 4 paths, the API surfaces 4 operations — 4 POST. Each is listed below with its method, path, parameters, and response codes.

Bulk Operations 4

Bulk insert, delete, and update operations

POST
/custom-actions/insert/{collection}
Oracle Database Bulk insert documents
bulkInsert 1 param body → 200401404405
POST
/custom-actions/delete/{collection}
Oracle Database Bulk delete documents by filter
bulkDelete 1 param body → 200401404405
POST
/custom-actions/truncate/{collection}
Oracle Database Truncate all documents from collection
truncateCollection 1 param → 200401404405
POST
/custom-actions/update/{collection}
Oracle Database Bulk update documents by filter
bulkUpdate 1 param body → 200401405

Schemas 8

The contract defines 8 schemas that model the data the API accepts and returns. The most detailed are JsonPatchOperation (4 properties), DocumentMetadata (4 properties), Error (2 properties), BulkUpdateResponse (2 properties). Each schema is shown below with its type and property counts.

BulkUpdateResponse
object
2 properties
BulkUpdateRequest
object
Combination of QBE filter fields and $patch operations. Filter fields identify documents to update, $patch contains the JSON Patch operations to apply.
1 property
Error
object
2 properties
BulkDeleteResponse
object
2 properties
JsonPatchOperation
object
4 properties 2 required
BulkInsertResponse
object
2 properties
DocumentMetadata
object
4 properties
QBEFilter
object
Query by Example filter specification. Provide field names and values to match, or use operators like $gt, $lt, $in, $regex, etc.

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-database-bulk-operations-api-openapi.yml Raw ↑

Other APIs Oracle Database publishes across the network.

Oracle Database API for MongoDB
Oracle Database JDBC
Oracle Call Interface (OCI)
Oracle SQL Developer REST API
Oracle Transactional Event Queues (TxEventQ)
Oracle Database APEX API
Oracle Database Autonomous Databases API
Oracle Database Backups API
Oracle Database Collections API
Oracle Database Data Dictionary API
Oracle Database Data Guard API
Oracle Database Data Pump API
Where this information came from

This is an independent, third-party profile of Oracle Database Bulk Operations API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.