Sales Order Line Items - Delete Use Case: Tracking Adjusted Sales Order Line Items for External System SyncWe have a situation where customers need to view their sales orders on our website. Unfortunately, direct access to the API isn't feasible due to high traffic, so we need to sync the data. The challenge is that sales orders (SOs) are frequently adjusted — items are added or removed up until shipping. When items are "removed" from the SO, I need to reconcile these deletions in an external system.Goal: Capture deleted line items on Sales Orders to track and reconcile them with our external system. Initially, I considered using push notifications, but they can sometimes be unreliable (e.g., missed messages). Instead, I'm looking for a way to export all Sales Order Line items to an external table (Azure SQL Server) on a nightly or weekly basis. I’d then run a reconciliation job to manage the deletes.Current Approach & ChallengesI attempted an exp
