Loading...

Catalyst

by Zoho
×
Cancel

ACCESS THIS PAGE
Ask AI Ready to assist

Ask me anything

How can I help you with Catalyst today?

  • AI Toolkit
    Context for LLMs NI CLI Catalyst MCP Server Catalyst AI Plugin
  • Developer Tools
    CLI
    SDK
    Java JavaScript Python Android iOS Flutter
    REST API
    Utilities
    Extensions Tools Integrations
  • Tutorials
    • Go to console

    Bulk Delete Rows in a Table

    Description

    This API enables you to delete records or rows of data in bulk from a specific table in the Data Store. The table is referred by its unique ID or name.

    The bulk delete operation can delete a maximum of 200 rows in a single API call. You can choose the rows to be deleted by passing the unique ROWIDs of those rows as params in the request URL, as shown in the sample request.

    You must include at least one ROWID, and can include upto 200 ROWIDs, in the request.

    Request Details

    Request URL

    DELETE

    {api-domain}/baas/v1/project/{project_id}/table/{tableIdentifier}/row?ids={rowID_1},{rowID_2},{rowID_3}

    copy
    api-domain
    URL
    The DC-specific domain to access Catalyst API
    project_id
    Numerical
    The unique ID of the project
    tableIdentifier
    Numerical
    The unique ID of the table or table name
    ids
    Numerical
    The Row IDs of the records to be deleted as params. Multiple Row IDs must be separated by commas. The parameter key name must be ids

    Request Headers

    Authorization: Zoho-oauthtoken {oauth_token}

    Optional Headers

    CATALYST-ORG: {org_id}

    Environment: Development

    Scope

    ZohoCatalyst.tables.rows.DELETE

    Response Details

    The response contains the data of all the rows that were deleted through the operation, including their metadata like theROWID and CREATEDTIME, and the column key names and values in each row.

    Sample Request
    copy
    curl -X DELETE 
    
https://api.catalyst.zoho.com/baas/v1/project/4000000006007/table/EmpDetails/row?ids=1028000000171815,1028000000171810,1028000000171805,1028000000171617 
    
-H “Authorization: Zoho-oauthtoken 1000.910*************************16.2f*************************57”
    Sample Response
    copy
    {
"status": "success",
"data": [
    {
        "CREATORID": "1444000000003001",
        "MODIFIEDTIME": "2020-11-19 15:20:21:830",
        "Department_ID":"IT245",
        "Department_Name":"Finance",
        "Employee_Name": "Morgan Jones",
        "CREATEDTIME": "2020-11-19 15:20:21:830",
        "ROWID": "1028000000171815"
    },
    {
        "CREATORID": "1444000000003001",
        "MODIFIEDTIME": "2020-11-19 15:20:34:503",
        "Department_ID":"IT121",
        "Department_Name":"HR",
        "Employee_Name": "Leena Medley",
        "CREATEDTIME": "2020-11-19 15:20:34:503",
        "ROWID": "1028000000171810"
    },
    {
        "CREATORID": "1444000000003001",
        "MODIFIEDTIME": "2020-11-19 15:20:42:314",
        "Department_ID":"IT783",
        "Department_Name":"Marketing",
        "Employee_Name": "Tamira Shah",
        "CREATEDTIME": "2020-11-19 15:20:42:314",
        "ROWID": "1028000000171805"
    },
   {
        "CREATORID": "1444000000003001",
        "MODIFIEDTIME": "2020-11-19 15:20:42:314",
        "Department_ID":"IT098",
        "Department_Name":"Sales",
        "Employee_Name": "Julia McGregor",
        "CREATEDTIME": "2020-11-19 15:20:42:314",
        "ROWID": "1028000000171617"
    }
]

    

    }
    View more

    SDK Documentation
    Bulk Delete Rows- Java SDK

    Bulk Delete Rows- Node.js SDK

    Bulk Delete Rows- Python SDK

    Bulk Delete Rows- Web SDK