REST APIs
Oracle REST Data Services also provides REST APIs that can be invoked via cURL to connect to an Oracle database and perform operations.
Users must be assigned to the "REST Enabled SQL" application role in order to use REST APIs with Oracle Utilities cloud services. See Pre-Defined Application Roles in the Oracle Utilities Cloud Services Administration Guide for more information about application roles used with Oracle Utilities cloud services.
OAuth-based authorization is also supported. You may request creation of a dedicated OAuth Client for the access to Oracle REST Data Services REST API. See the Oracle Utilities Cloud Services Administration Guide for more information.
Note: OAuth-based authorization is also supported in prior releases provided they are up to date with the latest maintenance pack and hot fix releases.
The service runs the SQL statements against Oracle Database and returns the result to the client in a JSON format. You can use the HTTPS POST method to access the REST-Enabled SQL service.
The following is an example syntax for cURL command.
curl -i -X POST --user <username>:<password> --data-binary "<SQL statement>" -H "Content-Type: application/sql" -k <Oracle REST URL>
Contact your system administrator for Oracle Database Actions and REST service URLs.
No additional configuration is required to use Oracle Database Actions or REST services.
Use of this feature is subject to the following:
• Basic Authentication and OAuth are supported
• Read Only Access
• Supports Data Access Language (DAL) that includes retrieval of Performance Hub Report etc.
• Only supports retrieval of small sets of data
• SQL Query timeout limit is 5 minutes
• Output will be in JSON format