Logo
OCI NoSQL Playground API Documentation

5.2. Get a list of indexes on a table.

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

Get a list of indexes on a table.

 

Body PARAM

Key Datatype Required Description 
compartmentId
string The 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.
name
string A shell-globbing-style (*?[]) filter for names.
lifecycleState
string Filter list by the lifecycle state of the item.
limit
number The maximum number of items to return.
page
string The page token representing the page at which to start retrieving results. This is usually retrieved from a previous list call.
sortOrder
string The sort order to use, either 'ASC' or 'DESC'.
sortBy
string The 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

Curl
curl -X GET 'https://nosql.region.oci.oraclecloud.com/20190828/tables/:tableNameOrId/indexes?compartmentId=compartment_ocid&name=*&lifecycleState=ALL&limit=1000&sortOrder=DESC&sortBy=timeCreated?compartmentId=compartment_ocid&name=*&lifecycleState=ALL&limit=1000&page=ea dolore dolor&sortOrder=DESC&sortBy=timeCreated' -H 'opc-request-id: $randomUUID' -H 'Accept: application/json'

ENDPOINTS

    Key