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

# Update table settings



## OpenAPI

````yaml /api-reference/openapi.json patch /v2/sheets/tables/{tableId}
openapi: 3.1.0
info:
  title: Base39 API
  description: Base39 API
  version: 1.0.0
  contact:
    name: Base39 Team
    url: https://base39.com.br
    email: suporte@base39.com.br
  termsOfService: https://base39.com.br/termos
  license:
    name: Proprietary
    url: https://base39.com.br/termos
servers:
  - url: http://localhost:3000
    description: Local
  - url: https://api.dev.base39.cloud
    description: Development
  - url: https://api.base39.com.br
    description: Production
security:
  - OAuth2: []
tags:
  - name: pages
    description: Profiles and reports pages
  - name: pipelines
    description: Pipeline boards (kanban) of pages
  - name: blocks
    description: Blocks operations
  - name: search
    description: Search across content
  - name: targets
    description: Lookup targets via datasets
  - name: CognitoTriggers
    description: Cognito triggers
paths:
  /v2/sheets/tables/{tableId}:
    patch:
      tags:
        - sheets
      summary: Update table settings
      operationId: sheetsUpdateTable
      parameters:
        - name: tableId
          required: true
          in: path
          schema:
            type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/SheetUpdateTableInput'
      responses:
        '200':
          description: ''
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/SheetTableOutput'
components:
  schemas:
    SheetUpdateTableInput:
      type: object
      properties:
        name:
          type: string
        autoRun:
          type: boolean
    SheetTableOutput:
      type: object
      properties:
        id:
          type: string
        workbookId:
          type: string
        name:
          type: string
        autoRun:
          type: boolean
        columns:
          type: array
          items:
            $ref: '#/components/schemas/SheetColumnOutput'
        views:
          type: array
          items:
            $ref: '#/components/schemas/SheetViewOutput'
      required:
        - id
        - workbookId
        - name
        - autoRun
        - columns
        - views
    SheetColumnOutput:
      type: object
      properties:
        id:
          type: string
        name:
          type: string
        kind:
          type: string
          enum:
            - text
            - number
            - boolean
            - enrichment
        editable:
          type: boolean
        width:
          type: number
        position:
          type: number
        configVersion:
          type: number
        enrichment:
          oneOf:
            - $ref: '#/components/schemas/SheetEnrichmentOutput'
            - type: 'null'
      required:
        - id
        - name
        - kind
        - editable
        - width
        - position
        - configVersion
        - enrichment
    SheetViewOutput:
      type: object
      properties:
        id:
          type: string
        name:
          type: string
        config:
          $ref: '#/components/schemas/SheetViewConfigOutput'
      required:
        - id
        - name
        - config
    SheetEnrichmentOutput:
      type: object
      properties:
        dataset:
          type: string
        inputMapping:
          type: object
          additionalProperties:
            type: string
        outputPath:
          type: array
          items:
            type: string
        dependsOn:
          type: array
          items:
            type: string
        autoRun:
          type: boolean
      required:
        - dataset
        - inputMapping
        - outputPath
        - dependsOn
        - autoRun
    SheetViewConfigOutput:
      type: object
      properties:
        columnOrder:
          type: array
          items:
            type: string
        hiddenColumns:
          type: array
          items:
            type: string
        filters:
          type: array
          items:
            $ref: '#/components/schemas/SheetViewFilterOutput'
        sorts:
          type: array
          items:
            $ref: '#/components/schemas/SheetViewSortOutput'
        groupByColumnId:
          oneOf:
            - type: string
            - type: 'null'
      required:
        - columnOrder
        - hiddenColumns
        - filters
        - sorts
        - groupByColumnId
    SheetViewFilterOutput:
      type: object
      properties:
        columnId:
          type: string
        operator:
          type: string
          enum:
            - contains
            - equals
            - is_empty
            - is_not_empty
        value:
          oneOf:
            - type: string
            - type: number
            - type: boolean
            - type: 'null'
      required:
        - columnId
        - operator
    SheetViewSortOutput:
      type: object
      properties:
        columnId:
          type: string
        direction:
          type: string
          enum:
            - asc
            - desc
      required:
        - columnId
        - direction
  securitySchemes:
    OAuth2:
      type: oauth2
      flows:
        authorizationCode:
          authorizationUrl: https://id.local.base39.cloud/oauth2/authorize
          tokenUrl: https://id.local.base39.cloud/oauth2/token
          scopes:
            profile: Read user profile
            email: Read user email
            openid: OpenID authentication
      description: OAuth2 Authorization Code flow

````