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 |