Data Migration Tools Agent
Hire Experts

Docs

Migration Validation Tool

Reconcile source and target CSVs by a key column.

← All docs · Open the tool →

Overview

Reconciles two CSVs by a key: matched count, only-in-source, only-in-target, per-field diffs.

Features

  • Configurable keys.
  • Trim and smart modes.
  • Per-field diffs.

Use cases

  • Verifying a migration loaded every row.
  • Auditing a delta sync.

API reference

POST /api/v1/tools/migration-validate

Reconcile source and target CSVs by a key column: matched count, only-in-source, only-in-target, and per-field diffs.

Returns: Matched/only-in-source/only-in-target counts, and a per-field diff of mismatched values.

Parameters

NameTypeRequiredDefaultDescription
source string Yes — The source CSV text.
target string Yes — The target CSV text.
srcKey string No — Column name to use as the key in the source. Defaults to the first header.
tgtKey string No — Column name to use as the key in the target. Defaults to the first header.
mode string (trim|smart) No — Comparison mode: trim (whitespace-insensitive) or smart (also normalize case/quotes).

Example

curl -X POST https://data-migration-tools.com/api/v1/tools/migration-validate \
  -H "Content-Type: application/json" \
  -d '{"source":"id,name\n1,Ada\n2,Grace","target":"id,name\n1,Ada\n3,Mary"}'

See the full API reference for all examples and error codes.