Delete Worksheet Data
- To delete data in a worksheet, you need the following 3 parameters:
- 1.Token
- 2.Worksheet Id
- 3.App Id
DELETE
https://api.tablesprint.com/api/platform/worksheet/row/{appId}/{worksheetId}
URL Parameters​
Parameter | Type | Required | Description |
---|---|---|---|
appId | string | Yes | The unique identifier of the application |
worksheetId | string | Yes | The unique identifier of the worksheet |
To get URL parameters follow these steps:
- 1.Click on the downward arrow beside the worksheet name.
- 2.A dialog box with options will open.
- 3.Click on More Info, and you'll see the worksheetId and AppId.
Request Body Parameters​
Parameter | Type | Required | Description |
---|---|---|---|
_ids | array | yes | The id's of the row to be deleted. |
How to know _id of the row?
- 1.To retrieve the _id of the rows, request the data using the "Get Worksheet Data" API.
- 2.Then, for each row, you will receive an _id.
Example :
{
"_ids": ["1abe793912", "6abc791234", "1def795678"]
}
Request Headers
Header | Value |
---|---|
Authorization | Bearer YOUR_ACCESS_TOKEN |
Content-Type | application/json |
Example Request​
Here's an example of how to make this request:
curl -L -X DELETE 'https://api.tablesprint.com/api/platform/worksheet/row/077c6bd4-4c75-4919-92e5-7b584d361d30/3d198497-5a8f-4881-8d9c-ce26f317ef85' \
-H 'Content-Type: application/json' \
-H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyZXF1ZXN0SWQiOiJmY2JlNzVjYy02ODk4LTRhZGMtOGU1YS0yYzczYWFjYjZlM2UiLCJ1c2VyVHlwZSI6IlBBVCIsImlhdCI6MTc0NDE5MzE5MiwiZXhwIjoxNzQ2MDA3NTU5fQ.ckKXuMz1RZdirYltAzC2NizjszlL7Jv3zPG09oIdmXA' \
-d '{
"_ids": [
"1abe793912",
"6abc791234",
"1def795678"
]
}'
Response​
A successful request returns the HTTP 200 OK
status code and JSON response body.
- In case you get other error codes: Refer here
{
"results": {
"message": "Rows deleted successfully!"
},
"success": true
}
Response Headers
Header | Description |
---|---|
Content-Type | application/json |