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 19c SODA API

Simple Oracle Document Access REST API

Oracle Database 19c SODA API is one of 9 APIs that Oracle Database 19c publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include SODA. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, authentication docs, and a JSON-LD context.

This API exposes 5 operations across 2 paths, and defines 1 schema. It is described by OpenAPI 3.2.0, at version 19.2.0.

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

5 operations 2 paths 1 schemas 1 DELETE2 GET1 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
19.2.0
Base URL
https://example.oracle.com:8443/ords/
Authentication
HTTP Basic, OAuth 2.0
Resource Areas
1

Authentication & Security 2

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

Paths & Operations 5

Across 2 paths, the API surfaces 5 operations — 1 DELETE, 2 GET, 1 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

SODA 5

Simple Oracle Document Access REST API

GET
/{schema}/soda/latest/{collection}
List documents in a SODA collection
listSodaDocuments 4 params → 200
POST
/{schema}/soda/latest/{collection}
Insert a document into a SODA collection
insertSodaDocument 2 params body → 201
GET
/{schema}/soda/latest/{collection}/{key}
Get a SODA document by key
getSodaDocument 3 params → 200
PUT
/{schema}/soda/latest/{collection}/{key}
Replace a SODA document
replaceSodaDocument 3 params body → 200
DELETE
/{schema}/soda/latest/{collection}/{key}
Delete a SODA document
deleteSodaDocument 3 params → 204

Schemas 1

The contract defines 1 schema that model the data the API accepts and returns. The most detailed is SodaListing (5 properties). Each schema is shown below with its type and property counts.

SodaListing
object
5 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-database-19c-soda-api-openapi.yml Raw ↑

Other APIs Oracle Database 19c publishes across the network.

Oracle Database SODA (Simple Oracle Document Access)
Oracle SQL Developer Web
Oracle Database API for MongoDB
Oracle Database JSON Collections API
Oracle Database REST API for AutoML
Oracle Database 19c AutoREST API
Oracle Database 19c Metadata API
Oracle Database 19c SQL API
Where this information came from

This is an independent, third-party profile of Oracle Database 19c SODA 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.