Original Sheetstead Studio demonstration using eight fictional invoice events.
I built and executed a native n8n workflow that validates invoice amounts, assigns stable request keys, calls a local invoice API and routes responses into completed, rejected, conflict or retry-exhausted outcomes. Transient HTTP responses have a three-attempt cap and a short wait between retries.
The test covers a new invoice, an exact duplicate, a changed amount, temporary 503 failure, HTTP 504 after a committed write, permanent 422 rejection, repeated 429/503 failures and a zero amount blocked before the API call. The destination uses SQLite transactions to preserve the result of an invoice key.
Both full runs passed in n8n 2.47.3. After restarting the destination service, replaying the workflow still left exactly three invoice records totalling GBP 454.00. The verifier independently checked the stored invoice IDs and amounts and all eight workflow outcomes. The amounts are fictional test data, not earnings.
The source download includes the workflow export, local API, repeatable checks, engine report and handover notes. It contains no credentials, real invoices or live external writes. The API is a controlled local fixture. Production authentication, transport-failure recovery, backoff and monitoring require separate design. This is an original studio example, not a previous client deployment.
sheetstead-n8n-api-replay-demo.zip
0 likes · 5 views · Nov 11, 2026
Executed n8n API workflow: eight failure cases, three durable invoices and a restart/replay check. Source and verified results included.