Skip to content
IntegrateKit

JSON Field Mapping Assistant (Source to Target)

Paste a source and a target JSON sample, get a field mapping table with suggested matches, then draft JSONata, DataWeave or Java. Runs locally.

FreeRuns in your browser

Mapping Assistant tool

Runs entirely in your browser. Nothing you paste is uploaded or stored.

Found a problem or have an idea for this tool? Send feedback.

About this tool

Paste a sample of the source JSON and a sample of the target JSON. The tool lists every field, suggests which source field feeds each target field, flags type changes, and shows what is left unmapped. You can change any suggestion.

With Pro, the confirmed mapping becomes a draft in JSONata, DataWeave or Java, ready to refine. It is a starting point, not a finished transformation.

How to use it

  1. Paste source and target samples.
  2. Review the suggested matches and fix any that are wrong.
  3. Optionally generate a code draft and review it.

Limitations

  • Matches use field names only, not meaning.
  • Array element mappings aren't generated into code.

Example

Source and target (see example)
{
  "cust_id": 7,
  "first_name": "Ann",
  "contact": {
    "email_address": "[email protected]"
  },
  "order_total": 149.9
}
---
{
  "customerId": "7",
  "firstName": "Ann",
  "email": "[email protected]",
  "total": 149.9,
  "notes": ""
}
Suggested mapping
customerId  <- cust_id (type changes from number to string)
firstName   <- first_name
email       <- contact.email_address
total       <- order_total
notes       <- (not mapped)

Common use cases

New integrations

Get a first mapping table in seconds instead of by eye.

Migrations

Check that no target field is left unmapped.

Reviews

Share the mapping table with a business analyst.

Frequently asked questions