ENDEFRESNLTR
⚡ Automated 🏢 International Freight, Customs & 3PL Logistics 👥 22,000+ Monthly E-Invoices · 6 Unattended RPA Bots ⏱️ 5 Weeks (Cloud Flow Pre-Processor + Unattended PAD RPA)

Custom Teams Notifications

Hybrid Cloud + Desktop RPA pipeline that unpacks incoming .eml/.zip supplier invoice bundles on Zetaleap Cloud, parses Turkish GİB UBL-TR 2.1 and EU PEPPOL BIS 3.0 XMLs + scanned PDF OCR invoices into clean validated JSON, and feeds unattended Power Automate Desktop bots only pre-verified data.

14x
Faster RPA Throughput
18 sec
Per Legacy ERP Voucher
22K/mo
UBL-TR & PEPPOL Docs
0%
Duplicate / Invalid VKN

⚠️ Legacy Challenge & Bottlenecks

The client’s core Windows-based freight ERP lacked modern REST APIs. Previously, Power Automate Desktop bots tried to open ZIP attachments, parse namespace-heavy UBL XMLs, and look up vendor tax IDs via UI automation — taking 4.2 minutes per invoice and crashing whenever embedded XSLT stylesheets exceeded memory limits.

  • ✕4.2 minutes/invoice UI automation bottleneck tying up expensive Unattended RPA licenses
  • ✕Complex `cac:` / `cbc:` XML namespaces & 3 MB embedded Base64 XSLT breaking XPath actions
  • ✕Foreign carrier PDFs arriving scanned without XML requiring manual AP clerk typing
  • ✕Duplicate or mistyped VKN / IBAN payouts slipping into accounting queues

✅ Power Platform + Zetaleap Solution

Shifted 90% of heavy data preparation from Desktop RPA to sub-second Zetaleap Cloud APIs. Cloud Flows parse raw `.eml` emails (`CF-5`), unpack `.zip` bundles (`A3`), convert `UBL-TR` / `PEPPOL` XML into clean JSON + printable HTML (`A2`), run Zetaleap Neural OCR (`UB-9`) on foreign PDF invoices, validate VKN & IBAN checksums (`A5`), and enqueue clean JSON into Dataverse work queues — letting Unattended Desktop RPA bots post each voucher in just 18 seconds.

  • ✓Accelerated Desktop RPA posting speed by 14x (from 4.2 minutes down to 18 seconds per invoice)
  • ✓Saved 3 additional Unattended RPA bot add-on licenses through edge pre-processing efficiency
  • ✓Blocked 100% of malformed IBAN and invalid VKN/VAT supplier records prior to ERP entry
  • ✓Generated instant human-readable HTML/PDF visual previews for every raw XML e-invoice in SharePoint

⚡ 5-Stage End-to-End Execution Pipeline

01
MIME Email & ZIP Unpack POST /api/automation/eml-parse + /zip-archive
Extracts nested .xml and .pdf invoice files from shared AP mailbox messages in memory (<15ms).
02
UBL-TR / PEPPOL XML & OCR Parse POST /api/automation/einvoice-xml + /studio/scan-ocr
Normalizes UBL-TR 2.1 / PEPPOL 3.0 XML into typed JSON + visual HTML; runs TR/EN/DE OCR on scanned PDFs.
03
VKN / VAT / IBAN & Fuzzy Check POST /api/automation/trust-validate + /edge/fuzzy-match
Verifies 10-digit VKN / EU VAT & ISO IBAN MOD-97 checksums and resolves legacy ERP vendor code.
04
Dataverse RPA Work Queue Dataverse Work Queues + Machine Group
Dispatches clean, pre-validated JSON payload across 6 load-balanced Unattended Windows Server bots.
05
18-Second ERP Voucher & Archive Power Automate Desktop + HTML-to-PDF
Bot enters voucher with zero parsing logic and attaches ERP document number back to SharePoint.

🛡️ Enterprise Security, DLP & ALM Governance

  • ◆Dataverse Work Queue concurrency locking with dead-letter retry handling for Desktop Machine Groups
  • ◆ZIP-bomb & path-traversal protection + binary/macro threat scanning (`UB-9`) on external email attachments
  • ◆Idempotent SHA-256 `(VendorTaxId + InvoiceUUID)` duplicate invoice prevention guard
  • ◆ Turkish `#Yalnız...#` legal amount-to-words cross-check (`POST /api/edge/amount-to-words`)

🧩 Technology & Connector Stack

Engineered with governed Microsoft Cloud services and drop-in Zetaleap Swagger 2.0 Custom Connectors:

Power Automate Desktop (Unattended)Power Automate Cloud QueuesZetaleap UBL-TR & PEPPOL (A2)Zetaleap .eml & .ZIP UnpackZetaleap Threat Scan & OCR (UB-9)Zetaleap VKN & IBAN Validator
Swagger 2.0 Connectors Scope Similar Architecture →

🚀 Try the Live Zetaleap API Studios Featured in This Case Study

More Enterprise Case Studies

View All Case Studies (8) →