Checkpoint & Resume
Saves processing progress to a checkpoint file after each batch or record so that if the flow crashes mid-run, restarting picks up from the last completed item.
Sign in or create a free account to copy this script.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
Long-running flows fail at row 8000 of 10000 and must restart from scratch.
Usage Notes
- 1.Checkpoint file is JSON — allows storing structured state with ConvertJsonToCustomObject.
- 2.NEXT LOOP skips to next iteration — place after counter increment but before processing.
- 3.Checkpoint frequency: save every N records for high-throughput scenarios.
- 4.File.WriteText with Overwrite replaces previous checkpoint each time.
- 5.Cleanup on success: deleting checkpoint signals last run was complete.
- 6.Crash recovery: checkpoint contains lastCompletedIndex, restart skips records up to that index.
Dependencies
- Large Datatable Streamer
- Legacy App Data Entry Loop