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

# Listar colunas do funil

> Lista as colunas do funil.



## OpenAPI

````yaml https://api.jurichat.com/docs/client/openapi.json get /funnel-column/
openapi: 3.1.0
info:
  title: JuriChat API — Documentação para Integradores
  description: ''
  version: 1.0.0
servers:
  - url: https://api.jurichat.com
    description: Production server
security:
  - apiKeyAuth: []
tags: []
paths:
  /funnel-column/:
    get:
      tags:
        - CRM
      summary: Listar colunas do funil
      description: Lista as colunas do funil.
      parameters:
        - schema:
            type: string
            pattern: ^[cC][^\s-]{8,}$
          in: query
          name: funnelId
          required: true
          description: ID do funil.
        - schema:
            type: string
            format: date-time
          in: query
          name: start
          required: false
          description: Início do período (ISO 8601, meia-noite local). Exige type.
        - schema:
            type: string
            format: date-time
          in: query
          name: end
          required: false
          description: >-
            Fim do período (ISO 8601, meia-noite local do último dia). Opcional;
            sem end filtra a partir de start.
        - schema:
            type: string
            enum:
              - createdAt
              - lastInteraction
          in: query
          name: type
          required: false
          description: >-
            Campo filtrado por start/end: criação do card no CRM ou última
            mensagem.
        - schema:
            type: string
          in: query
          name: createdAt
          required: false
          description: >-
            Legado: filtra cards criados no dia desta data. Prefira start/end +
            type.
        - schema:
            type: string
          in: query
          name: lastContact
          required: false
          description: >-
            Legado: filtra pelo último contato no dia desta data. Prefira
            start/end + type.
        - schema:
            type: string
            pattern: ^[cC][^\s-]{8,}$
          in: query
          name: userId
          required: false
          description: Filtra pelo responsável do card.
        - schema:
            type: string
          in: query
          name: tags
          required: false
          description: IDs de etiquetas separados por vírgula.
        - schema:
            type: string
            pattern: ^[cC][^\s-]{8,}$
          in: query
          name: columnId
          required: false
          description: Filtra por uma coluna do funil.
        - schema:
            type: string
          in: query
          name: channel
          required: false
          description: Filtra pelo canal do lead.
        - schema:
            type: string
          in: query
          name: search
          required: false
          description: Busca por nome, e-mail ou telefone do contato.
        - schema:
            type: boolean
          in: query
          name: showOnlyUnread
          required: false
          description: >-
            Quando verdadeiro, retorna apenas os cards cujo contato tem mensagem
            não lida.
        - schema:
            type: string
            enum:
              - manual
              - name
              - createdAt
              - lastInteraction
          in: query
          name: sortField
          required: false
          description: Campo de ordenação dos cards.
        - schema:
            type: string
            enum:
              - asc
              - desc
          in: query
          name: sortOrder
          required: false
          description: Direção da ordenação.
        - schema:
            type: number
            minimum: 1
            default: 1
          in: query
          name: page
          required: false
          description: Número da página.
        - schema:
            type: number
            minimum: 1
            default: 99999
          in: query
          name: limit
          required: false
          description: Quantidade de cards por coluna.
      responses:
        '200':
          description: Default Response
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: array
                    items:
                      type: object
                      properties:
                        showBadgeProgress:
                          type: boolean
                        timeLimitDays:
                          type: number
                        autoCreateJuridiqLead:
                          type: boolean
                        id:
                          type: string
                        name:
                          type: string
                        color:
                          type: string
                        index:
                          type: number
                        kind:
                          type: string
                          enum:
                            - NORMAL
                            - WON
                            - LOST
                        funnelId:
                          type: string
                          pattern: ^[cC][^\s-]{8,}$
                        columnCards:
                          type: object
                          properties:
                            items:
                              type: array
                              items:
                                type: object
                                properties:
                                  columnChangedAt:
                                    type: string
                                    format: date-time
                                  id:
                                    type: string
                                  channel:
                                    type: string
                                    nullable: true
                                  columnId:
                                    type: string
                                  user:
                                    type: object
                                    properties:
                                      id:
                                        type: string
                                        pattern: ^[cC][^\s-]{8,}$
                                      name:
                                        type: string
                                    required:
                                      - id
                                    additionalProperties: false
                                    nullable: true
                                  conversationId:
                                    type: string
                                    pattern: ^[cC][^\s-]{8,}$
                                    nullable: true
                                  unreadCount:
                                    type: integer
                                    minimum: 0
                                  person:
                                    type: object
                                    properties:
                                      id:
                                        type: string
                                        pattern: ^[cC][^\s-]{8,}$
                                      name:
                                        type: string
                                        nullable: true
                                      email:
                                        type: string
                                        nullable: true
                                      imageUrl:
                                        type: string
                                        nullable: true
                                      phoneNumber:
                                        type: string
                                        nullable: true
                                    required:
                                      - id
                                      - name
                                      - email
                                      - imageUrl
                                      - phoneNumber
                                    additionalProperties: false
                                  customFields:
                                    type: array
                                    items:
                                      type: object
                                      properties:
                                        id:
                                          type: string
                                        value:
                                          anyOf:
                                            - anyOf:
                                                - type: string
                                                - type: number
                                                - type: boolean
                                              nullable: true
                                            - type: array
                                              items:
                                                anyOf:
                                                  - type: string
                                                  - type: number
                                                  - type: boolean
                                                nullable: true
                                            - type: array
                                              items:
                                                type: object
                                                additionalProperties:
                                                  anyOf:
                                                    - type: string
                                                    - type: number
                                                    - type: boolean
                                                  nullable: true
                                            - type: object
                                              additionalProperties:
                                                anyOf:
                                                  - type: string
                                                  - type: number
                                                  - type: boolean
                                                nullable: true
                                      required:
                                        - id
                                        - value
                                      additionalProperties: false
                                  tags:
                                    type: array
                                    items:
                                      type: object
                                      properties:
                                        id:
                                          type: string
                                        name:
                                          type: string
                                        color:
                                          type: string
                                      required:
                                        - id
                                        - name
                                        - color
                                      additionalProperties: false
                                  legalArea:
                                    type: object
                                    properties:
                                      id:
                                        type: string
                                      name:
                                        type: string
                                      color:
                                        type: string
                                    required:
                                      - id
                                      - name
                                      - color
                                    additionalProperties: false
                                    nullable: true
                                  createdAt:
                                    type: string
                                    format: date-time
                                  updatedAt:
                                    type: string
                                    format: date-time
                                required:
                                  - columnChangedAt
                                  - id
                                  - channel
                                  - columnId
                                  - user
                                  - conversationId
                                  - unreadCount
                                  - person
                                  - customFields
                                  - tags
                                  - legalArea
                                  - createdAt
                                  - updatedAt
                                additionalProperties: false
                            total:
                              type: number
                            page:
                              type: number
                            hasMore:
                              type: boolean
                          required:
                            - items
                            - total
                            - page
                            - hasMore
                          additionalProperties: false
                        createdAt:
                          type: string
                          format: date-time
                        updatedAt:
                          type: string
                          format: date-time
                      required:
                        - showBadgeProgress
                        - timeLimitDays
                        - id
                        - name
                        - color
                        - index
                        - kind
                        - funnelId
                        - columnCards
                        - createdAt
                        - updatedAt
                      additionalProperties: false
                required:
                  - data
                additionalProperties: false
        '404':
          description: Default Response
          content:
            application/json:
              schema:
                type: object
                properties:
                  message:
                    type: string
                  statusCode:
                    type: number
                  code:
                    type: string
                  details:
                    anyOf:
                      - type: string
                      - type: number
                      - type: boolean
                      - type: object
                        properties: {}
                        additionalProperties: true
                    description: Detalhes adicionais do erro.
                required:
                  - message
                  - statusCode
                additionalProperties: false
      security:
        - apiKeyAuth: []
components:
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: x-jurichat-api-key
      description: >-
        Chave de API do escritório (criada no painel). Envie o valor no header
        x-jurichat-api-key.

````