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

# Poll an extraction and read its rows

> Returns `processing` until the extraction settles, then `completed` with the extracted tables, or `failed` with a reason.

Results expire 24 hours after creation, after which this returns `410`.



## OpenAPI

````yaml /api-reference/openapi.json get /extractions/{extraction_id}
openapi: 3.1.0
info:
  title: Vern Migration API
  version: 1.0.0
  description: >-
    Run Vern as a headless migration engine. Create a migration, upload a
    customer's files, run the managed agent to generate a preview, then execute
    and export clean data. See the Migration API guides for concepts and
    walkthroughs.
servers:
  - url: https://app.vern.so/api/v1
security:
  - apiKey: []
tags:
  - name: Catalog
    description: Discover the sources and templates you set up in the Vern UI.
  - name: Migrations
    description: Create a migration workspace and upload a customer's files.
  - name: Runs
    description: 'Drive the managed agent: generate, refine, execute, answer, and observe.'
  - name: Export
    description: Download a migration's validated data as CSV.
  - name: Log
    description: The settled record of what a migration did.
  - name: Knowledge
    description: Durable context the agent reads before every run.
  - name: Exports
    description: Download imported data.
  - name: Extractions
    description: >-
      Turn an unstructured file into structured data, without running a
      migration.
paths:
  /extractions/{extraction_id}:
    parameters:
      - $ref: '#/components/parameters/ExtractionId'
    get:
      tags:
        - Extractions
      summary: Poll an extraction and read its rows
      description: >-
        Returns `processing` until the extraction settles, then `completed` with
        the extracted tables, or `failed` with a reason.


        Results expire 24 hours after creation, after which this returns `410`.
      operationId: getExtraction
      responses:
        '200':
          description: The extraction's current state.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Extraction'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          description: >-
            No such extraction. Also returned for an extraction belonging to
            another organisation.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '410':
          description: The extraction has expired and its results were deleted.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Extraction'
        '429':
          $ref: '#/components/responses/RateLimited'
        '500':
          $ref: '#/components/responses/ServerError'
        '503':
          description: Extraction is not available for your data region.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
components:
  parameters:
    ExtractionId:
      name: extraction_id
      in: path
      required: true
      schema:
        type: string
        format: uuid
      description: The id returned by `POST /extractions`.
  schemas:
    Extraction:
      type: object
      required:
        - extraction_id
        - status
      properties:
        extraction_id:
          type: string
          format: uuid
        status:
          type: string
          enum:
            - processing
            - completed
            - failed
            - expired
        file_name:
          type: string
        templates:
          type: array
          items:
            type: string
        created_at:
          type: string
          format: date-time
        completed_at:
          type: string
          format: date-time
          nullable: true
        expires_at:
          type: string
          format: date-time
        table_count:
          type: integer
          description: Present when status is `completed`.
        row_count:
          type: integer
          description: Total rows across all tables. Present when `completed`.
        tables:
          type: array
          description: Present when status is `completed`.
          items:
            $ref: '#/components/schemas/ExtractedTable'
        error:
          type: string
          description: Present when status is `failed` or `expired`.
    Error:
      type: object
      properties:
        error:
          type: string
          description: A human-readable error message.
      required:
        - error
    ExtractedTable:
      type: object
      required:
        - headers
        - rows
        - row_count
      properties:
        name:
          type: string
          nullable: true
          description: >-
            The section this table came from, when the extraction identified
            one. Null for an unnamed table.
        headers:
          type: array
          items:
            type: string
          description: Column names, in extraction order.
        rows:
          type: array
          description: One object per row, keyed by header.
          items:
            type: object
            additionalProperties:
              type: string
        row_count:
          type: integer
        ordinal:
          type: integer
          description: 1-based position of this table within the document.
        pages:
          type: array
          items:
            type: integer
          description: Source pages this table was drawn from, when known.
  responses:
    Unauthorized:
      description: API key missing, malformed, or revoked.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    RateLimited:
      description: Rate limit hit — back off and retry.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: Too many requests
    ServerError:
      description: Unexpected server error.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
  securitySchemes:
    apiKey:
      type: apiKey
      in: header
      name: x-api-key
      description: Your Vern API key. Create one at Settings → API keys.

````