---
title: "Suggest column mapping (Step 2)"
method: GET
path: "/api/imports/{id}/column-map"
tags: ["Imports"]
---

# Suggest column mapping (Step 2)

`GET /api/imports/{id}/column-map`

## Path parameters

- `id` string, uuid, required

## Response `200`

AI-inferred column mapping

- object
  - `fromCache` boolean, required
  - `headers` string[], required
  - `mapping` object, required
    - `account` object, nullable, required
      - `column` string, required
    - `amount` union, required
      - object
        - `column` string, required
        - `kind` 'signed', required
        - `parensNegative` boolean, required
        - `signConvention` 'outflow_negative' | 'outflow_positive', required
      - object
        - `inflowColumn` string, required
        - `kind` 'split', required
        - `outflowColumn` string, required
      - object
        - `debitValues` string[], required
        - `kind` 'magnitude_type', required
        - `magnitudeColumn` string, required
        - `typeColumn` string, required
    - `category` object, nullable, required
      - `column` string, required
    - `confidence` number, required
    - `date` union, required
      - object
        - `column` string, required
        - `format` string, required
        - `kind` 'column', required
      - object
        - `kind` 'missing', required
    - `excludeRule` object, nullable, required
      - `column` string, required
      - `trueValues` string[], required
    - `merchant` object, required
      - `column` string, required
    - `notes` object, nullable, required
      - `column` string, required
    - `originalDescription` object, nullable, required
      - `column` string, required
    - `tags` object, nullable, required
      - `column` string, required
      - `delimiter` string, required
    - `transferRule` union, required
      - object
        - `kind` 'category_match', required
        - `values` string[], required
      - object
        - `column` string, required
        - `kind` 'type_match', required
        - `values` string[], required
      - object
        - `kind` 'merchant_prefix', required
        - `prefixes` string[], required
  - `sampleRows` object[], required

## Other responses

- `401` — Unauthorized
- `404` — Import job not found

---

[API](https://skmtc.net/cobaltpf/apis/cobalt-api.md) · [All operations](https://skmtc.net/cobaltpf/apis/cobalt-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cobaltpf/cobalt-api/revisions/8ef0dfb5d23c/schema)