I’m building a process which needs to remember the (application-generated) ID’s of transactions which have already been completed. The workflow is:
Get a list of available ID’s from the application,
Subtract the ID’s which have previously been processed by RPA,
Process the next unprocessed ID,
Add the ID from step 3 to the list of processed ID’s
Return to step 1 until no more unprocessed ID’s remain.
What’s the most appropriate design to achieve this? It’s an important criteria that nothing gets picked up twice. Should I just write the ID’s to an Excel file or is there a better option?