Data Migration Tools Agent
Hire Experts

Docs

Schema Mapper

Suggest field mappings between a source and target schema.

← All docs · Open the tool →

Overview

Suggests source-to-target field mappings by name and type similarity. Returns a 0-1 score and match method.

Features

  • Name and type scoring.
  • Configurable threshold.
  • Best-guess for unmatched.

Use cases

  • Mapping fields before a CRM migration.
  • Reconciling schemas after a merger.

API reference

POST /api/v1/tools/schema-map

Suggest field mappings between a source and target schema by name and type similarity.

Returns: An array of matches per source field: the target field, a 0-1 score, and the match method (exact/fuzzy/skip).

Parameters

NameTypeRequiredDefaultDescription
sourceFields object[] Yes — Source schema fields, each { name, type }.
targetFields object[] Yes — Target schema fields, each { name, type }.
threshold number No 0.4 Minimum 0-1 score for a match to be accepted. Lower returns more (weaker) matches.

Example

curl -X POST https://data-migration-tools.com/api/v1/tools/schema-map \
  -H "Content-Type: application/json" \
  -d '{"sourceFields":[{"name":"email","type":"string"},{"name":"phone","type":"string"}],"targetFields":[{"name":"email_address","type":"text"},{"name":"mobile","type":"text"}]}'

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