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.
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
- Paste source and target samples.
- Review the suggested matches and fix any that are wrong.
- 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
{
"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": ""
}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.