5.1. Create a new index.
POST {{baseUrl}}/tables/:tableNameOrId/indexes
Create a new index on the table identified by tableNameOrId.
Request Body
{"name"=>"exampleindex", "keys"=>[{"columnName"=>"body", "jsonFieldType"=>"STRING", "jsonPath"=>"\"_custom_metadata\"[].key"}], "compartmentId"=>"{{compartment_ocid}}", "isIfNotExists"=>true}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-retry-token | string | A token that uniquely identifies a request so it can be retried | |
| in case of a timeout or server error without risk of executing | |||
| that same action again. Retry tokens expire after 24 hours, but | |||
| can be invalidated before then due to conflicting | |||
| operations. For example, if a resource has been deleted and | |||
| purged from the system, then a retry of the original creation | |||
| request might be rejected. | |||
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |