> ## 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 data source items > Row-level drill-down behind an import funnel: one row per raw record a data source staged - the untouched payload plus its promotion outcome (status, status_reason, created_object_sid, duplicate_action). Scope data_source_sid + status for "why didn't these rows make it"; q searches the payload (requires data_source_sid); sid.eq resolves people.data_source_item_sid provenance; include data_source = the source; counts.groups.status = the funnel. Totals/metrics → data-sources tools. Contract: - MCP tool `search_data_source_items`, registry package `mcp.playtables/data_source_items`, mount `playtables.sources`. - Operation `search`, response envelope `search`. - Flags: read only. ## OpenAPI ````yaml /api-reference/playtables/openapi.yaml post /api/data-source-items/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/data-source-items/search: post: tags: - data_source_items summary: Search data source items description: >- Row-level drill-down behind an import funnel: one row per raw record a data source staged - the untouched payload plus its promotion outcome (status, status_reason, created_object_sid, duplicate_action). Scope data_source_sid + status for "why didn't these rows make it"; q searches the payload (requires data_source_sid); sid.eq resolves people.data_source_item_sid provenance; include data_source = the source; counts.groups.status = the funnel. Totals/metrics → data-sources tools. Contract: - MCP tool `search_data_source_items`, registry package `mcp.playtables/data_source_items`, mount `playtables.sources`. - Operation `search`, response envelope `search`. - Flags: read only. operationId: search_data_source_items requestBody: required: false content: application/json: schema: $ref: '#/components/schemas/SearchDataSourceItemsRequest' responses: '200': description: '`search` success envelope.' content: application/json: schema: $ref: '#/components/schemas/SearchDataSourceItemsResponse' 4XX: $ref: '#/components/responses/McpClientError' 5XX: $ref: '#/components/responses/McpServerError' components: schemas: SearchDataSourceItemsRequest: type: object description: Request body of `search_data_source_items`. properties: filter: type: object properties: sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 pattern: ^ds_it_ description: Item sid (ds_it_…). in: type: array items: type: string minLength: 18 maxLength: 18 pattern: ^ds_it_ description: Item sid (ds_it_…). additionalProperties: false description: >- Prefix-validated ds_it_ sid(s) - the point-lookup path (no get tool); resolves people.data_source_item_sid provenance backlinks. data_source_sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 pattern: ^ds_sc_ in: type: array items: type: string minLength: 18 maxLength: 18 pattern: ^ds_sc_ additionalProperties: false description: >- The primary review scope - funnel drill-downs always pass the source. status: type: object properties: eq: type: string enum: - pending - promoted - duplicate - stoplisted - disqualified - failed ne: type: string enum: - pending - promoted - duplicate - stoplisted - disqualified - failed in: type: array items: type: string enum: - pending - promoted - duplicate - stoplisted - disqualified - failed nin: type: array items: type: string enum: - pending - promoted - duplicate - stoplisted - disqualified - failed additionalProperties: false description: >- Promotion outcome(s) - in:["failed","duplicate","stoplisted","disqualified"] = "rows that did not make it". created_object_sid: type: object properties: eq: type: string minLength: 18 maxLength: 18 in: type: array items: type: string minLength: 18 maxLength: 18 is_null: type: boolean additionalProperties: false description: >- Provenance backlink (cr_pp_ or cr_co_ per the source object type); is_null:true = rows that produced nothing. q: type: string maxLength: 128 description: >- MySQL LIKE (infix) over the raw payload JSON - find one record by any fragment (name, email). Requires data_source_sid (eq or in) in the same filter, else 422 - payload search is per-source. created_at: type: object properties: gte: type: string lte: type: string gt: type: string lt: type: string additionalProperties: false description: Ingestion window; ISO 8601 range - combine bounds in one object. updated_at: type: object properties: gte: type: string lte: type: string gt: type: string lt: type: string additionalProperties: false description: Terminal-transition window ("failures in the last hour"). deleted_at: type: object properties: gte: type: string lte: type: string is_null: type: boolean additionalProperties: false description: 'Default scope is { is_null: true } (live rows).' 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: - data_source description: Relations to attach to every item; omit for the bare rows. sort: type: object properties: field: type: string enum: - created_at - updated_at - row_number 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. SearchDataSourceItemsResponse: 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 description: Item sid (ds_it_…). team_sid: type: string description: Owning team (ts_tm_…, external - gs.service.id). data_source_sid: type: string description: >- ds_sc_… owning source - see ./data_sources.md; set at birth, never re-validated. row_number: type: integer nullable: true minimum: 1 description: >- 1-based CSV data-row position (type=csv sources); null for the search kinds and for webhook. payload: anyOf: - type: object additionalProperties: {} - type: array items: type: string nullable: true description: >- Raw external record as ingested, never mutated (legacy raw_data). An object for every kind: the collector parser record for a search source, the CSV row keyed by its own header for csv, the selected slice of the body for webhook. Only csv rows staged before 2026-08-04 are positional string arrays. status: type: string enum: - pending - promoted - duplicate - stoplisted - disqualified - failed description: >- Promotion outcome - service-managed, never client-writable. status_reason: type: string nullable: true description: >- Human-readable outcome detail (max 2048): failure message or matched stoplist entry; null for pending and clean promoted rows (legacy error_reason). created_object_sid: type: string nullable: true description: >- Created/updated object on promoted, matched object on duplicate - the prefix follows the source object type (cr_pp_ people, cr_co_ companies). Write-once at resolve; may dangle after the object is deleted. already_in_playtable_sid: type: string nullable: true description: >- Duplicate people rows only - pt_tb_… the person's membership at match time; snapshot, never re-validated. duplicate_action: type: string nullable: true enum: - skipped - moved - membership_added - merged - disqualified description: >- Duplicate rows only - what the duplicate policy did; null otherwise (incl. company already a member). created_at: type: string description: >- ISO 8601 UTC - ingestion time (the "collected" period column). updated_at: type: string description: >- ISO 8601 UTC - terminal transition time (the funnel period column read by data-sources metrics). deleted_at: type: string nullable: true description: >- ISO 8601 UTC - set only by the source cascade delete; null = live. Terminal rows hard-purge 90 days after updated_at. required: - sid - team_sid - data_source_sid - row_number - payload - status - status_reason - created_object_sid - already_in_playtable_sid - duplicate_action - created_at - updated_at - deleted_at included: type: object properties: data_source: type: object properties: sid: type: string required: - sid description: >- DataSourceDomain row (ds_sc_…) - the owning source - see ./data_sources.md; present when requested. 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: integer minimum: 0 description: Rows matching the filter (full filter scope, not the page). groups: type: object properties: status: anyOf: - type: object additionalProperties: type: integer minimum: 0 - type: array items: {} description: >- Flat {value: count} per DataSourceItemStatusEnum value present in scope - the import funnel. duplicate_action: anyOf: - type: object additionalProperties: type: integer minimum: 0 - type: array items: {} description: >- The duplicate rows by what the policy did (DataSourceItemDuplicateAction → count), 2026-10-28: the rows keep status duplicate, so read the people moved into the table (moved) as imported and the rest as duplicates still standing. Empty when there are none. already_in_playtable_sid: anyOf: - type: object additionalProperties: type: integer minimum: 0 - type: array items: {} description: >- The duplicate people the policy left where they were (status duplicate, duplicate_action skipped), by the table they are in (pt_tb_… → count): what move_data_source_duplicates would move (2026-10-28). Empty when there are none. required: - status description: The distribution axes (§4.17); PHP empty map serialises as []. 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.