POST

Sheets.Table.Update

Update a sheet grid (sheet_tables row): cells JSON, tab name, row/col size, merges, col_meta, row_meta, sources. Same endpoint the dashboard editor uses when it shows Saved.

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.Table.Update 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

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.
table_id = sheet_tables.id (from Sheets.Get → data.tables[].id), NOT sheets.id.
For one cell only, prefer Sheets.Cell.Set / Sheets.Cell.Clear.
cells is an object keyed by address, e.g. {"A1":{"v":"919687263712","s":{}}}.
Requires edit access. Locked / data-source cells should be left as-is when sending full cells.

Required Parameters

Name	Type	Sample	Explanation
`table_id` post	int	`1842`	Grid id (sheet_tables.id). Alias: id.

Optional Parameters

Name	Type	Sample	What it gives
`name` post	string	`Table 1`	Rename the tab.
`cells` post	string	`{"A1":{"v":"919687263712","s":{}}}`	Full cells map JSON (object or JSON string).
`row_count` post	int	`50`	Rows (1–500).
`col_count` post	int	`26`	Columns (1–100).
`merges` post	string	`[]`	Optional merges JSON array.
`col_meta` post	string	`{}`	Optional column widths JSON.
`row_meta` post	string	`{}`	Optional row meta JSON.
`sources` post	string	`[]`	Optional data-source bindings JSON array.

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.Table.Update",
    "method": "POST",
    "headers": {
        "Authorization": "Bearer YOUR TOKEN"
    },
    "body": {
        "table_id": "1842",
        "cells": "{\"A1\":{\"v\":\"919687263712\",\"s\":{}}}"
    },
    "url_user": "https:\/\/{user}.bull36.com\/app\/Sheets.Table.Update",
    "url_domain": "https:\/\/{domain}\/app\/Sheets.Table.Update"
}

Endpoint

POST /app/Sheets.Table.Update
POST https://{user}.bull36.com/app/Sheets.Table.Update
POST https://{domain}/app/Sheets.Table.Update

Sample Output

{
    "success": 1,
    "data": {
        "id": 1842,
        "sheet_id": 7,
        "name": "Table 1",
        "cells": {
            "A1": {
                "v": "919687263712",
                "s": []
            }
        }
    }
}

JavaScript Example

const token = 'YOUR TOKEN';
const body = new URLSearchParams();
body.set('table_id', '1842');
body.set('cells', '{\"A1\":{\"v\":\"919687263712\",\"s\":{}}}');

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

Error Example

{
    "success": 0,
    "message": "Permission Denied"
}