Used to delete data from Data Table.
| Method | DELETE |
| Endpoint | https://{{host}}/api/public/tables/{{tableName}} |
| Content Type | application/json |
| Authorization |
|
| App Access |
Read and Delete access to the Data Table from the Data Definition in DaaS. For more information, see app assignment for accessing the data in a table and Data as a Service articles. |
Path Parameters
| Parameter | Description |
|---|---|
| host | Environment URL, for example, https://bots.kore.ai |
| tableName | Name of the Table to delete data |
Sample Request
curl -X DELETE \
http://{{host}}/api/public/tables/{{tableName}} \
-H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}' \
-H 'content-type: application/json' \
-d '{
"query":{
"expressions": [
{"field": "firstName", "operand": "=", "value": "Jane"},
{"field": "lastName", "operand": "=", "value": "Doe"}
],
"operator": "and"
}
}'
Body Parameters
| Parameter | Description |
|---|---|
| query |
Filter criteria identifying the row to be deleted "query":{
"expressions": [
{"field": "<col1_name>", "operand": "=/!=/</>", "value": "<value1>"},
{"field": "<col2_name>", "operand": "=/!=/</>", "value": "<value2>"}
],
"operator": "and/or"
}
|
Sample Response
{
“nDeleted”:1
}