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

# List Collections

> Get all collections visible to the current user. Use `datastoreId` to filter by datastore.



## OpenAPI

````yaml /openapi/product/appdb.yaml get /api/datastores/v1/collections
openapi: 3.0.0
info:
  title: App DB API
  version: v1
  description: |
    The App DB API allows developers to interact with AppDB, a NoSQL database 
    for storing arbitrary JSON documents. This API supports CRUD operations, 
    querying, and aggregation, enabling developers to manage data efficiently 
    within their Domo applications.
servers:
  - url: https://{instance}.domo.com
    description: Domo Instance
    variables:
      instance:
        default: api
        description: Your specific Domo instance name (e.g., mycompany)
security:
  - developerToken: []
tags:
  - name: Documents
    description: Manage individual documents in an AppDB collection.
  - name: Collections
    description: Manage AppDB collections (schema, permissions).
  - name: App DB API (Product)
    description: Manage documents and collections in AppDB.
paths:
  /api/datastores/v1/collections:
    get:
      tags:
        - App DB API (Product)
      summary: List Collections
      description: >-
        Get all collections visible to the current user. Use `datastoreId` to
        filter by datastore.
      parameters:
        - name: datastoreId
          in: query
          required: false
          schema:
            type: string
          description: Filter collections by datastore ID.
        - name: shareable
          in: query
          required: false
          schema:
            type: boolean
            default: false
          description: When true, returns only collections the current user can share.
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/Collection'
              example:
                - id: cf97ef6f-4c7c-4739-9af5-5cc0bd782ddb
                  datastoreId: 78a89993-3d3a-4b57-a325-1b3886fe1e1b
                  defaultPermissions: >-
                    READ,CREATE_CONTENT,READ_CONTENT,UPDATE_CONTENT,DELETE_CONTENT
                  requiredAuthorities: null
                  owner: 870010733
                  name: groups
                  datasourceId: null
                  schema: null
                  filters: null
                  syncEnabled: false
                  syncRequired: false
                  fullReplaceRequired: false
                  lastSync: null
                  createdOn: '2026-06-24T20:09:12.502Z'
                  updatedOn: '2026-06-24T20:09:12.502Z'
                  updatedBy: 870010733
                - id: 8050a95f-7865-4ed9-bbeb-a82eaf1d1c41
                  datastoreId: f812ea02-0e52-478b-90f0-00aad7e05029
                  defaultPermissions: null
                  requiredAuthorities: null
                  owner: 870010733
                  name: users
                  datasourceId: de683ed7-eb83-4799-a9c7-876da6b5b008
                  schema:
                    columns:
                      - type: STRING
                        name: username
                      - type: DATETIME
                        name: joined
                  filters: null
                  syncEnabled: true
                  syncRequired: false
                  fullReplaceRequired: false
                  lastSync: '2026-06-24T21:42:28Z'
                  createdOn: '2026-06-24T21:35:39.593Z'
                  updatedOn: '2026-06-24T21:42:28.493Z'
                  updatedBy: 870010733
components:
  schemas:
    Collection:
      type: object
      properties:
        id:
          type: string
          format: uuid
          description: Unique identifier for the collection.
        datastoreId:
          type: string
          format: uuid
          description: ID of the datastore this collection belongs to.
        defaultPermissions:
          nullable: true
          description: >-
            Comma-separated default permission set for new app grants on this
            collection, or null if not set.
        requiredAuthorities:
          nullable: true
          description: >-
            Maps CollectionOperation names to required authority strings, or
            null if not set.
        owner:
          type: integer
          description: User ID of the collection owner.
        name:
          type: string
          description: Name of the collection.
        datasourceId:
          type: string
          nullable: true
          description: ID of the linked Domo DataSet, or null if not yet linked.
        schema:
          type: object
          properties:
            columns:
              type: array
              items:
                $ref: '#/components/schemas/CollectionColumn'
        filters:
          nullable: true
          description: >-
            Array of document-level filter predicates applied to read
            operations, or null if not set.
        syncEnabled:
          type: boolean
          description: Whether documents are periodically synced to the linked DataSet.
        syncRequired:
          type: boolean
          description: Whether a sync is pending.
        fullReplaceRequired:
          type: boolean
        lastSync:
          type: string
          format: date-time
          nullable: true
        createdOn:
          type: string
          format: date-time
        updatedOn:
          type: string
          format: date-time
        updatedBy:
          type: integer
      example:
        id: 232e6d6c-46e9-49b6-a137-8933f0f05999
        datastoreId: 39b88a97-8247-4c0d-ba1d-8ed78d1a6680
        defaultPermissions: null
        requiredAuthorities: null
        owner: 870010733
        name: users
        datasourceId: null
        schema:
          columns:
            - type: STRING
              name: username
            - type: STRING
              name: email
        filters: null
        syncEnabled: true
        syncRequired: false
        fullReplaceRequired: false
        lastSync: null
        createdOn: '2024-01-15T18:42:30.115Z'
        updatedOn: '2024-01-15T18:42:30.115Z'
        updatedBy: 870010733
    CollectionColumn:
      type: object
      properties:
        type:
          type: string
          enum:
            - STRING
            - LONG
            - DECIMAL
            - DOUBLE
            - DATE
            - DATETIME
        name:
          type: string
  securitySchemes:
    developerToken:
      type: apiKey
      in: header
      name: X-DOMO-Developer-Token
      description: Domo Developer Token for authentication.

````