> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cube.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Disconnect a report from one spot in a spreadsheet

Remove a single placement of a report — one sheet + anchor in one
spreadsheet — leaving every other placement, in this workbook and in others, alone.

Address the placement by `placementId`, or (for placements recorded before ids
existed) by `externalWorkbookId` plus `sheetName` and `anchorCell` — or a
`resultLocation` naming both. Neither the sheet name nor the anchor is optional in
that form: matching is by sheet + anchor, and a target missing either addresses
nothing.

`sheetId` is an optional extra, not a substitute for `sheetName`: a placement
written before that field existed has only a name, and no id the server could
resolve to it, so an id-only address would match nothing while looking correct.

Send a `sheetId` only when you know it is the one the placement was stored with.
It NARROWS the target — a placement recorded under a different id is not matched,
even when the sheet name and anchor agree, because the stored name may belong to a
tab that has since been renamed and the id is the only stable identity. If your id
may have moved on (a tab deleted and recreated under the same name reports a new
one), address the placement by `placementId`, or by sheet name with no
`sheetId` at all.

A target that matches no placement succeeds and changes nothing, so retrying is
safe.

Like connecting, this records nothing about the report's definition and so requires
only read access: unplacing a report from your own sheet is not an edit to the report.


## OpenAPI

````yaml /api-reference/api.yaml delete /api/v1/deployments/{deploymentId}/reports/{reportId}/connect-workbook
openapi: 3.1.0
info:
  title: Cube Platform API
  version: 1.0.0
  description: >-
    Programmatically manage Cube: deployments and everything scoped to them

    (environments, folders, reports, workbooks, notifications, workspace, and
    agents),

    plus account-level users, groups, policies, embedding, and AI settings.
    Data-model

    authoring, dev mode, branches, and uploads live under /build/api/v1 — same
    host and

    token, routed to the build pods.
servers:
  - url: https://{tenant}.cubecloud.dev
    description: Your tenant host. Replace the whole host if you use a custom domain.
    variables:
      tenant:
        default: your-tenant
        description: Your Cube tenant subdomain
security:
  - bearerAuth: []
tags:
  - name: Deployments
  - name: Deployment Creation
  - name: Environments
  - name: Env Variables
  - name: Regions
  - name: Data Model
  - name: Data Model Uploads
  - name: GitHub
  - name: GitHub Connection
  - name: dbt Sync
  - name: Folders
  - name: Reports
  - name: Workbooks
  - name: Notifications
  - name: Workspace
  - name: Users Admin
  - name: User Attributes
  - name: User Attribute Values
  - name: Tenant Settings
  - name: OAuth Integrations
  - name: User OAuth Tokens
  - name: OIDC Token Configs
  - name: App Theme
  - name: Embed
  - name: Embed Tenants
  - name: Dashboard Embed Access
  - name: OpenAPI Spec
paths:
  /api/v1/deployments/{deploymentId}/reports/{reportId}/connect-workbook:
    delete:
      tags:
        - Reports
      summary: Disconnect a report from one spot in a spreadsheet
      operationId: disconnectReportFromWorkbook
      parameters:
        - in: path
          name: deploymentId
          required: true
          schema:
            type: number
        - in: path
          name: reportId
          required: true
          schema:
            type: number
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/DisconnectReportFromWorkbookInput'
        description: DisconnectReportFromWorkbookInput
        required: false
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Report'
          description: ''
