4.1. Execute a SQL query.
POST {{baseUrl}}/query?limit=1000
Execute a SQL query.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
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. | |||
Request Body
{"compartmentId"=>"{{compartment_ocid}}", "statement"=>"select $u.body.\"_custom_metadata\".key =any 'region' as region , $u from postman_colls $u", "consistency"=>"EVENTUAL", "isPrepared"=>false, "maxReadInKBs"=>0, "timeoutInMs"=>5000}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"items":[{"veniam_c_a":{}},{"Excepteurb3":{}}],"usage":{"readUnitsConsumed":98445474,"writeUnitsConsumed":49790137}}