---
title: "Delete data source"
method: DELETE
path: "/api/data-sources/{sid}"
tags: ["data_sources"]
---

# Delete data source

`DELETE /api/data-sources/{sid}`

## Request

- Base URL: `https://beta.getsales.io/playtables/v1`
- URL: `https://beta.getsales.io/playtables/v1/api/data-sources/{sid}`
- Auth: HTTP bearer and API key in header `Team-SID`

Destructive cascade soft-delete of a source and its own data_source_items staging rows. Promoted objects survive - people, companies, the target playtable and its columns. One soft blocker: an active source with pending items → 409 delete_blocked, code discard_pending_items (confirm dropping not-yet-promoted rows, retry with acknowledge). No hard blockers. No recovery TTL; repeat → already_deleted:true.

Contract:
- MCP tool `delete_data_source`, registry package `mcp.playtables/data_sources`, mount `playtables.sources`.
- Operation `delete`, response envelope `delete_cascade`.
- Flags: dangerous: the MCP layer gates it behind a preview/commit token, and the effect cannot be undone through this API.

## Path parameters

- `sid` string, required: The ds_sc_* sid of the row to delete.

## Query parameters

- `acknowledge[]` string[]: Soft-blocker resolution codes the user confirmed. Closed enum; arbitrary strings → 422.

## Response `200`

`delete_cascade` success envelope.

- DeleteDataSourceResponse
  - `success` true, required
  - `operation` 'delete', required
  - `item` object, required
  - `already_deleted` boolean, required
  - `soft_deleted` boolean, required
  - `cascade` object, nullable, required
    - `summary` string, required
    - `details` object[], required
      - `entity` string, required
      - `deleted` integer, required
      - `cancelled` integer
    - `recovery_available_until` string, nullable, required
  - `meta` object, required
    - `trace_id` string, required: UUID v7; same 128-bit value as the X-Trace-Id header.
    - `span_id` string, required: 16 hex chars, root span of this request.
    - `timestamp` string, required: ISO 8601 UTC (Y-m-dTH:i:sZ), response time.
    - `duration_ms` integer, required: Server-side wall clock.
    - `team_sid` string, nullable: 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` string, nullable: user | agent | api_key | system. Null when unauthenticated; absent from pre-2026-08-20 backends.

## Other responses

- `4XX`: 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.
- `5XX`: MCP error envelope with `error.code` internal_error or service_unavailable.

---

[API](https://skmtc.dev/getsales/apis/getsales-public-contract-gs-service-playtables.md) - [All operations](https://skmtc.dev/getsales/apis/getsales-public-contract-gs-service-playtables/llms.txt) - [OpenAPI document](https://skmtc.dev/getsales/apis/getsales-public-contract-gs-service-playtables/revisions/aa394506515d?raw)