2.1. Get a list of tables in a compartment.
GET {{baseUrl}}/tables?compartmentId={{compartment_ocid}}&name=*&limit=1000&sortOrder=DESC&sortBy=timeCreated&lifecycleState=ALL
Get a list of tables in a compartment.
Body
PARAM
Key | Datatype | Required | Description |
compartmentId
|
string | (Required) The ID of a table's compartment. | |
name
|
string | A shell-globbing-style (*?[]) filter for names. | |
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. | |
lifecycleState
|
string | Filter list by the lifecycle state of the item. |
HEADERS
Key | Curl curl -X GET 'https://nosql.region.oci.oraclecloud.com/20190828/tables?compartmentId=compartment_ocid&name=*&limit=1000&sortOrder=DESC&sortBy=timeCreated&lifecycleState=ALL?compartmentId=compartment_ocid&name=*&limit=1000&page=ea dolore dolor&sortOrder=DESC&sortBy=timeCreated&lifecycleState=ALL' -H 'opc-request-id: $randomUUID' -H 'Accept: application/json' ENDPOINTS |