High-Frequency Carrier Directory Scanning
Runs automatically every minute via automation integration system, scanning the designated FTP/SFTP directory for newly delivered IFTSTA shipment status files from carrier networks.
About this template
Automated workflow to process EDI IFTSTA shipment status messages from FTP/SFTP, parse the data, update SAP Business One orders with tracking information, and alert teams of any exceptions.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every module in this template is fully customisable. Add triggers, swap actions, or extend the logic using appse ai's no-code visual builder.
No triggers for FTP SFTP.
Inside the flow
appse ai runs this workflow end to end for FTP SFTP — automatically, every single day. Here is exactly what happens when this template runs.
Runs automatically every minute via automation integration system, scanning the designated FTP/SFTP directory for newly delivered IFTSTA shipment status files from carrier networks.
Downloads the shipment data file and converts it to Base64-encoded format for reliable cross-platform processing.
Decodes the payload through EDI integration automation to extract carrier tracking number (PRO), purchase order reference, SCAC identifier, transit status codes, geographic location, and timestamps.
Uses the purchase order number to locate the exact matching Sales Order in SAP Business One.
Evaluates parsed data to determine if the shipment is progressing normally or has an exception code (weather delay, transit damage) - routing each path accordingly.
Maps delivery flags, status labels, location strings, and timestamps into SAP Business One, synchronizing carrier milestones onto the live sales order.
If a transit issue code is detected, an immediate alert is sent to the designated Teams channel with the purchase order number and full exception details.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.