End-to-End Example

Number of APIs: 11

1. 1. Create a table - 1.1. Create a new table.

POST {{baseUrl}}/tables

---

2. 2. Desc the table created - 2.1. Get a list of tables in a compartment.

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

---

3. 2. Desc the table created - 2.2. Get table info by identifier.

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

---

4. 3. CRUD operations on the table created - 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

---

5. 3. CRUD operations on the table created - 3.3. Delete a single row from the table, by primary key.

DELETE {{baseUrl}}/tables/:tableNameOrId/rows?compartmentId={{compartment_ocid}}&key=id:1&isGetReturnRow=false&timeoutInMs=5000

---

6. 3. CRUD operations on the table created - 3.4. Write a single row into the table.

PUT {{baseUrl}}/tables/:tableNameOrId/rows

---

7. 4. Query Operations on the table created - 4.1. Execute a SQL query.

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

---

8. 4. Query Operations on the table created - 4.2. Check the syntax and return a brief summary of a SQL statement.

GET {{baseUrl}}/query/summarize?compartmentId={{compartment_ocid}}&statement=SELECT * FROM postman_colls d where d.body.values.key =any $val

---

9. 5. Index Operations on the table created - 5.1. Create a new index.

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

---

10. 5. Index Operations on the table created - 5.2. Get a list of indexes on a table.

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