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

# List integrations

> Every app the workspace can connect, the SQL warehouses among them, each with whether it is connected, its last run and what it supports; a warehouse and pendo also have their config version and how many queries they have. Credentials are connected in Statisfy's app, and none is returned.



## OpenAPI

````yaml /api/statisfy-api.openapi.json get /v1/integrations
openapi: 3.1.0
info:
  description: >-
    The agent-first Statisfy API. Authenticate with an API key (`Authorization:
    Bearer stfy_live_…`), then call `GET /v1/meta/capabilities` to discover
    every operation and its schemas.
  title: Statisfy API
  version: 1.0.0
servers:
  - url: https://api.statisfy.com
    description: Production
security: []
paths:
  /v1/integrations:
    get:
      tags:
        - integrations
      summary: List integrations
      description: >-
        Every app the workspace can connect, the SQL warehouses among them, each
        with whether it is connected, its last run and what it supports; a
        warehouse and pendo also have their config version and how many queries
        they have. Credentials are connected in Statisfy's app, and none is
        returned.
      operationId: integrations_list
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/IntegrationsResponse'
          description: Successful Response
      security:
        - HTTPBearer: []
components:
  schemas:
    IntegrationsResponse:
      properties:
        data:
          items:
            $ref: '#/components/schemas/Integration'
          title: Data
          type: array
      required:
        - data
      title: IntegrationsResponse
      type: object
    Integration:
      properties:
        auth_method:
          anyOf:
            - enum:
                - oauth
                - api_key
                - password
                - token
                - service_account
              type: string
            - type: 'null'
          description: How it connects; null when Statisfy does not list the app
          title: Auth Method
        connected:
          description: >-
            Connected and live: credentials stored in Statisfy's app, or an app
            connected through Paragon
          title: Connected
          type: boolean
        connected_by:
          description: >-
            workspace: connected once for everyone; each_user: every person
            connects their own
          enum:
            - workspace
            - each_user
          title: Connected By
          type: string
        connection_status:
          anyOf:
            - type: string
            - type: 'null'
          description: >-
            LIVE, ERROR or DISCONNECTED, as the credential store has it; null
            when never connected, and for an app connected through Paragon,
            which holds its status
          title: Connection Status
        key:
          title: Key
          type: string
        kind:
          description: >-
            sql_warehouse: a warehouse the API sets up (config, queries, SQL);
            app: any other, Pendo included
          enum:
            - sql_warehouse
            - app
          title: Kind
          type: string
        last_run:
          anyOf:
            - $ref: '#/components/schemas/IntegrationRun'
            - type: 'null'
          description: Its latest run; null when none, and for an app not connected
        name:
          title: Name
          type: string
        query_count:
          anyOf:
            - type: integer
            - type: 'null'
          description: A SQL warehouse's or Pendo's saved queries; null for any other app
          title: Query Count
        supports:
          description: >-
            The parts of /v1/integrations/{key} this integration has. For pendo,
            the config and the queries are at /v1/integrations/pendo/config and
            /v1/integrations/pendo/queries
          items:
            type: string
          title: Supports
          type: array
        version:
          anyOf:
            - type: integer
            - type: 'null'
          description: >-
            A SQL warehouse's or Pendo's config version, 0 when never saved;
            null for any other app
          title: Version
      required:
        - key
        - name
        - kind
        - auth_method
        - connected_by
        - connected
        - connection_status
        - version
        - query_count
        - last_run
        - supports
      title: Integration
      type: object
    IntegrationRun:
      properties:
        counts:
          anyOf:
            - items:
                $ref: '#/components/schemas/IntegrationRunCounts'
              type: array
            - type: 'null'
          description: >-
            Per query that finished, what it read and wrote. Null while the run
            is going, for runs from before counts were kept, and when every
            query failed (the run's error says why)
          title: Counts
        duration_seconds:
          anyOf:
            - type: number
            - type: 'null'
          title: Duration Seconds
        ended_at:
          anyOf:
            - format: date-time
              type: string
            - type: 'null'
          title: Ended At
        id:
          title: Id
          type: integer
        query_id:
          anyOf:
            - type: string
            - type: 'null'
          description: The saved query a single-query run ran; null for a whole-subtype run
          title: Query Id
        run_type:
          description: manual, bootstrap, periodic or unknown
          title: Run Type
          type: string
        started_at:
          format: date-time
          title: Started At
          type: string
        status:
          anyOf:
            - enum:
                - in_progress
                - completed
                - failed
              type: string
            - type: string
          description: in_progress, completed or failed
          title: Status
        subtype:
          description: >-
            The job subtype it ran: account_custom_fields, product_usage,
            custom_objects…
          title: Subtype
          type: string
      required:
        - id
        - subtype
        - status
        - started_at
        - ended_at
        - duration_seconds
        - run_type
        - query_id
        - counts
      title: IntegrationRun
      type: object
    IntegrationRunCounts:
      description: >-
        What one query did in a run, row by row. Each row read is counted in
        exactly one of

        written, unmatched, invalid, skipped and failed.
      properties:
        failed:
          description: >-
            Rows that raised an error: in a transformer, the account or person
            lookup, or the write
          title: Failed
          type: integer
        invalid:
          description: Rows the query's validators dropped
          title: Invalid
          type: integer
        query_id:
          anyOf:
            - type: string
            - type: 'null'
          description: The saved query's id; null for a query saved before queries had ids
          title: Query Id
        query_name:
          title: Query Name
          type: string
        read:
          description: Rows the query returned
          title: Read
          type: integer
        skipped:
          description: >-
            Rows that matched but had nothing to write: every mapped value empty
            or not convertible to its field's type, or (product usage) metrics
            with no product
          title: Skipped
          type: integer
        unmatched:
          description: Rows that matched no account (or, for a people query, no person)
          title: Unmatched
          type: integer
        written:
          description: >-
            Rows that wrote at least one value to Statisfy (for a custom object,
            rows whose record was saved). A value for a field locked against
            imports counts, though the field keeps its value
          title: Written
          type: integer
      required:
        - query_id
        - query_name
        - read
        - written
        - unmatched
        - invalid
        - skipped
        - failed
      title: IntegrationRunCounts
      type: object
  securitySchemes:
    HTTPBearer:
      scheme: bearer
      type: http
      description: >-
        An API key, sent as `Authorization: Bearer stfy_live_…`. See
        [Authentication](/rest-api/authentication) for how to get one and which
        scopes it needs.

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.