How to delete Extract Schedules in Oracle RODS using REST APIs

This article explains how to delete the extract schedules in Oracle RODS using REST APIs.

Deleting simple or immediate extract schedules manually—one by one—in the Oracle RODS UI can be tedious and time-consuming. Instead, you can automate this process by retrieving the extract schedule IDs and deleting them via REST APIs.

1. Retrieve the Extract Schedule ID

Fetch the list of extract schedules to find the specific schedule ID you want to delete.

(Refer to article on how to fetch extract schedules using REST APIs for full details.)

2. Locate the $id Field

From the JSON response payload of the extract schedule, locate and copy the $id attribute value (for example: 300005596387893).

3. Send the REST DELETE Request

Perform a DELETE HTTP request, passing the schedule's $id at the end of the API endpoint URL and use OAUTH2.0 with BOSS scope.

• HTTP Method: DELETE
• Endpoint URL: https://<your-instance>.oraclecloud.com/api/boss/data/objects/ora/scmCore/dataExtract/v1/extractSchedules/300005596387893

Verification

A successful request will return an HTTP 204 No Content status code, confirming that the extract schedule has been permanently removed.

Before delete:

After delete: