The Problem
Industry Select, a Swiss retail and distribution company, needed to send order data to a third-party delivery partner in EDIFACT format — the international EDI standard used across European logistics and supply chains. Their existing process involved manual data exports, format conversion, and file uploads via email or FTP. This introduced delays, risked missed shipments, and left no reliable audit trail for either party.
What We Built
A GoFlow automation that runs end-to-end: extracting orders from Industry Select's internal database, transforming them into EDIFACT format, and transmitting each order to the delivery partner via MFT Gateway's AS2 protocol — a secure, acknowledged transport layer standard in B2B file exchange.
SQL-Based Order Extraction
The workflow runs two parallel SQL queries against Industry Select's order database via GooAgent, pulling all pending orders. Results are merged and normalised into a single consistent order list ready for transformation.
EDIFACT Transformation
Each order is converted from internal JSON format into a valid EDIFACT document. The workflow maps header segments, line items, quantities, and delivery addresses to the partner's EDI specification.
AS2 Transmission via MFT Gateway
The workflow authenticates with MFT Gateway's API, acquires a session token, and transmits each EDIFACT document over AS2 — an HTTPS-based protocol that provides encryption, digital signatures, and delivery acknowledgements (MDN). Both parties receive a verifiable receipt for every order transmitted.
Order Status Update
Once transmission is confirmed, the workflow updates the order status in the source system, preventing duplicate sends on the next scheduled run.
Stack
- GoFlow — workflow orchestration
- MFT Gateway — AS2 / B2B file transfer service
- GooAgent — SQL query executor
- EDIFACT — UN/EDIFACT document standard
Result
Order data that previously required manual intervention now flows directly from Industry Select's system to their delivery partner. Every transmission is acknowledged, logged, and traceable — replacing an error-prone manual process with a reliable, auditable B2B pipeline.