Skip to main content
POST
/
api
/
lakehouse
/
documents
/
{document_id}
/
mapping
/
confirm
Confirm Column Mapping
curl --request POST \
  --url https://api.merchantops.ai/api/lakehouse/documents/{document_id}/mapping/confirm \
  --header 'Content-Type: application/json' \
  --data '
{
  "column_mapping": {},
  "field_rules": {},
  "group_mappings": [
    {
      "group_id": "<string>",
      "column_mapping": {},
      "composite_keys": [],
      "sheet_configs": []
    }
  ],
  "include_policy_notes": true,
  "policy_metadata": {
    "date_format": "MM/DD/YYYY",
    "effective_date": "<string>",
    "notes": "<string>"
  },
  "sheet_configs": [
    {
      "name": "<string>",
      "header_row": 1,
      "skip": false
    }
  ]
}
'
{
  "document_id": "<string>",
  "message": "<string>",
  "status": "<string>"
}

Headers

authorization
string | null
X-Organization-ID
string | null

Path Parameters

document_id
string
required

Cookies

stytch_session
string | null

Body

application/json

Request to confirm or edit column mapping.

column_mapping
Column Mapping · object

Updated column mapping: {expected_field: excel_column_name, list of columns, dict for additional_attributes, or null}

field_rules
Field Rules · object
group_mappings
GroupMappingConfirm · object[] | null
include_policy_notes
boolean
default:true
policy_metadata
PolicyMetadataConfig · object

Policy-level metadata not present in columns.

sheet_configs
SheetConfigRequest · object[] | null

Per-sheet configuration: which sheets to include and their header rows

Response

Successful Response

Response after confirming column mapping.

document_id
string
required
message
string
required
status
string
required