Login

JSON Mapper

Transforms JSON data between different formats using user-defined field mappings. Load sample source and target JSON files to define the structure mapping, then apply the mapping to transform input data.

Quick Start:
  1. Load or paste both Source JSON (the data you want to transform) and Target JSON (the desired output format). The Load from URL is for Registered Users
  2. Click Parse JSON(s) to analyze the structure of JSON files and create the panel for manual mapping
  3. Use Manual mapping tools to link fields from source to target and click Build Map to generate the transformation map
  4. Load a JSON file to right panel to transform and click Apply Map to get the output. Use Save to download the transformed JSON (Registered Users)
💡 Tips:
1. Enter the same values in the source and target JSON elements to automatically create mappings. For example, if you want to map a field called firstName in your source JSON to first_name in your target JSON, you can set both values to John. This way, when you click Parse JSON(s), the tool will recognize that these fields are matched on their identical values.
2. Use Simplify to reduce array items to unique elements only. For example, if you have a catalog of products it will leave just one of them, merging any properties of products.
Source
Target
Ready. Paste JSON into both panels, then click Parse JSON.

Paths are linked automatically in priority order:

  1. Identical paths — source and target paths match exactly
  2. Identical values — fields contain the same example value
  3. Matching keys — property names correspond

Choose one of the following methods for Manual mapping:

  • Source-first: Click a source path, then pick an unlinked target from the list that appears.
  • Target-first: Click a target path, then click the desired source path to establish the link.

To Remove links:

  • Remove source: Click the delete button (left) to remove the source path from the mapping. The target becomes available again. Use Parse JSON to restore removed source paths.
  • Unlink target: Click the chain button (center) to unlink the target from the source. The source path stays in the mapping.
Manual mapping
Link JSON paths from your source (left side) to target (right side) fields. Click Build Map when done to generate the transformation map.
Transformation Map
This is the transformation map that defines how fields should be transformed. You can edit the map directly or save/load them for reuse (Subscribers only). Once created, use this map to apply transformations to your data files.