Delete a Row

Description

This API enables you to delete a particular record or a row of a table in the Data Store, by referring to the table's unique ID or name. The row is referred by its ROWID.

Request URL

https://api.catalyst.zoho.com/baas/v1/project/{project_id}/table/{tableIdentifier}/row/{row_id}

project_id - The unique ID of the project

tableIdentifier - The unique ID of the table or the table name

row_id - The unique ROWID of the row

Request Header

Authorization: Zoho-oauthtoken 1000.910***************************16.2f****************************57

Request Method

DELETE

Scope

scope=ZohoCatalyst.tables.rows.DELETE

Note: This operation can also be executed with Catalyst user authentication permissions using Catalyst SDKs. Refer to the Catalyst API Prerequisites section for details.

SDK documentation

Delete a Row- Java SDK

Delete a Row- Node.js SDK

Delete a Row- Web SDK

CurliOS

Sample Request


				curl -X DELETE \
https://api.catalyst.zoho.com/baas/v1/project/4000000006007/table/EmpDetails/row/3376000000171021  \
-H "Authorization: Zoho-oauthtoken 1000.910***************************16.2f****************************57"

Sample Response


				{
    "status": "success",
    "data": {
        "CREATORID": 56000000002003,
        "MODIFIEDTIME": "2019-02-26 11:18:49",
        "Department_ID": "IT809"
        "Department_Name": "Accounting",
        "Customer_Name": "Jason Pierre",
        "CREATEDTIME": "2019-02-26 11:18:49",
        "ROWID": 3376000000171021,
        "doubleDataType": null
    }
}

Sample SDK code


				let database = Database()
database.delete(mexRecord) { (result) in
     switch result{
       case .success(let record):
           print("Record Deleted \(record)")
       case .error(let error):
          print("Error in Deleting record \(error)")
     }
}