3.2. Get a single row from the table by primary key.
GET {{baseUrl}}/tables/:tableNameOrId/rows?compartmentId={{compartment_ocid}}&key=id:1&consistency=EVENTUAL&timeoutInMs=5000
Get a single row from the table by primary key.
Request Params
| 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. | |||
key | string | (Required) An array of strings, each of the format "column-name:value", | |
| representing the primary key of the row. | |||
key | string | (Required) An array of strings, each of the format "column-name:value", | |
| representing the primary key of the row. | |||
consistency | string | Consistency requirement for a read operation. | |
timeoutInMs | number | Timeout setting for this operation. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"timeOfExpiration":"1970-12-17T04:40:30.277Z","usage":{"readUnitsConsumed":60911460,"writeUnitsConsumed":71257257},"value":{"laborum_a4":{}}}