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

# List Import Rows

> Lists the source data stored for imports, newest first, exactly as it
arrived through Import Entity (`createFmv1Import`) or Import Rows
(`ingestFmv1ImportRows`). Use it to check what a migration or spreadsheet
load sent, filtered by `importBatch` or `entityType`; to see how each row
was mapped and whether it failed, use List Import Attempts
(`listFmv1ImportAttempts`).

Returns a page of the company's **import rows**, newest first. An import row
is the data an Import Entity request or an Import Rows request received,
stored as it arrived, before any
transformation.

Filter by `entityType` and by `importBatch`, the batch key the `import`
requests carried. `totalCount` counts every matching row, ignoring the
pagination. Continue while `page * pageSize < totalCount`.

Any query parameter not listed here is a `400`.

Untyped rows are visible to any importer in the company. Synchronous rows retain their entity-type permissions: a key holding
`person.import` alone sees untyped rows and Person rows, and `totalCount` counts only
those.

**Required permission:** `<entityType>.import` for the `entityType` filter
(`person.import` for `Person`); without the filter, any one of
`event.import`, `exposure.import`, `quote.import`, `submission.import`,
`person.import`, `organization.import` or `policy.import`.




## OpenAPI

````yaml /openapi/generated-external-api.yaml get /api/v1/companies/{companyId}/imports/rows
openapi: 3.0.3
info:
  title: AI Insurance External API
  description: External API for AI Insurance platform
  version: 1.0.0
  contact:
    email: support@aiinsurance.io
servers:
  - url: https://go.aiinsurance.io
    description: Production
security:
  - ApiKeyAuth: []
paths:
  /api/v1/companies/{companyId}/imports/rows:
    get:
      tags:
        - Imports
      summary: List Import Rows
      description: >
        Lists the source data stored for imports, newest first, exactly as it

        arrived through Import Entity (`createFmv1Import`) or Import Rows

        (`ingestFmv1ImportRows`). Use it to check what a migration or
        spreadsheet

        load sent, filtered by `importBatch` or `entityType`; to see how each
        row

        was mapped and whether it failed, use List Import Attempts

        (`listFmv1ImportAttempts`).


        Returns a page of the company's **import rows**, newest first. An import
        row

        is the data an Import Entity request or an Import Rows request received,

        stored as it arrived, before any

        transformation.


        Filter by `entityType` and by `importBatch`, the batch key the `import`

        requests carried. `totalCount` counts every matching row, ignoring the

        pagination. Continue while `page * pageSize < totalCount`.


        Any query parameter not listed here is a `400`.


        Untyped rows are visible to any importer in the company. Synchronous
        rows retain their entity-type permissions: a key holding

        `person.import` alone sees untyped rows and Person rows, and
        `totalCount` counts only

        those.


        **Required permission:** `<entityType>.import` for the `entityType`
        filter

        (`person.import` for `Person`); without the filter, any one of

        `event.import`, `exposure.import`, `quote.import`, `submission.import`,

        `person.import`, `organization.import` or `policy.import`.
      operationId: listFmv1ImportRows
      parameters:
        - $ref: '#/components/parameters/companyId'
        - name: entityType
          in: query
          required: false
          schema:
            type: string
            enum:
              - Event
              - Exposure
              - Quote
              - Submission
              - Person
              - Organization
              - Policy
          description: >
            Return only import rows of this entity type. Any other value is a
            `400`,

            not an empty page; a type you may not import is a `403`.
        - name: importBatch
          in: query
          required: false
          schema:
            type: string
            minLength: 1
          description: >-
            Return only import rows whose `import` request carried this batch
            key.
        - name: page
          in: query
          required: false
          schema:
            type: integer
            minimum: 1
            maximum: 9007199254740991
            default: 1
          description: 1-based page number. Defaults to the first page.
        - name: pageSize
          in: query
          required: false
          schema:
            type: integer
            minimum: 1
            default: 50
            maximum: 100
          description: >
            Number of import rows per page (default 50, maximum 100). A larger
            value

            is clamped to 100, not rejected; the response's `pageSize` is the
            size

            served.
      responses:
        '200':
          description: One page of import rows, plus the unpaginated total
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ImportRowsPageResponse'
              examples:
                rows:
                  summary: One batch's import rows
                  value:
                    items:
                      - id: 3f8a2c1e-9b4d-4e7a-8c21-5d6f7a8b9c0d
                        entityType: Submission
                        data:
                          submission:
                            name: Acme Logistics
                            effectiveDate: '2026-01-01'
                          broker:
                            email: broker@example.com
                        importBatch: legacy-2026-10
                        createdAt: '2026-10-22T14:03:11.204Z'
                    totalCount: 1
                    page: 1
                    pageSize: 50
                empty:
                  summary: No import rows match
                  value:
                    items: []
                    totalCount: 0
                    page: 1
                    pageSize: 50
        '400':
          description: >
            Bad Request — `entityType` is not one of the listed entity types,

            `importBatch` is empty, `page` / `pageSize` is not a positive
            integer or

            is out of range, or the query carries an unknown parameter.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                invalidEntityType:
                  summary: Unknown entityType
                  value:
                    error:
                      code: INVALID_ENTITY_TYPE
                      message: >-
                        Invalid entityType: must be one of Event, Exposure,
                        Quote, Submission, Person, Organization, Policy
                invalidPageSize:
                  summary: Non-positive-integer pagination value
                  value:
                    error:
                      code: BadRequest
                      message: 'Invalid pageSize: must be a positive integer'
                unknownQueryParameter:
                  summary: Unknown query parameter
                  value:
                    error:
                      code: InvalidRequest
                      message: >-
                        Unknown key(s) in import rows query: batch. Allowed
                        keys: companyId, entityType, importBatch, page, pageSize
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '500':
          $ref: '#/components/responses/InternalServerError'
      security:
        - BearerAuth: []
        - ApiKeyAuth: []
