EDI feature · Mapping & transformation
Map any field to any field.
Point at a segment by path, convert between EDI, XML, JSON, CSV and Excel, and format values on the way.
EDIFACT
UNH+1+ORDERS:D:96B'
BGM+220+4711+9'
DTM+137:20261026:102'
UNH+1+ORDERS:D:96B'
BGM+220+4711+9'
DTM+137:20261026:102'
XML
<BGM>
<e2>4711</e2>
</BGM>
<BGM>
<e2>4711</e2>
</BGM>
JSON
{ "BGM": {
"doc": "4711"
} }
{ "BGM": {
"doc": "4711"
} }
Mapping tools
01
Visual XML Map
Drag source fields onto target fields, with loops and conditions.
02
Paths for EDI
Address a value as BGM.1, DTM.0.1 or NAD.1.0@1.
03
Format on the way
EDIFACT dates, decimals, padding, truncation and character sets.
04
Every format
EDI, XML, JSON, CSV, TSV, Excel and fixed-width files.
05
Lookups
Enrich values from a database or an API during the map.
06
Test with real files
Run the map on a sample and compare input and output.
How it works
Three steps.
01
Load a sample
Drop in a real message to build the source structure.
02
Map
Connect fields, add formats and lookups.
03
Test
Run the sample through and check the output before going live.
Connectors
Connectors used here.
See it running with your own data.
Bring a real file, message or API. We build the flow with you in the demo.