POST

Sheets.Cell.Delete

Clear/delete one cell. Alias of Sheets.Cell.Clear.

Permissions

  • User must be logged in with a valid bearer token.
  • The user must be from the same company domain as the request Host (call the API on that account subdomain or allowed custom domain). A token from another company returns success=0, error user_not_in_company.
  • Returned or changed records are limited by the user permissions, team access, folder access, and account settings.

Action

  • Runs the Sheets.Cell.Delete function and returns JSON.

Push Service

No push is sent because this function only reads data or returns helper information.

Automation

No automation is run for this function.

Special Instructions

  • Send the bearer token on protected calls with Authorization: Bearer YOUR TOKEN.
  • On a company subdomain (e.g. https://{user_domain}.bull36.com) the user must match that Host — Login and protected APIs reject another company with success=0, error user_not_in_company. On a main brand host (bull36.com, biz1.co.il, mastrocrm.com, …) the company domain gate is skipped.
  • Send parameters as POST body fields exactly as documented.

Required Parameters

No body parameters are required for this function.

Optional Parameters

NameTypeSampleWhat it gives
ref
post
string1842.A1Cell ref table_id.A1.
table_id
post
int1842Grid id when ref omitted.
addr
post
stringA1Address when ref omitted.

Authentication

Send the bearer token returned by Login in the request header. The user must be from the same company domain as this Host — a token from another company is rejected (user_not_in_company).

Authorization: Bearer YOUR TOKEN

Sample Request

{
    "url": "\/app\/Sheets.Cell.Delete",
    "method": "POST",
    "headers": {
        "Authorization": "Bearer YOUR TOKEN"
    },
    "body": {
        "table_id": "1842",
        "addr": "A1"
    },
    "url_user": "https:\/\/{user}.bull36.com\/app\/Sheets.Cell.Delete",
    "url_domain": "https:\/\/{domain}\/app\/Sheets.Cell.Delete"
}

Endpoint

POST /app/Sheets.Cell.Delete
POST https://{user}.bull36.com/app/Sheets.Cell.Delete
POST https://{domain}/app/Sheets.Cell.Delete

Sample Output

{
    "success": 1,
    "ref": "1842.A1",
    "data": null
}

JavaScript Example

const token = 'YOUR TOKEN';
const body = new URLSearchParams();
body.set('table_id', '1842');
body.set('addr', 'A1');

const res = await fetch('/app/Sheets.Cell.Delete', {
  method: 'POST',
  headers: { Authorization: `Bearer ${token}` },
  body
});
const data = await res.json();
console.log(data);

Error Example

{
    "success": 0,
    "message": "Cell is locked or bound to a data source"
}