Skip to content

Data Mapper

Runs only in your browser. Your data is not sent to our servers.

Map fields from a source to a target by drawing lines, with functions in between. Get a mapping table and a prompt for your own AI chat, and code for the platforms that have an open mapping language. You can test JSONata and XSLT here. Code for other platforms, such as DataWeave, must be tested in the platform itself. Save your work as an ipaashub-mapping file, or share it as a link.

A short guided tour of the page.

This tool needs a larger screen. Mapping works on a tablet or a computer. On a phone the canvas is too small to use.

Platform, source and target

Source
Target

Your mapping is saved in this browser as you work. Press Delete to remove the selected function or line, and Ctrl+Z to undo.

Export

Code and test run

Code

Result

Mapping table

SourceTargetRuleNote

    AI prompt

    Prompt

    Start a new mapping?

    Keep the mapping removes only the lines to fields that are gone. Undo the change puts the previous text back.

    About this tool

    Start by choosing the platform you build integrations on. It decides which code you get: JSONata and XSLT for any platform, DataWeave for MuleSoft, XSLT for Azure Logic Apps, Oracle, SAP and TIBCO, JSONata for IBM App Connect and JavaScript for n8n. Boomi, Workato, Celigo and SnapLogic have no open mapping language, so you get the mapping table and an AI prompt written for that platform.

    The source and the target can be examples (JSON, XML, or CSV and other delimited text) or schemas (JSON Schema or XSD). For CSV you can choose the delimiter (comma, semicolon, tab, pipe or asterisk) and whether the first row is a header. Without a header row the columns are called column1, column2 and so on. Fields marked [] repeat, @ marks an XML attribute and * a required field.

    Draw a line from a source field to a target field to copy the value. Put functions in between to join, split, format dates and numbers, look up codes, set defaults and more. For lists, connect the repeating source field to the repeating target field, and map the fields inside as usual. Custom describes a rule in words: it goes into the table and the prompt, and you write the code yourself.

    JSONata runs with the JSONata library and XSLT 3.0 with SaxonJS, both in your browser. DataWeave and JavaScript are generated only. Test them in MuleSoft or n8n.

    The prompt describes the structures, the mapping table, loops and edge cases. Paste it into the AI assistant in your platform or the AI chat you already use. The tool does not call any AI itself.

    Save file gives an ipaashub-mapping file (.json) with everything, including the source and target, that you can open here again. Share link packs the same into the link, after the #. Browsers never send that part to a server, so the mapping is not stored anywhere but in the link.

    Found a problem?

    Tell us what went wrong. You decide whether your own work is included.

    Licences

    This tool is built with these third-party libraries:

    Report a problem

    Show exactly what will be sent

    The report goes to the ipaashub team and is stored with Cloudflare in Western Europe, and included work in the EU. Included work is deleted when the problem is fixed, and at the latest after 90 days. See Privacy.