components:
  schemas:
    DisconnectReportFromWorkbookInput:
      properties:
        anchorCell:
          oneOf:
            - type: string
            - type: 'null'
        externalWorkbookId:
          oneOf:
            - type: string
            - type: 'null'
        placementId:
          oneOf:
            - type: string
            - type: 'null'
        resultLocation:
          oneOf:
            - type: string
            - type: 'null'
        sheetId:
          oneOf:
            - type: string
            - type: 'null'
        sheetName:
          oneOf:
            - type: string
            - type: 'null'
      type: object
    Report:
      properties:
        canEdit:
          oneOf:
            - type: boolean
            - type: 'null'
        canManage:
          oneOf:
            - type: boolean
            - type: 'null'
        createdAt:
          oneOf:
            - format: date
              type: string
            - format: date-time
              type: string
        createdBy:
          type: integer
        deploymentId:
          type: integer
        description:
          oneOf:
            - type: string
            - type: 'null'
        endResultCell:
          oneOf:
            - type: string
            - type: 'null'
        externalWorkbookId:
          oneOf:
            - type: string
            - type: 'null'
        externalWorkbookPlacements:
          oneOf:
            - items:
                $ref: '#/components/schemas/ReportPlacement'
              type: array
            - type: 'null'
        folderId:
          oneOf:
            - type: integer
            - type: 'null'
        folderPath:
          items:
            $ref: '#/components/schemas/WorkspaceFolderPathEntry'
          type: array
        id:
          type: integer
        jsonQuery:
          oneOf:
            - type: string
            - type: 'null'
        meta:
          oneOf:
            - additionalProperties: true
              type: object
            - type: 'null'
        name:
          type: string
        pivotItems:
          oneOf:
            - $ref: '#/components/schemas/PivotItems'
            - type: 'null'
        publicId:
          pattern: ^[0-9A-Za-z]+$
          type: string
          minLength: 12
          maxLength: 12
        refreshedBy:
          oneOf:
            - type: integer
            - type: 'null'
        refreshedByUser:
          $ref: '#/components/schemas/ResourceOwner'
        resultLocation:
          oneOf:
            - type: string
            - type: 'null'
        rolesWithAccess:
          oneOf:
            - items:
                $ref: '#/components/schemas/RoleWithAccess'
              type: array
            - type: 'null'
        source:
          oneOf:
            - $ref: '#/components/schemas/ReportDtoSource'
            - type: 'null'
        sqlQuery:
          oneOf:
            - type: string
            - type: 'null'
        title:
          oneOf:
            - type: string
            - type: 'null'
        type:
          $ref: '#/components/schemas/ReportDtoType'
        updatedAt:
          oneOf:
            - format: date
              type: string
            - format: date-time
              type: string
        user:
          $ref: '#/components/schemas/ResourceOwner'
        userId:
          type: integer
        version:
          oneOf:
            - type: integer
            - type: 'null'
        workbookId:
          oneOf:
            - type: integer
            - type: 'null'
      required:
        - publicId
        - userId
        - user
        - name
        - refreshedByUser
        - id
        - deploymentId
        - createdAt
        - updatedAt
        - type
      type: object
    ReportPlacement:
      properties:
        anchorCell:
          oneOf:
            - type: string
            - type: 'null'
        endResultCell:
          oneOf:
            - type: string
            - type: 'null'
        host:
          oneOf:
            - $ref: '#/components/schemas/ReportPlacementHost'
            - type: 'null'
        id:
          oneOf:
            - type: string
            - type: 'null'
        placedAt:
          oneOf:
            - type: string
            - type: 'null'
        placedByUserId:
          oneOf:
            - type: integer
            - type: 'null'
        refreshedAt:
          oneOf:
            - type: string
            - type: 'null'
        refreshedByUserId:
          oneOf:
            - type: integer
            - type: 'null'
        resultLocation:
          type: string
        sheetId:
          oneOf:
            - type: string
            - type: 'null'
        sheetName:
          oneOf:
            - type: string
            - type: 'null'
        workbookId:
          type: string
        workbookName:
          oneOf:
            - type: string
            - type: 'null'
      required:
        - workbookId
        - resultLocation
      type: object
    WorkspaceFolderPathEntry:
      properties:
        id:
          type: integer
        name:
          type: string
      required:
        - id
        - name
      type: object
    PivotItems:
      properties:
        columns:
          items:
            type: string
          type: array
        filters:
          items:
            type: string
          type: array
        measures:
          items:
            type: string
          type: array
        measuresAxis:
          oneOf:
            - $ref: '#/components/schemas/PivotItemsMeasuresAxis'
            - type: 'null'
        measuresPosition:
          oneOf:
            - $ref: '#/components/schemas/PivotItemsMeasuresPosition'
            - type: 'null'
        rows:
          items:
            type: string
          type: array
      required:
        - columns
        - measures
        - rows
        - filters
      type: object
    ResourceOwner:
      properties:
        email:
          type: string
        firstName:
          oneOf:
            - type: string
            - type: 'null'
        id:
          type: integer
        picture:
          oneOf:
            - type: string
            - type: 'null'
      required:
        - id
        - email
      type: object
    RoleWithAccess:
      properties:
        actions:
          items:
            enum:
              - All
              - DeploymentsManage
              - DeploymentCreate
              - DeploymentRead
              - DeploymentUpdate
              - DeploymentDelete
              - SecretsManage
              - DownloadData
              - PlaygroundRead
              - SchemaRead
              - SchemaUpdate
              - SchemaUpdateDevBranches
              - APMRead
              - PreAggregationBuild
              - AlertsCreate
              - AlertsRead
              - AlertsUpdate
              - AlertsDelete
              - AuditLogManage
              - BillingRead
              - SqlRunnerRead
              - DataAssetsRead
              - DataAssetsManage
              - CubeNetworkConnect
              - ReportRead
              - ReportEdit
              - ReportManage
              - WorkbookManage
              - WorkbookRead
              - WorkbookEdit
              - ChatThreadRead
              - AgentManage
              - AgentRead
              - AgentSpaceManage
              - AgentAdmin
              - DeploymentAgentRead
              - OAuthIntegrationsManage
              - OAuthIntegrationsIssueTokens
              - McpToolsManage
              - AIBIDevelop
              - AIBIExplore
              - AIBIView
              - ChartPalettesManage
              - DashboardThemesManage
              - AIBIDeveloper
              - AIBIUser
              - AIBIViewer
              - EmbedDeploymentRead
              - EmbedDashboardRead
              - FolderRead
              - FolderEdit
              - FolderManage
            type: string
          type: array
        id:
          type: integer
        name:
          type: string
      required:
        - id
        - name
        - actions
      type: object
    ReportDtoSource:
      enum:
        - GOOGLE_SHEETS
        - EXCEL
        - PLAYGROUND
        - D3
      type: string
    ReportDtoType:
      enum:
        - FOLDER
        - WORKBOOK
        - REPORT
      type: string
    ReportPlacementHost:
      enum:
        - GOOGLE_SHEETS
        - EXCEL
      type: string
    PivotItemsMeasuresAxis:
      enum:
        - columns
        - rows
      type: string
    PivotItemsMeasuresPosition:
      enum:
        - before
        - after
      type: string
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: 'Token authentication. Send `Authorization: Bearer <YOUR_TOKEN>`.'

````