Jump to

• Request
• Response
• Examples

Clear Data Table Data

post

/rest/v16/adminCustom{tableName}/actions/clearData

This endpoint deletes all rows from the specified data table.

Request

Path Parameters

• tableName(required): string

Body ()

Root Schema : schema

Type: object

Show Source

• onlyInvalidRows: boolean
  Title: Only invalid rows

  Parameter to indicate to delete only invalid rows

{
    "type":"object",
    "properties":{
        "onlyInvalidRows":{
            "type":"boolean",
            "description":"Parameter to indicate to delete only invalid rows",
            "title":"Only invalid rows"
        }
    }
}

Back to Top

Response

404 Response

Requested resource(s) not found

500 Response

Unexpected error

Default Response

no content

Back to Top

Examples

The following examples show how to delete all rows from the specified data table by submitting a POST request to the REST resource using cURL. For more information about cURL, see Use cURL.

curl - X POST - i - H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" - H "Content-type: application/json"
https://sitename.oracle.com/rest/v16/adminCustomStatus/actions/clearData

Request Body Sample (Clear Filtered Data)

{
   "q": "{$or:[{StatusLabel:'CREATED'},{StatusID:8}]}"
}

Back to Top