JSON source conversion
Convert JSON shipment files into retailer-ready EDI
Analyze one representative JSON export, approve the critical shipment fields, then convert matching files through SFTP, authorized email or an idempotent API.
Direct answer
Direct answer
A safe JSON-to-EDI converter reads an object or array whose shipment lines can be flattened without losing parent identifiers, proposes a mapping to purchase order, shipment, item, quantity, unit, container and date fields, and requires confirmation before automation. Shipment Sentry fingerprints the complete layout: a missing, added or renamed field stops reuse and requests a new confirmation instead of silently shifting data.
Why mapping needs a controlled workflow
EDI rendering is the last step, not the source of truth. The difficult part is preserving line relationships, identifiers, quantities and containers while moving from an internal export to a partner contract. A reusable recipe makes the repeated path fast; exact-layout matching and output validation keep it fail-closed.
What the control should check
- 01Detect the source format from the uploaded bytes, not only its filename.
- 02Show every proposed source-to-canonical field and confidence before activation.
- 03Require purchase order, shipment reference, item, quantity and container confirmation.
- 04Store the approved recipe per workspace and retailer route.
- 05Quarantine unknown layouts without consuming the rest of a 1,000-file batch.
- 06Render and validate each partner output independently.
Working example
{"shipment":"ASN-1042","po":"PO-77821","lines":[{"sku":"SKU-104","qty":12,"uom":"EA","sscc":"000123456789012343"}]}This is representative source evidence, not a universal schema. The first file creates a proposal; only an explicitly confirmed exact layout becomes reusable.
Failure modes worth catching
- A nested array is serialized as text instead of expanded to lines.
- The same key has different types in different records.
- Null and omitted values are treated as equivalent.
- A transport-level success is mistaken for retailer acceptance.
Put it into the dispatch workflow
- 1Create the receiving partner route and enter its account-specific identifiers.
- 2Upload one representative JSON file and inspect the proposed mapping.
- 3Confirm the critical fields; optional fields may remain unmapped.
- 4Send matching files over SFTP, authenticated email or API with the partner code.
- 5Collect each converted output, validation result or quarantine reason from the channel response.
Questions
Implementation answers
Can JSON be converted without a custom integration?
Yes when the source contains the required shipment truth and a confirmed mapping can express it. Missing partner identifiers still need route configuration.
What happens when a column or layout changes?
The heading signature no longer matches, so the file is quarantined with a new mapping proposal instead of using a stale recipe.
Which outputs are available?
Amazon shipment-confirmation JSON, X12 856 and EDIFACT DESADV renderers are implemented. Amazon and Walmart public packs are verified; other partner routes require the current account implementation guide.
Sources and limits
- ASC X12 transaction sets ↗
- Amazon Vendor Shipments API ↗
- Walmart Marketplace EDI interface ↗
- UNECE UN/EDIFACT directories ↗
Reviewed 2026-07-19. Public references cannot establish every partner-specific rule. Current implementation guides and agreements remain controlling.
Keep investigating