NoSQL Database API

Number of APIs: 22

The control plane API for NoSQL Database Cloud Service HTTPS provides endpoints to perform NDCS operations, including creation and deletion of tables and indexes; population and access of data in tables; and access of table usage metrics.

1. query - Execute a SQL query.

POST {{baseUrl}}/query?limit=1000

---

2. query - Prepare a SQL statement for use in a query with variable substitution.

GET {{baseUrl}}/query/prepare?compartmentId={{compartment_ocid}}&statement=SELECT * FROM DUAL

---

3. query - Check the syntax and return a brief summary of a SQL statement.

GET {{baseUrl}}/query/summarize?compartmentId={{compartment_ocid}}&statement=SELECT * FROM DUAL

---

4. tables-{tableNameOrId}-indexes-{indexName} - Delete an index.

DELETE {{baseUrl}}/tables/:tableNameOrId/indexes/:indexName?compartmentId={{compartment_ocid}}&isIfExists=false

---

5. tables-{tableNameOrId}-indexes-{indexName} - Get information about a single index.

GET {{baseUrl}}/tables/:tableNameOrId/indexes/:indexName?compartmentId={{compartment_ocid}}

---

6. tables - Get a list of tables in a compartment.

GET {{baseUrl}}/tables?compartmentId={{compartment_ocid}}&name=*&limit=1000&sortOrder=DESC&sortBy=timeCreated&lifecycleState=ALL

---

7. tables-{tableNameOrId} - Get table info by identifier.

GET {{baseUrl}}/tables/:tableNameOrId?compartmentId={{compartment_ocid}}

---

8. tables-{tableNameOrId}-indexes - Create a new index.

POST {{baseUrl}}/tables/:tableNameOrId/indexes

---

9. tables - Create a new table.

POST {{baseUrl}}/tables

---

10. tables-{tableNameOrId}-rows - Get a single row from the table by primary key.

GET {{baseUrl}}/tables/:tableNameOrId/rows?compartmentId={{compartment_ocid}}&key=veniam velit elit pariatur&key=sint in&consistency=EVENTUAL&timeoutInMs=5000

---