Data mapping fails converting EDIFACT order files to JSON format

Our order fulfillment integration is failing when converting EDIFACT D96A ORDERS messages to JSON format for Blue Yonder Luminate 2023.1. The mapping tool processes the file but certain segments aren’t being translated correctly, resulting in order rejections.

Specifically, the NAD (Name and Address) segments with multiple qualifier codes and the QTY (Quantity) segments with decimal precision are causing validation errors. We’re using the standard EDIFACT mapping template, but JSON schema validation fails on the converted output.


EDIFACT Input:
NAD+BY+5412345000013::9++Acme Corp+123 Main St+Boston+MA+02101+US'
QTY+21:150.50:PCE'

JSON Output (failing validation):
{"buyer": {"id": "5412345000013", "name": null}}

The mapping tool configuration seems to ignore the compound data elements. Has anyone successfully mapped EDIFACT orders with complex segment structures to JSON in Luminate 2023.1?

The decimal precision issue in QTY segments is a known limitation in some EDIFACT parsers. Blue Yonder Luminate expects quantity values as strings in JSON to preserve decimal precision. Modify your mapping to cast QTY values to string type rather than numeric. Also verify your JSON schema allows string representation for quantity fields or accepts both string and number types.

You’re hitting the classic EDIFACT-to-JSON impedance mismatch. EDIFACT uses positional notation with delimiters, while JSON requires named keys. Your mapping tool needs a comprehensive segment map that defines each component’s target JSON path. For NAD segments, create a mapping table that specifies: NAD+BY = buyer object, position 2 = buyer.id, position 4 = buyer.name, positions 5-8 = buyer.address fields. The mapping template should include conditional logic to handle optional components. We built custom XSLT transforms for complex EDIFACT structures because the standard templates couldn’t handle nested qualifiers properly.

Check if your EDIFACT parser is configured for D96A syntax version. Different EDIFACT versions have slight variations in segment structures. Also, the JSON schema validation might be too strict. Review the schema definition for the buyer object and ensure it includes all required fields from the NAD segment mapping.

I’ve implemented similar EDIFACT to JSON conversions for order fulfillment in Luminate 2023.1. The issue is that the standard mapping template uses simplified transformations that don’t account for all EDIFACT component positions. You need to create a custom mapping configuration that explicitly handles compound data elements. For NAD segments, map each component by its position within the segment, not just the segment qualifier. Additionally, implement pre-validation on the EDIFACT input to ensure all required components are present before attempting JSON conversion. This prevents partial mappings that fail schema validation downstream.