Used to delete data from Data Table.
To use this API, the app needs to be given Read and Delete access to the Data Table from the Data Definition in DaaS (see here for details)
DELETE https://{{host}}/api/public/tables/{{tableName}}
Kore.ai Bots Platform provides access to bot development using secured APIs. Refer here to learn more on how to use these APIs.
Query Parameters
Parameter | Description |
---|---|
host | Environment URL, for example, https://bots.kore.ai |
tableName | Name of the Table to delete data |
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" } |
Authorization
Invoke the API with JWT in the header with the following syntax:
auth: {{JWT}}
Response content type
application/json
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" } }'
Sample Response
{ “nDeleted”:1 }