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.

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 SQL Developer Web and REST service URLs.

No additional configuration is required to use Oracle SQL Developer Web or REST services.

Use of this feature is subject to the following:

• Only Basic Authentication is 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