Directly canceling or deleting a record through the API is not possible. However, this can be accomplished using a datasource. Create a datasource for the table from which you wish to delete a record, using a unique field (e.g., record ID) as a parameter. Then, define a publish API for this datasource and pass the record ID to delete the specified records from the table.