Loading...

Truncate a Table

Description

This API enables you to truncate a specific table in the Data Store, by referring to the table’s unique ID or name.

The truncate operation deletes all the records in the table, while retaining its schema. The columns of the table and the table’s metadata will still be available, after the operation has ended.

You will receive notifications in your Catalyst console about the updates of the operation.

Request Details

Request URL

DELETE

{api-domain}/baas/v1/project/{project_id}/table/{tableIdentifier}/truncate

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

Request Headers

Authorization: Zoho-oauthtoken {oauth_token}

Optional Headers

CATALYST-ORG: {org_id}

Environment: Development

Scope

ZohoCatalyst.tables.rows.DELETE

Response Details

The response will return the status of the truncate operation.

Sample Request
copy

curl -X DELETE
https://api.catalyst.zoho.com/baas/v1/project/4000000006007/table/NewsHeadlines/truncate
-H “Authorization: Zoho-oauthtoken 1000.910*************************16.2f*************************57”

Sample Response
copy
{
    "status": "success",
    "data": "The table will be truncated Shortly. Kindly Check Notification bar for updates"
}