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

# What each source column appears to contain, and which field it probably means.

> The inference is counted from the column's own values and the examples that prove it come back with
it, because a confident wrong guess about a date format is the most expensive mistake an import
makes.



## OpenAPI

````yaml /api-reference/openapi.json post /rpc/import_columns
openapi: 3.0.0
info:
  description: ''
  title: >-
    The only schema PostgREST exposes (ADR-014). Reads are security_invoker
    views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every
    deploy — it holds no data.
  version: 12.2.3
servers:
  - url: https://app.assetinfinity.ai/api
security: []
tags:
  - name: Signing in
  - name: Profile
  - name: Assets
  - name: Asset lifecycle
  - name: Work lifecycle
  - name: Maintenance
  - name: Inventory
  - name: Inventory detail
  - name: Procurement
  - name: Contracts
  - name: Workforce
  - name: Capacity
  - name: Dispatch
  - name: Routing
  - name: Tools
  - name: Inspections
  - name: Verification
  - name: Reliability
  - name: Parts demand
  - name: Sensors and meters
  - name: Map
  - name: Floor plans
  - name: Labels
  - name: Lost and found
  - name: Root cause analysis
  - name: Reports
  - name: Audit center
  - name: Activity
  - name: Notifications
  - name: Channels
  - name: Search
  - name: Copilot
  - name: Import
  - name: Files
  - name: Sync
  - name: Support
  - name: Admin
  - name: Access
  - name: Lookups
  - name: Read models
  - name: Branding
  - name: Custom fields
  - name: Form studio
  - name: Workflows
  - name: Workflow studio
  - name: Rules
  - name: Statuses and transitions
  - name: Currencies and locales
  - name: Work configuration
  - name: Asset configuration
  - name: Inventory configuration
  - name: Tool configuration
  - name: Workforce configuration
  - name: Vendor and contract configuration
  - name: Document configuration
  - name: Inspection configuration
  - name: Sites, locations and the organisation
  - name: Platform
  - name: Self verification
  - name: Setup
  - name: Tools on a job, and who has them out
  - name: Vendors and contracts
  - name: Work order execution
  - name: Workforce detail
externalDocs:
  description: PostgREST Documentation
  url: https://postgrest.org/en/v12/references/api.html
paths:
  /rpc/import_columns:
    post:
      tags:
        - Import
      summary: >-
        What each source column appears to contain, and which field it probably
        means.
      description: >-
        The inference is counted from the column's own values and the examples
        that prove it come back with

        it, because a confident wrong guess about a date format is the most
        expensive mistake an import

        makes.
      parameters:
        - $ref: '#/components/parameters/preferParams'
      requestBody:
        content:
          application/json:
            schema:
              description: >-
                What each source column appears to contain, and which field it
                probably means.


                The inference is counted from the column's own values and the
                examples that prove it come back with

                it, because a confident wrong guess about a date format is the
                most expensive mistake an import

                makes.
              properties:
                p_batch_id:
                  format: uuid
                  type: string
              required:
                - p_batch_id
              type: object
          application/vnd.pgrst.object+json:
            schema:
              description: >-
                What each source column appears to contain, and which field it
                probably means.


                The inference is counted from the column's own values and the
                examples that prove it come back with

                it, because a confident wrong guess about a date format is the
                most expensive mistake an import

                makes.
              properties:
                p_batch_id:
                  format: uuid
                  type: string
              required:
                - p_batch_id
              type: object
          application/vnd.pgrst.object+json;nulls=stripped:
            schema:
              description: >-
                What each source column appears to contain, and which field it
                probably means.


                The inference is counted from the column's own values and the
                examples that prove it come back with

                it, because a confident wrong guess about a date format is the
                most expensive mistake an import

                makes.
              properties:
                p_batch_id:
                  format: uuid
                  type: string
              required:
                - p_batch_id
              type: object
          text/csv:
            schema:
              description: >-
                What each source column appears to contain, and which field it
                probably means.


                The inference is counted from the column's own values and the
                examples that prove it come back with

                it, because a confident wrong guess about a date format is the
                most expensive mistake an import

                makes.
              properties:
                p_batch_id:
                  format: uuid
                  type: string
              required:
                - p_batch_id
              type: object
        required: true
      responses:
        '200':
          description: OK
components:
  parameters:
    preferParams:
      description: Preference
      in: header
      name: Prefer
      required: false
      schema:
        enum:
          - params=single-object
        type: string

````

## Related topics

- [Finding your way around](/get-started/navigating.md)
- [Reports](/analytics/reports.md)
- [Custom fields](/config/custom-fields.md)
- [Setting up the plant](/setup/overview.md)
- [Purchase requests](/commercial/purchase-requests.md)