Update playtable field
curl --request PATCH \
--url https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'Team-SID: <api-key>' \
--data '
{
"name": "<string>",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": [
"<string>"
],
"currency": "<string>",
"option_colors": {}
}
}
'import requests
url = "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}"
payload = {
"name": "<string>",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": ["<string>"],
"currency": "<string>",
"option_colors": {}
}
}
headers = {
"Authorization": "Bearer <token>",
"Team-SID": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {
Authorization: 'Bearer <token>',
'Team-SID': '<api-key>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
name: '<string>',
payload: {
formula: '<string>',
template: '<string>',
nl_formula: '<string>',
options: ['<string>'],
currency: '<string>',
option_colors: {}
}
})
};
fetch('https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'payload' => [
'formula' => '<string>',
'template' => '<string>',
'nl_formula' => '<string>',
'options' => [
'<string>'
],
'currency' => '<string>',
'option_colors' => [
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json",
"Team-SID: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Team-SID", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}")
.header("Authorization", "Bearer <token>")
.header("Team-SID", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Team-SID"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"operation": "update",
"item": {
"sid": "<string>",
"team_sid": "<string>",
"playtable_sid": "<string>",
"object_type": "people",
"name": "<string>",
"slug": "<string>",
"category": "scalar",
"type": "scalar_text",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": [
"<string>"
],
"currency": "<string>",
"option_colors": {}
},
"config": {
"auto_run": true,
"run_condition": {
"and": [
{}
]
},
"nl_condition": "<string>",
"daily_credit_limit": 1,
"preset_sid": "<string>"
},
"backfill": {
"status": "queued",
"scanned": 1,
"total": 1,
"queued_at": "<string>",
"started_at": "<string>",
"finished_at": "<string>",
"error": "<string>"
},
"created_by": {
"actor_type": "user",
"actor_sid": "<string>",
"team_sid": "<string>",
"permissions": {},
"actor_name": "<string>",
"oauth_client_sid": "<string>",
"reason": "<string>",
"cluster_id": 123,
"trace_id": "<string>"
},
"deleted_by": {
"actor_type": "user",
"actor_sid": "<string>",
"team_sid": "<string>",
"permissions": {},
"actor_name": "<string>",
"oauth_client_sid": "<string>",
"reason": "<string>",
"cluster_id": 123,
"trace_id": "<string>"
},
"created_at": "<string>",
"updated_at": "<string>",
"deleted_at": "<string>"
},
"updated_fields": [
"<string>"
],
"previous_values": {},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
},
"kept_fields": [
"<string>"
]
}{
"success": false,
"error": {
"code": "validation_failed",
"message": "<string>",
"recoverable": true,
"suggestion": "<string>",
"field_errors": {},
"blockers": [
{
"type": "<string>",
"severity": "hard",
"description": "<string>",
"entity_sid": "<string>",
"resolution": "<string>",
"resolution_hint": "<string>",
"count": 123
}
],
"context": {}
},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
}
}{
"success": false,
"error": {
"code": "validation_failed",
"message": "<string>",
"recoverable": true,
"suggestion": "<string>",
"field_errors": {},
"blockers": [
{
"type": "<string>",
"severity": "hard",
"description": "<string>",
"entity_sid": "<string>",
"resolution": "<string>",
"resolution_hint": "<string>",
"count": 123
}
],
"context": {}
},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
}
}playtable_fields
Update playtable field
Partial update of name, type, payload or config; each JSON value is a full replacement, never a deep merge. slug, category and object_type are immutable. Dependency edges are rebuilt and cycle-checked (a cycle is 422). A set or changed scalar formula recomputes the whole column, manually pinned cells included (warn the user when it holds data); action payload or config changes touch only future runs, paid done cells are never re-run by themselves. At least one field.
Contract:
- MCP tool
update_playtable_field, registry packagemcp.playtables/playtable_fields, mountplaytables.columns. - Operation
update, response envelopeupdate. - Flags: none.
PATCH
/
api
/
playtable-fields
/
{sid}
Update playtable field
curl --request PATCH \
--url https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'Team-SID: <api-key>' \
--data '
{
"name": "<string>",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": [
"<string>"
],
"currency": "<string>",
"option_colors": {}
}
}
'import requests
url = "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}"
payload = {
"name": "<string>",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": ["<string>"],
"currency": "<string>",
"option_colors": {}
}
}
headers = {
"Authorization": "Bearer <token>",
"Team-SID": "<api-key>",
"Content-Type": "application/json"
}
response = requests.patch(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PATCH',
headers: {
Authorization: 'Bearer <token>',
'Team-SID': '<api-key>',
'Content-Type': 'application/json'
},
body: JSON.stringify({
name: '<string>',
payload: {
formula: '<string>',
template: '<string>',
nl_formula: '<string>',
options: ['<string>'],
currency: '<string>',
option_colors: {}
}
})
};
fetch('https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PATCH",
CURLOPT_POSTFIELDS => json_encode([
'name' => '<string>',
'payload' => [
'formula' => '<string>',
'template' => '<string>',
'nl_formula' => '<string>',
'options' => [
'<string>'
],
'currency' => '<string>',
'option_colors' => [
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json",
"Team-SID: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}"
payload := strings.NewReader("{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}")
req, _ := http.NewRequest("PATCH", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Team-SID", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.patch("https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}")
.header("Authorization", "Bearer <token>")
.header("Team-SID", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://beta.getsales.io/playtables/v1/api/playtable-fields/{sid}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Team-SID"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"name\": \"<string>\",\n \"payload\": {\n \"formula\": \"<string>\",\n \"template\": \"<string>\",\n \"nl_formula\": \"<string>\",\n \"options\": [\n \"<string>\"\n ],\n \"currency\": \"<string>\",\n \"option_colors\": {}\n }\n}"
response = http.request(request)
puts response.read_body{
"success": true,
"operation": "update",
"item": {
"sid": "<string>",
"team_sid": "<string>",
"playtable_sid": "<string>",
"object_type": "people",
"name": "<string>",
"slug": "<string>",
"category": "scalar",
"type": "scalar_text",
"payload": {
"formula": "<string>",
"template": "<string>",
"nl_formula": "<string>",
"options": [
"<string>"
],
"currency": "<string>",
"option_colors": {}
},
"config": {
"auto_run": true,
"run_condition": {
"and": [
{}
]
},
"nl_condition": "<string>",
"daily_credit_limit": 1,
"preset_sid": "<string>"
},
"backfill": {
"status": "queued",
"scanned": 1,
"total": 1,
"queued_at": "<string>",
"started_at": "<string>",
"finished_at": "<string>",
"error": "<string>"
},
"created_by": {
"actor_type": "user",
"actor_sid": "<string>",
"team_sid": "<string>",
"permissions": {},
"actor_name": "<string>",
"oauth_client_sid": "<string>",
"reason": "<string>",
"cluster_id": 123,
"trace_id": "<string>"
},
"deleted_by": {
"actor_type": "user",
"actor_sid": "<string>",
"team_sid": "<string>",
"permissions": {},
"actor_name": "<string>",
"oauth_client_sid": "<string>",
"reason": "<string>",
"cluster_id": 123,
"trace_id": "<string>"
},
"created_at": "<string>",
"updated_at": "<string>",
"deleted_at": "<string>"
},
"updated_fields": [
"<string>"
],
"previous_values": {},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
},
"kept_fields": [
"<string>"
]
}{
"success": false,
"error": {
"code": "validation_failed",
"message": "<string>",
"recoverable": true,
"suggestion": "<string>",
"field_errors": {},
"blockers": [
{
"type": "<string>",
"severity": "hard",
"description": "<string>",
"entity_sid": "<string>",
"resolution": "<string>",
"resolution_hint": "<string>",
"count": 123
}
],
"context": {}
},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
}
}{
"success": false,
"error": {
"code": "validation_failed",
"message": "<string>",
"recoverable": true,
"suggestion": "<string>",
"field_errors": {},
"blockers": [
{
"type": "<string>",
"severity": "hard",
"description": "<string>",
"entity_sid": "<string>",
"resolution": "<string>",
"resolution_hint": "<string>",
"count": 123
}
],
"context": {}
},
"meta": {
"trace_id": "<string>",
"span_id": "<string>",
"timestamp": "<string>",
"duration_ms": 1,
"team_sid": "<string>",
"actor_type": "<string>"
}
}Authorizations
Access token issued by gs.service.id. Its access_identity claim carries team_sid, actor_sid and actor_type, and that team scope is authoritative.
Team scope for tokens that do not carry one. Ignored when the token already names a team.
Path Parameters
Playtable field sid (pt_fd_…).
Required string length:
18Pattern:
^pt_fd_Body
application/json
Request body of update_playtable_field.
New display label (1..255); the slug never changes.
Required string length:
1 - 255Type change of a scalar column (scalar to scalar only): every cell is re-cast, unconvertible values are flagged is_not_valid, the ES slot moves. Widgets and actions never convert.
Available options:
scalar_text, scalar_number, scalar_currency, scalar_date, scalar_url, scalar_checkbox, scalar_select, scalar_multiselect, scalar_image Full replacement; shape must still match the row's immutable type.
- Option 1
- Option 2
- Option 3
- Option 4
- Option 5
- Option 6
- Option 7
- Option 8
Show child attributes
Show child attributes
Full replacement; action fields only (non-default on scalar/widget → 422).
Show child attributes
Show child attributes
Response
update success envelope.
Available options:
true Available options:
update Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes
The fields this write did not change because the person's own value stands on them (stamped person); read the item for what landed.