Logo
OCI NoSQL Playground API Documentation

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