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.

Request Params

KeyDatatypeRequiredDescription
compartmentIdstring(Required) The ID of a table's compartment.
namestringA shell-globbing-style (*?[]) filter for names.
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.
lifecycleStatestringFilter list by the lifecycle state of the item.

HEADERS

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

RESPONSES

status: OK

{"items":[{"id":"esse ea non","compartmentId":"culpa do eiusmod id","definedTags":{"consectetur_5d7":{"voluptate5a":{}},"deserunt_1":{"minim_1":{},"Excepteur_c92":{}}},"freeformTags":{"enim_0a":"consectetur commodo","mollit9ff":"elit anim","reprehenderit_02":"eu laboris do tempor"},"lifecycleDetails":"sint","lifecycleState":"in magna veniam","name":"aliquip sed","tableLimits":{"maxReadUnits":97397199,"maxWriteUnits":66060577,"maxStorageInGBs":30338561},"timeCreated":"1985-05-02T19:56:06.169Z","timeUpdated":"1958-10-17T14:55:40.632Z"},{"id":"incididunt aliquip eiusmod","compartmentId":"deserunt magna id dolor","definedTags":{"do_9":{"fugiat_f66":{},"ullamco3db":{},"amet52":{},"consequat_7":{},"nostrud_cb6":{}}},"freeformTags":{"reprehenderit1":"anim aute"},"lifecycleDetails":"in","lifecycleState":"cupidatat consequat","name":"Excepteur mollit occaecat","tableLimits":{"maxReadUnits":3250541,"maxWriteUnits":92068543,"maxStorageInGBs":35581796},"timeCreated":"1968-07-24T10:29:28.759Z","timeUpdated":"1985-02-28T13:57:22.746Z"}]}