lianja / Cognite API v1 / Delete tables in a database
Back to Collection Items
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loHttp = createobject("CkHttp")
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "items": [
// ]
// }
loJson = createobject("CkJsonObject")
loJson.UpdateNewArray("items")
loHttp.SetRequestHeader("content-type","application/json")
loHttp.SetRequestHeader("api-key","{{api-key}}")
loResp = loHttp.PostJson3("https://domain.com/api/v1/projects/{{project}}/raw/dbs/:dbName/tables/delete","application/json",loJson)
if (loHttp.LastMethodSuccess = .F.) then
? loHttp.LastErrorText
release loHttp
release loJson
return
endif
? str(loResp.StatusCode)
? loResp.BodyStr
release loResp
release loHttp
release loJson
Curl Command
curl -X POST
-H "api-key: {{api-key}}"
-H "content-type: application/json"
-d '{
"items": []
}'
https://domain.com/api/v1/projects/{{project}}/raw/dbs/:dbName/tables/delete
Postman Collection Item JSON
{
"id": "deleteTables",
"name": "Delete tables in a database",
"request": {
"url": {
"host": "{{baseUrl}}",
"path": [
"api",
"v1",
"projects",
"{{project}}",
"raw",
"dbs",
":dbName",
"tables",
"delete"
],
"query": [
],
"variable": [
{
"key": "dbName",
"description": "Name of the database to delete tables in.",
"disabled": true,
"type": "string"
}
]
},
"method": "POST",
"header": [
{
"key": "api-key",
"value": "{{api-key}}",
"description": "An admin can create API keys in the Cognite console."
},
{
"key": "content-type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"items\": []\n}"
}
}
}