components:
  parameters:
    companyId:
      name: companyId
      in: path
      required: true
      schema:
        type: string
        format: uuid
      description: Company identifier
  schemas:
    ImportRowsPageResponse:
      type: object
      description: One page of a company's import rows, newest first.
      required:
        - items
        - totalCount
        - page
        - pageSize
      properties:
        items:
          type: array
          description: The import rows on this page, newest first.
          items:
            $ref: '#/components/schemas/ImportRow'
        totalCount:
          type: integer
          description: How many import rows match the filters, ignoring the pagination.
        page:
          type: integer
          minimum: 1
          description: The effective one-based page number.
        pageSize:
          type: integer
          minimum: 1
          maximum: 100
          description: The effective page size, default 50 and clamped to 100.
    ErrorResponse:
      type: object
      description: Standard error response for all external API endpoints
      required:
        - error
      properties:
        error:
          type: object
          required:
            - code
            - message
          properties:
            code:
              type: string
              description: Machine-readable error code
              example: VALIDATION_ERROR
            message:
              type: string
              description: Human-readable error message
              example: 'submissionId: Required field is missing'
            userMessages:
              type: array
              description: >-
                Clean, verbatim-displayable messages — one entry per failure,
                free of error-code tags, field paths, and internal noise.
                Suitable for showing to end users as-is.
              items:
                type: string
              example:
                - Exposures of type 'company' require an address
            details:
              type: array
              description: Additional details for validation errors (field-level errors)
              items:
                type: object
                properties:
                  field:
                    type: string
                    description: The field that caused the error
                    example: submissionId
                  code:
                    type: string
                    description: Stable problem code for this individual validation failure
                    example: BLANK_LIST_ELEMENT
                  reason:
                    type: string
                    description: Stable reason the value violates its canonical contract
                    example: blank-list-element
                  expected:
                    type: string
                    description: The expected canonical value contract
                    example: nonblank trimmed string
                  message:
                    type: string
                    description: Description of the field error
                    example: Required field is missing
    ImportRow:
      type: object
      description: >
        One import row: the data an `import` request received, stored as it
        arrived,

        before any transformation. Import rows are append-only and never change.
      required:
        - id
        - entityType
        - data
        - importBatch
        - createdAt
      properties:
        id:
          type: string
          format: uuid
          description: The import row id.
        entityType:
          type: string
          nullable: true
          enum:
            - Event
            - Exposure
            - Quote
            - Submission
            - Person
            - Organization
            - Policy
          description: >-
            Null for storage-only rows. Synchronous imports retain their
            original entity type.
        data:
          description: >-
            The original JSON value as received, including objects, arrays,
            scalars and null.
        importBatch:
          type: string
          nullable: true
          description: The caller's batch key from the `import` request, or `null`.
        createdAt:
          type: string
          format: date-time
          description: When the import row was stored.
  responses:
    Unauthorized:
      description: Unauthorized - Invalid or missing API key
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
          examples:
            missingApiKey:
              summary: Missing API key
              value:
                error:
                  code: AuthenticationError
                  message: API key authentication required
                  userMessages:
                    - API key authentication required
            invalidApiKey:
              summary: >-
                Invalid API key (e.g. unknown key, or a Bearer token used
                instead of an API key)
              value:
                error:
                  code: AuthenticationError
                  message: Invalid API key
                  userMessages:
                    - Invalid API key
    Forbidden:
      description: Forbidden - Insufficient permissions
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
          examples:
            insufficientPermissions:
              summary: Insufficient permissions
              value:
                error:
                  code: AuthorizationError
                  message: User is not authorized to perform the requested action
                  userMessages:
                    - User is not authorized to perform the requested action
            companyMismatch:
              summary: A valid API key naming another company in the URL
              value:
                error:
                  code: AuthorizationError
                  message: API key is not scoped to the requested company
                  userMessages:
                    - API key is not scoped to the requested company
    InternalServerError:
      description: Internal Server Error - Unexpected error occurred
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
          examples:
            internalError:
              summary: Unexpected server error
              value:
                error:
                  code: UncaughtActionError
                  message: Uncaught error occurred in <actionName>
                  userMessages:
                    - An unexpected error occurred. Please try again later.
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: Authorization
      description: >-
        API key authentication. Send your raw API key as the `Authorization`
        header value with NO scheme prefix — `Authorization: YOUR-API-KEY`. Do
        NOT prefix it with `Bearer ` or `ApiKey `, and do not use an `X-API-Key`
        header; those are not accepted.
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: >-
        User-principal OAuth 2.0 Bearer authentication. Send a user-scoped Auth0
        access token (audience = the app API audience) as `Authorization: Bearer
        <jwt>`. The request resolves to the user's identity and is authorized by
        their Role on the `{companyId}` in the path — the same role-based
        permissions the web app enforces. This is the path the MCP connector
        uses to act on a user's behalf; endpoints that accept it list both
        `BearerAuth` and `ApiKeyAuth`.

````

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