I am working on an app to lookup tracking numbers from a vendor portal. I get an excel file everyday that I have uploaded into Appian using "Import Excel to database."
What I need to do now is walk through the table line by line and pull the Order Number, pass it to the RPA tool to input into vendor site, retrieve the tracking number, and write it back to the column in the table. Whats the best way to tackle this? a loop function in the process model? a loop function in the RPA?
any help would be greatly appreciated. Thanks.
Discussion posts and replies are publicly visible
Bring all the data using query entity and use the forEach loop to navigate trough all the data
You can write this code in an expression rule which resulting an all the order number.