The Universal API for Oracle Database provides a unified interface to interact with Oracle Database instances. Using this API, you can securely authenticate and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE operations, without worrying about database-specific connection details.
This API leverages OAuth 2.0 for secure authentication, allowing developers to focus on data analytics, reporting, and application logic while maintaining full control over Oracle Database operations. Whether you are retrieving data or performing schema updates, the Universal API simplifies and standardizes database interactions.
Below are the endpoints and usage details to get started with Oracle Database operations using the Universal API:
POST Token
Endpoint:
{{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
POST – API for Oracle Database
Endpoint:
{{base_url}}/universalAPI?db_name=Oracle Database&db_version=All
Authorization
OAuth 2.0
Query Parameters
- db_name: Oracle Database
- db_version: All
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
