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
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 | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
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"}]}