> ## 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 the saved Pendo queries

> The saved Pendo queries. Each has its `query` (the Pendo aggregation JSON, as text), what it writes (fields, product usage or a custom object), how rows find their account, its mappings and whether it is active.



## OpenAPI

````yaml /api/statisfy-api.openapi.json get /v1/integrations/pendo/queries
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/pendo/queries:
    get:
      tags:
        - integrations
      summary: List the saved Pendo queries
      description: >-
        The saved Pendo queries. Each has its `query` (the Pendo aggregation
        JSON, as text), what it writes (fields, product usage or a custom
        object), how rows find their account, its mappings and whether it is
        active.
      operationId: integrations_pendo_list_queries
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PendoQueriesResponse'
          description: Successful Response
      security:
        - HTTPBearer: []
components:
  schemas:
    PendoQueriesResponse:
      properties:
        data:
          items:
            $ref: '#/components/schemas/PendoQuery'
          title: Data
          type: array
        version:
          description: >-
            The config's version: send it as `expected_version` with a change (0
            = never saved)
          title: Version
          type: integer
      required:
        - data
        - version
      title: PendoQueriesResponse
      type: object
    PendoQuery:
      description: >-
        A saved Pendo query as stored. Its resolver, mapping and transformer
        objects have the same shapes as in

        a SQL warehouse query.
      properties:
        account_resolver:
          anyOf:
            - additionalProperties: true
              type: object
            - type: 'null'
          description: How a row finds its account
          title: Account Resolver
        custom_field_mappings:
          anyOf:
            - items:
                additionalProperties: true
                type: object
              type: array
            - type: 'null'
          description: 'custom_field queries: column to field'
          title: Custom Field Mappings
        custom_object_config:
          anyOf:
            - additionalProperties: true
              type: object
            - type: 'null'
          description: custom_object queries
          title: Custom Object Config
        entity_type:
          description: 'custom_field only: account fields or people fields'
          enum:
            - account
            - people
          title: Entity Type
          type: string
        id:
          anyOf:
            - type: string
            - type: 'null'
          description: >-
            Stable id. null only on a query saved before ids existed: any save
            of the config gives it one
          title: Id
        is_active:
          description: An inactive query is kept but not run
          title: Is Active
          type: boolean
        name:
          title: Name
          type: string
        period:
          anyOf:
            - enum:
                - HOURLY
                - TWO_HOURS
                - FOUR_HOURS
                - SIX_HOURS
                - TWELVE_HOURS
                - DAILY
                - WEEKLY
                - MONTHLY
              type: string
            - type: 'null'
          description: >-
            The window each run covers. null follows the schedule (weekly by
            default)
          title: Period
        person_resolver:
          anyOf:
            - additionalProperties: true
              type: object
            - type: 'null'
          description: 'people queries: how a row finds its person'
          title: Person Resolver
        product_usage_mappings:
          anyOf:
            - items:
                additionalProperties: true
                type: object
              type: array
            - type: 'null'
          description: 'product_usage queries: column to metric'
          title: Product Usage Mappings
        query:
          description: >-
            The Pendo aggregation JSON, as text. A request body with a
            `request.pipeline`. It may use {START_DATE_MS}, {END_DATE_MS} and
            {PENDO_ACCOUNT_ID_FIELD}, which each run fills in
          title: Query
          type: string
        query_type:
          description: >-
            custom_field writes field values; product_usage writes usage
            metrics; custom_object writes records
          enum:
            - custom_field
            - product_usage
            - custom_object
          title: Query Type
          type: string
        transformers:
          anyOf:
            - items:
                additionalProperties: true
                type: object
              type: array
            - type: 'null'
          description: Per-column value pipelines
          title: Transformers
        version:
          description: 'The config''s version: send it as `expected_version` with a change'
          title: Version
          type: integer
      required:
        - id
        - version
        - name
        - query_type
        - query
        - entity_type
        - period
        - account_resolver
        - person_resolver
        - custom_field_mappings
        - product_usage_mappings
        - custom_object_config
        - transformers
        - is_active
      title: PendoQuery
      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.