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

# Import records

> Import records from a CSV or XLSX file. Headers map to field keys (override per column with `mapping`). Synchronous and capped — over the limit the request is rejected with `IMPORT/OVER_SYNC_LIMIT`. Partial success: valid rows commit, failed rows are returned per row.



## OpenAPI

````yaml https://api.useinvent.com/openapi.json post /orgs/{org_id}/tables/{table_id}/records/import
openapi: 3.1.0
info:
  version: 1.0.0
  title: Invent API
servers:
  - url: https://api.useinvent.com
security:
  - bearerAuth: []
paths:
  /orgs/{org_id}/tables/{table_id}/records/import:
    post:
      tags:
        - Orgs Tables
      summary: Import records
      description: >-
        Import records from a CSV or XLSX file. Headers map to field keys
        (override per column with `mapping`). Synchronous and capped — over the
        limit the request is rejected with `IMPORT/OVER_SYNC_LIMIT`. Partial
        success: valid rows commit, failed rows are returned per row.
      parameters:
        - schema:
            type: string
          required: true
          description: Org ID
          name: org_id
          in: path
        - schema:
            type: string
          required: true
          description: Table ID
          name: table_id
          in: path
      requestBody:
        description: ''
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ImportTableRecordsSchema'
          multipart/form-data:
            schema:
              $ref: '#/components/schemas/ImportTableRecordsSchema'
      responses:
        '200':
          description: ''
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ImportTableRecordsResultSchema'
components:
  schemas:
    ImportTableRecordsSchema:
      type: object
      properties:
        file:
          type: string
          format: binary
        mapping:
          type: string
          maxLength: 8192
          description: >-
            Optional JSON object mapping a CSV header to a field key, e.g.
            {"Full Name":"name"}.
      required:
        - file
    ImportTableRecordsResultSchema:
      type: object
      properties:
        created:
          type: number
          description: Rows imported successfully.
        failed:
          type: number
          description: Rows that were rejected.
        errors:
          type: array
          items:
            type: object
            properties:
              row:
                type: number
                description: 1-based row number (the header is row 1).
              message:
                type: string
            required:
              - row
              - message
          description: Per-row failures. Successful rows still commit.
      required:
        - created
        - failed
        - errors
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Key
      description: Bearer token authentication using your API key

````