Microsoft Graph Excel API — Worksheets

naftiko: 1.0.0-alpha2
info:
  label: Microsoft Graph Excel API — Worksheets
  description: 'Microsoft Graph Excel API — Worksheets. 5 operations. Lead operation: Microsoft Excel List Worksheets. Self-contained
    Naftiko capability covering one Microsoft Excel business surface.'
  tags:
  - Microsoft Excel
  - Worksheets
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    MICROSOFT_EXCEL_API_KEY: MICROSOFT_EXCEL_API_KEY
capability:
  consumes:
  - type: http
    namespace: graph-worksheets
    baseUri: https://graph.microsoft.com/v1.0
    description: Microsoft Graph Excel API — Worksheets business capability. Self-contained, no shared references.
    resources:
    - name: me-drive-items-item-id-workbook-worksheets
      path: /me/drive/items/{item-id}/workbook/worksheets
      operations:
      - name: listworksheets
        method: GET
        description: Microsoft Excel List Worksheets
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: item-id
          in: path
          type: string
          description: The ID of the workbook file.
          required: true
        - name: workbook-session-id
          in: header
          type: string
          description: Workbook session ID for performance.
      - name: createworksheet
        method: POST
        description: Microsoft Excel Create Worksheet
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: item-id
          in: path
          type: string
          description: The ID of the workbook file.
          required: true
        - name: workbook-session-id
          in: header
          type: string
          description: Workbook session ID.
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: me-drive-items-item-id-workbook-worksheets-worksheet-id-or-name
      path: /me/drive/items/{item-id}/workbook/worksheets/{worksheet-id-or-name}
      operations:
      - name: getworksheet
        method: GET
        description: Microsoft Excel Get Worksheet
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: item-id
          in: path
          type: string
          description: The ID of the workbook file.
          required: true
        - name: worksheet-id-or-name
          in: path
          type: string
          description: Worksheet ID or name.
          required: true
        - name: workbook-session-id
          in: header
          type: string
          description: Workbook session ID.
      - name: updateworksheet
        method: PATCH
        description: Microsoft Excel Update Worksheet
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: item-id
          in: path
          type: string
          description: The ID of the workbook file.
          required: true
        - name: worksheet-id-or-name
          in: path
          type: string
          description: Worksheet ID or name.
          required: true
        - name: workbook-session-id
          in: header
          type: string
          description: Workbook session ID.
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
      - name: deleteworksheet
        method: DELETE
        description: Microsoft Excel Delete Worksheet
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: item-id
          in: path
          type: string
          description: The ID of the workbook file.
          required: true
        - name: worksheet-id-or-name
          in: path
          type: string
          description: Worksheet ID or name.
          required: true
        - name: workbook-session-id
          in: header
          type: string
          description: Workbook session ID.
    authentication:
      type: bearer
      token: '{{env.MICROSOFT_EXCEL_API_KEY}}'
  exposes:
  - type: rest
    namespace: graph-worksheets-rest
    port: 8080
    description: REST adapter for Microsoft Graph Excel API — Worksheets. One Spectral-compliant resource per consumed operation,
      prefixed with /v1.
    resources:
    - path: /v1/me/drive/items/{item-id}/workbook/worksheets
      name: me-drive-items-item-id-workbook-worksheets
      description: REST surface for me-drive-items-item-id-workbook-worksheets.
      operations:
      - method: GET
        name: listworksheets
        description: Microsoft Excel List Worksheets
        call: graph-worksheets.listworksheets
        with:
          item-id: rest.item-id
          workbook-session-id: rest.workbook-session-id
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: createworksheet
        description: Microsoft Excel Create Worksheet
        call: graph-worksheets.createworksheet
        with:
          item-id: rest.item-id
          workbook-session-id: rest.workbook-session-id
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id-or-name}
      name: me-drive-items-item-id-workbook-worksheets-worksheet-id-or-name
      description: REST surface for me-drive-items-item-id-workbook-worksheets-worksheet-id-or-name.
      operations:
      - method: GET
        name: getworksheet
        description: Microsoft Excel Get Worksheet
        call: graph-worksheets.getworksheet
        with:
          item-id: rest.item-id
          worksheet-id-or-name: rest.worksheet-id-or-name
          workbook-session-id: rest.workbook-session-id
        outputParameters:
        - type: object
          mapping: $.
      - method: PATCH
        name: updateworksheet
        description: Microsoft Excel Update Worksheet
        call: graph-worksheets.updateworksheet
        with:
          item-id: rest.item-id
          worksheet-id-or-name: rest.worksheet-id-or-name
          workbook-session-id: rest.workbook-session-id
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deleteworksheet
        description: Microsoft Excel Delete Worksheet
        call: graph-worksheets.deleteworksheet
        with:
          item-id: rest.item-id
          worksheet-id-or-name: rest.worksheet-id-or-name
          workbook-session-id: rest.workbook-session-id
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: graph-worksheets-mcp
    port: 9090
    transport: http
    description: MCP adapter for Microsoft Graph Excel API — Worksheets. One tool per consumed operation, routed inline through
      this capability's consumes block.
    tools:
    - name: microsoft-excel-list-worksheets
      description: Microsoft Excel List Worksheets
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: graph-worksheets.listworksheets
      with:
        item-id: tools.item-id
        workbook-session-id: tools.workbook-session-id
      outputParameters:
      - type: object
        mapping: $.
    - name: microsoft-excel-create-worksheet
      description: Microsoft Excel Create Worksheet
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: graph-worksheets.createworksheet
      with:
        item-id: tools.item-id
        workbook-session-id: tools.workbook-session-id
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: microsoft-excel-get-worksheet
      description: Microsoft Excel Get Worksheet
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: graph-worksheets.getworksheet
      with:
        item-id: tools.item-id
        worksheet-id-or-name: tools.worksheet-id-or-name
        workbook-session-id: tools.workbook-session-id
      outputParameters:
      - type: object
        mapping: $.
    - name: microsoft-excel-update-worksheet
      description: Microsoft Excel Update Worksheet
      hints:
        readOnly: false
        destructive: false
        idempotent: true
      call: graph-worksheets.updateworksheet
      with:
        item-id: tools.item-id
        worksheet-id-or-name: tools.worksheet-id-or-name
        workbook-session-id: tools.workbook-session-id
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: microsoft-excel-delete-worksheet
      description: Microsoft Excel Delete Worksheet
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: graph-worksheets.deleteworksheet
      with:
        item-id: tools.item-id
        worksheet-id-or-name: tools.worksheet-id-or-name
        workbook-session-id: tools.workbook-session-id
      outputParameters:
      - type: object
        mapping: $.