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

# List Connections

> List Connections requests a list of connections for a sub-account.



## OpenAPI

````yaml en/API/REST-API-Embedded.yaml GET /poweredby/connection/list
openapi: 3.1.0
info:
  title: CData Connect AI REST API Embedded
  version: v1
servers:
  - url: https://cloud.cdata.com/api
    description: Production base URL
security:
  - BearerAuth: []
paths:
  /poweredby/connection/list:
    get:
      tags:
        - Connection
      summary: List Connections
      description: >
        List Connections returns a list of connections for the sub-account. Use
        this endpoint for sub-account discovery scenarios. For example, you can
        reconcile connection mappings after a redirect failure, or look up the
        per-connection MCP URL for a known external identifier.
      operationId: listConnections
      parameters:
        - name: driver
          in: query
          required: false
          description: >-
            Filter to connections whose data source matches this value
            (case-insensitive).
          schema:
            type: string
            example: ExcelOnline
        - name: externalId
          in: query
          required: false
          description: Filter to connections with this externalId (case-sensitive).
          schema:
            type: string
            example: acme-excel-001
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ConnectionListResult'
              example:
                connections:
                  - id: 880dc1a2-03c3-4288-9857-6f5c029d897c
                    name: ExcelOnline1
                    dataSource: ExcelOnline
                    lastModified: '2024-08-02T21:30:55.154Z'
                    externalId: acme-excel-001
                    mcpUrl: /mcp/connections/880dc1a2-03c3-4288-9857-6f5c029d897c
                    status: Authenticated
                  - id: eeef6211-5d6f-4347-b5bb-f99d574e75e5
                    name: MailChimp1
                    dataSource: MailChimp
                    lastModified: '2023-10-11T20:43:33.28Z'
                    externalId: null
                    mcpUrl: /mcp/connections/eeef6211-5d6f-4347-b5bb-f99d574e75e5
                    status: Conditional
components:
  schemas:
    ConnectionListResult:
      type: object
      properties:
        connections:
          type: array
          items:
            $ref: '#/components/schemas/ConnectionListItem'
          description: A list of connections for the account.
      additionalProperties: false
    ConnectionListItem:
      type: object
      required:
        - id
        - name
        - dataSource
        - lastModified
        - mcpUrl
        - status
      properties:
        id:
          type: string
          format: uuid
          description: The connection Id.
        name:
          type: string
          description: The connection name.
        dataSource:
          type: string
          description: The data source type (for example, ExcelOnline, MailChimp).
        lastModified:
          type: string
          format: date-time
          description: The date and time the connection was last modified.
        externalId:
          type: string
          nullable: true
          description: >
            Optional externalId set when the connection was created via
            redirect. Your identifier for this connection in your own system.
            Unique within a sub-account (null values are excluded from the
            uniqueness constraint). Use this field to correlate Connect AI
            connections with records in your own database. Distinct from the
            `external_identity` JWT claim, which is a per-request user-level
            audit identifier.
        mcpUrl:
          type: string
          description: >-
            The per-connection MCP endpoint URL, for example,
            /mcp/connections/{id}.
        status:
          type: string
          description: >-
            Connection status. Possible values include Authenticated,
            NotAuthenticated, and Conditional.
      additionalProperties: false
  securitySchemes:
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: >-
        JWT token authentication. Include the token in the Authorization header
        as `Bearer {token}`. See
        [Authentication](/en/API/Authentication-Embedded) for more information
        on creating a token.

````