> ## Documentation Index > Fetch the complete documentation index at: https://docs.getsales.io/llms.txt > Use this file to discover all available pages before exploring further. # Search playtable field values > Cell-level execution records - per-cell status, cost cache, error and pin state, with a counts block (status / playtable_field_sid breakdowns). Use for: which cells errored for a field, why enrichment failed across rows, error-by-field health (page_size:0 + counts.groups). Requires a scope filter: playtable_sid.eq OR object_sid OR sid.in (422 otherwise). NOT for bulk value reads (people/companies search, include:["field_values"]) or money aggregates (credit-ledger-entries tools). Contract: - MCP tool `search_playtable_field_values`, registry package `mcp.playtables/playtable_field_values`, mount `playtables.columns`. - Operation `search`, response envelope `search`. - Flags: read only. ## OpenAPI ````yaml /api-reference/playtables/openapi.yaml post /api/playtable-field-values/search openapi: 3.0.3 info: title: 'GetSales public contract: gs.service.playtables' description: >- The data platform and the outreach engine: tables of people and companies, their enrichment columns, cells and runs, the data sources that feed them, sender profiles, the stoplist, the activity feed, the credit ledger, and the multichannel workflows with their per-person journeys and tasks. GENERATED. This document is projected from the Zod MCP tool registry in `product/mcp/gs.mcp` (one tool per public endpoint, 1:1). Do not edit it by hand; edit the tool definition and regenerate with `pnpm openapi:public`. Surface: the public `/api` contract of `gs.service.playtables`, 142 operations. This is the only OpenAPI document the platform publishes. Internal (`/internal`) and health endpoints are deliberately absent: they are not part of any contract, they can change without notice, and the service source is their only description. Conventions: - Auth is a bearer JWT, optionally narrowed by the `Team-SID` header. - Every success body is an MCP envelope: `success: true` plus one typed `operation` shape (`search`, `get`, `create`, `update`, `delete`, `metrics`, `group_by`, `action`), and a `meta` block with `trace_id` for support. - Every failure is the same `McpError` envelope with a code from a fixed 16-code taxonomy, so a client maps errors once. - Lists page with `page_size` (0 to 500, default 50) plus an opaque forward `cursor`; `page_size: 0` returns counts only. - On `GET` and `DELETE`, object-valued query parameters (`filter`, `sort`) travel as JSON text and array-valued ones repeat as `name[]=value`. - The MCP-only `_meta` field (usage analytics) never reaches the backend and is not part of this contract. version: '1.0' contact: name: GetSales url: https://getsales.io email: support@getsales.io license: name: Proprietary url: https://getsales.io/terms servers: - url: https://beta.getsales.io/playtables/v1 description: >- Production (the gateway path on the beta ring; the origin is provisioned per DEPLOY_MAP.md) security: - BearerJwt: [] TeamSid: [] tags: - name: activities description: >- Registry package `mcp.playtables/activities`, served on MCP mount `playtables.journeys`. - name: activity_objects description: >- Registry package `mcp.playtables/activity_objects`, served on MCP mount `playtables.people`. - name: companies description: >- Registry package `mcp.playtables/companies`, served on MCP mount `playtables.people`. - name: credit_ledger_entries description: >- Registry package `mcp.playtables/credit_ledger_entries`, served on MCP mount `id.billing`. - name: data_source_items description: >- Registry package `mcp.playtables/data_source_items`, served on MCP mount `playtables.sources`. - name: data_sources description: >- Registry package `mcp.playtables/data_sources`, served on MCP mount `playtables.sources`. - name: notes description: >- Registry package `mcp.playtables/notes`, served on MCP mount `playtables.pipeline`. - name: people description: >- Registry package `mcp.playtables/people`, served on MCP mount `playtables.people`. - name: pipeline_stages description: >- Registry package `mcp.playtables/pipeline_stages`, served on MCP mount `playtables.pipeline`. - name: plays description: >- Registry package `mcp.playtables/plays`, served on MCP mount `playtables.pipeline`. - name: playtable_field_values description: >- Registry package `mcp.playtables/playtable_field_values`, served on MCP mount `playtables.columns`. - name: playtable_fields description: >- Registry package `mcp.playtables/playtable_fields`, served on MCP mount `playtables.columns`. - name: playtable_runs description: >- Registry package `mcp.playtables/playtable_runs`, served on MCP mount `playtables.columns`. - name: playtable_views description: >- Registry package `mcp.playtables/playtable_views`, served on MCP mount `playtables.tables`. - name: playtables description: >- Registry package `mcp.playtables/playtables`, served on MCP mount `playtables.tables`. - name: result_pages description: >- Registry package `mcp.playtables/result_pages`, served on MCP mount `playtables.tables`. - name: sender_profiles description: >- Registry package `mcp.playtables/sender_profiles`, served on MCP mount `playtables.sources`. - name: stoplist_entries description: >- Registry package `mcp.playtables/stoplist_entries`, served on MCP mount `playtables.stoplist`. - name: tags description: >- Registry package `mcp.playtables/tags`, served on MCP mount `playtables.pipeline`. - name: workflow_attachments description: >- Registry package `mcp.playtables/workflow_attachments`, served on MCP mount `playtables.workflows`. - name: workflow_records description: >- Registry package `mcp.playtables/workflow_records`, served on MCP mount `playtables.journeys`. - name: workflow_sources description: >- Registry package `mcp.playtables/workflow_sources`, served on MCP mount `playtables.workflows`. - name: workflow_tasks description: >- Registry package `mcp.playtables/workflow_tasks`, served on MCP mount `playtables.journeys`. - name: workflow_versions description: >- Registry package `mcp.playtables/workflow_versions`, served on MCP mount `playtables.workflows`. - name: workflows description: >- Registry package `mcp.playtables/workflows`, served on MCP mount `playtables.workflows`. paths: /api/playtable-field-values/search: post: tags: - playtable_field_values summary: Search playtable field values description: >- Cell-level execution records - per-cell status, cost cache, error and pin state, with a counts block (status / playtable_field_sid breakdowns). Use for: which cells errored for a field, why enrichment failed across rows, error-by-field health (page_size:0 + counts.groups). Requires a scope filter: playtable_sid.eq OR object_sid OR sid.in (422 otherwise). NOT for bulk value reads (people/companies search, include:["field_values"]) or money aggregates (credit-ledger-entries tools). Contract: - MCP tool `search_playtable_field_values`, registry package `mcp.playtables/playtable_field_values`, mount `playtables.columns`. - Operation `search`, response envelope `search`. - Flags: read only. operationId: search_playtable_field_values requestBody: required: false content: application/json: schema: $ref: '#/components/schemas/SearchPlaytableFieldValuesRequest' responses: '200': description: '`search` success envelope.' content: application/json: schema: $ref: '#/components/schemas/SearchPlaytableFieldValuesResponse' 4XX: $ref: '#/components/responses/McpClientError' 5XX: $ref: '#/components/responses/McpServerError' components: schemas: SearchPlaytableFieldValuesRequest: type: object description: Request body of `search_playtable_field_values`. properties: filter: type: object properties: sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 pattern: ^pt_vl_ description: Cell (playtable field value) sid (pt_vl_…). in: type: array items: type: string minLength: 18 maxLength: 18 pattern: ^pt_vl_ description: Cell (playtable field value) sid (pt_vl_…). additionalProperties: false playtable_sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 pattern: ^pt_tb_ additionalProperties: false description: Scope anchor (pt_tb_…). object_sid: type: object properties: eq: type: string in: type: array items: type: string additionalProperties: false description: >- cr_pp_… / cr_co_… (mixed prefixes, not prefix-pinned); cell-level debugging scope for one row. object_type: type: object properties: eq: type: string enum: - people - company additionalProperties: false description: 'Residual inside scope: people | company.' playtable_field_sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 pattern: ^pt_fd_ in: type: array items: type: string minLength: 18 maxLength: 18 pattern: ^pt_fd_ additionalProperties: false description: Per-field drill-down (pt_fd_…). status: type: object properties: eq: type: string enum: - empty - queued - running - done - error - run_condition_not_met ne: type: string enum: - empty - queued - running - done - error - run_condition_not_met in: type: array items: type: string enum: - empty - queued - running - done - error - run_condition_not_met nin: type: array items: type: string enum: - empty - queued - running - done - error - run_condition_not_met additionalProperties: false description: >- Error/progress drill-down; failed cells = in:["error","run_condition_not_met"]. is_value_from_formula: type: object properties: eq: type: boolean additionalProperties: false description: >- Pinned-vs-formula audit: false on formula fields = manually pinned or tool-written. finished_at: type: object properties: gte: type: string lte: type: string gt: type: string lt: type: string is_null: type: boolean additionalProperties: false description: Last terminal write; is_null:true = never finalized. created_at: type: object properties: gte: type: string lte: type: string gt: type: string lt: type: string additionalProperties: false description: >- Field filters, ANDed: {field: {eq | ne | in | nin | gte | lte | gt | lt | is_null}}; q inside it is free text. Omit for every row. include: type: array items: type: string enum: - field description: Relations to attach to every item; omit for the bare rows. sort: type: object properties: field: type: string enum: - updated_at - finished_at - created_at description: The column to order by. direction: type: string enum: - asc - desc description: asc or desc; default desc. required: - field description: One column and its direction; omit for the default order. page_size: type: integer minimum: 0 maximum: 500 description: 0..500, default 50; 0 = counts only, 1 = the first row. cursor: type: string nullable: true description: pagination.next_cursor of the previous page. SearchPlaytableFieldValuesResponse: type: object properties: success: type: boolean enum: - true operation: type: string enum: - search items: type: array items: type: object properties: item: type: object properties: sid: type: string team_sid: type: string playtable_sid: type: string object_type: type: string enum: - people - company object_sid: type: string playtable_field_sid: type: string value: type: string nullable: true is_value_from_formula: type: boolean original_value: type: string nullable: true description: >- The system-produced value the FIRST manual overwrite snapshotted, what reset restores; null unless is_overwritten. The list surface nulls it like meta: read it on get, update, write and reset. is_overwritten: type: boolean description: >- The current value is a manual write over a system-produced one: the edited marker, and the one state reset accepts. is_not_valid: type: boolean description: >- A manually written value that could not be converted to the column's type (text in a number column), stored raw and flagged; system writers coerce or null instead. status: type: string enum: - empty - queued - running - done - error - run_condition_not_met cost: type: number nullable: true provider_sid: type: string nullable: true meta: type: object nullable: true properties: run_sid: type: string nullable: true steps: type: array items: type: object properties: step_index: type: number tool_sid: type: string status: type: string enum: - success - failed - skipped cost: type: number error: type: string nullable: true finished_at: type: string nullable: true verdict: type: string nullable: true email: type: string nullable: true required: - step_index - tool_sid - status - cost - error - finished_at required: - run_sid - steps error_msg: type: string nullable: true finished_at: type: string nullable: true created_at: type: string updated_at: type: string required: - sid - team_sid - playtable_sid - object_type - object_sid - playtable_field_sid - value - is_value_from_formula - original_value - is_overwritten - is_not_valid - status - cost - provider_sid - meta - error_msg - finished_at - created_at - updated_at included: type: object properties: field: type: object properties: sid: type: string name: type: string slug: type: string category: type: string type: type: string required: - sid - name - slug - category - type description: >- 1:1 owning field (include[]=field): name, slug, category, type; config carries run_condition / nl_condition / preset. required: - item - included pagination: type: object properties: next_cursor: type: string nullable: true has_more: type: boolean total_count: type: integer nullable: true required: - next_cursor - has_more - total_count applied_filters: type: object additionalProperties: {} includes: type: array items: type: string meta: type: object properties: trace_id: type: string description: UUID v7; same 128-bit value as the X-Trace-Id header. span_id: type: string pattern: ^[0-9a-f]{16}$ description: 16 hex chars, root span of this request. timestamp: type: string description: ISO 8601 UTC (Y-m-dTH:i:sZ), response time. duration_ms: type: integer minimum: 0 description: Server-side wall clock. team_sid: type: string nullable: true description: >- The team this call ran in (the token team, or the team_sid override). Null when unauthenticated; absent from pre-2026-08-20 backends. actor_type: type: string nullable: true description: >- user | agent | api_key | system. Null when unauthenticated; absent from pre-2026-08-20 backends. required: - trace_id - span_id - timestamp - duration_ms counts: type: object properties: total_count: type: number groups: type: object properties: status: anyOf: - type: object additionalProperties: type: number - type: array items: {} playtable_field_sid: anyOf: - type: object additionalProperties: type: number - type: array items: {} required: - status - playtable_field_sid required: - total_count - groups required: - success - operation - items - pagination - applied_filters - includes - meta McpError: type: object properties: success: type: boolean enum: - false error: type: object properties: code: type: string enum: - validation_failed - nothing_to_update - not_found - relation_not_found - invalid_transition - limit_exceeded - payment_required - duplicate_rejected - conflict - delete_blocked - unauthorized - forbidden - rate_limited - internal_error - service_unavailable - not_implemented message: type: string recoverable: type: boolean suggestion: type: string field_errors: type: object additionalProperties: type: array items: type: object properties: rule: type: string message: type: string required: - rule - message blockers: type: array items: type: object properties: type: type: string description: >- Machine-readable blocker type (active_flow, pending_tasks, …). severity: type: string enum: - hard - soft description: >- hard = external action required; soft = acknowledge is enough. description: type: string entity_sid: type: string nullable: true count: type: integer resolution: type: string description: 'Hard: tool name to call. Soft: code for acknowledge[].' resolution_hint: type: string required: - type - severity - description - entity_sid - resolution - resolution_hint context: type: object additionalProperties: {} required: - code - message - recoverable meta: type: object properties: trace_id: type: string description: UUID v7; same 128-bit value as the X-Trace-Id header. span_id: type: string pattern: ^[0-9a-f]{16}$ description: 16 hex chars, root span of this request. timestamp: type: string description: ISO 8601 UTC (Y-m-dTH:i:sZ), response time. duration_ms: type: integer minimum: 0 description: Server-side wall clock. team_sid: type: string nullable: true description: >- The team this call ran in (the token team, or the team_sid override). Null when unauthenticated; absent from pre-2026-08-20 backends. actor_type: type: string nullable: true description: >- user | agent | api_key | system. Null when unauthenticated; absent from pre-2026-08-20 backends. required: - trace_id - span_id - timestamp - duration_ms required: - success - error responses: McpClientError: description: >- MCP error envelope. `error.code` is one of validation_failed, nothing_to_update, not_found, relation_not_found, invalid_transition, limit_exceeded, payment_required, duplicate_rejected, conflict, delete_blocked, unauthorized, forbidden, rate_limited, not_implemented. content: application/json: schema: $ref: '#/components/schemas/McpError' McpServerError: description: >- MCP error envelope with `error.code` internal_error or service_unavailable. content: application/json: schema: $ref: '#/components/schemas/McpError' securitySchemes: BearerJwt: type: http scheme: bearer bearerFormat: JWT description: >- 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. TeamSid: type: apiKey in: header name: Team-SID description: >- Team scope for tokens that do not carry one. Ignored when the token already names a team. ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.