Get a list of indexes on a table.

GET {{baseUrl}}/tables/:tableNameOrId/indexes?compartmentId={{compartment_ocid}}&name=*&lifecycleState=ALL&limit=1000&page=ea dolore dolor&sortOrder=DESC&sortBy=timeCreated

Get a list of indexes on a table.

Request Params

KeyDatatypeRequiredDescription
compartmentIdstringThe ID of a table's compartment. When a table is identified
by name, the compartmentId is often needed to provide
context for interpreting the name.
namestringA shell-globbing-style (*?[]) filter for names.
lifecycleStatestringFilter list by the lifecycle state of the item.
limitnumberThe maximum number of items to return.
pagestringThe page token representing the page at which to start
retrieving results. This is usually retrieved from a previous
list call.
sortOrderstringThe sort order to use, either 'ASC' or 'DESC'.
sortBystringThe field to sort by. Only one sort order may be
provided. Default order for timeCreated is descending. Default
order for name is ascending. If no value is specified
timeCreated is default.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
Acceptstring

RESPONSES

status: OK

{"items":[{"keys":[{"columnName":"amet in","jsonFieldType":"d","jsonPath":"in p"},{"columnName":"deserunt","jsonFieldType":"aliquip ullamco eiusm","jsonPath":"consequat labo"}],"lifecycleDetails":"ut incididunt proident eiusmod","lifecycleState":"consectetur sit sunt","name":"ad commo"},{"keys":[{"columnName":"voluptate ullamco velit enim aute","jsonFieldType":"ut enim dolor elit adipisicing","jsonPath":"commodo cillum id labore"},{"columnName":"elit consequat officia Exc","jsonFieldType":"magna adipisicing ei","jsonPath":"in qui sunt sed consectetur"}],"lifecycleDetails":"reprehenderit quis pariatur nul","lifecycleState":"proident cillum Ut magna labore","name":"in magna"}]}