hi,
I am trying to create a BOT that will read records from Appian DB, hit a website, extract information (get attributes) and update few other columns of the DB.
The table is
The BOT reads restaurantname (in a loop), get attributes (status and date) and update the DB back
this is what I have
Loop is: foreach pv!restaurant.restaurantName
Update value in search is "interact with element" with value as fv!item
Get Date is 'get attribute' with target as restaurant.inspectionDate where restaurant is a variable of type CDT that has
when i run this BOT (through a process model) I see the restaurant names are picked up fine by the loop (one after another),
however the status and date values that gets updated is for the last entry in the table (in this case: Gallery Market & Cafe)
so when I see the process variable in BOT after it has run it is
Discussion posts and replies are publicly visible
I have the same problem as well, I'm trying to update the status field of the current item in the loop after processing it, but it doesn't get saved in the variable. I can't use the target since it doesn't have an option to select an index or create an expression to point to the current index of the loop. I want to save the status first in the cdt variable so I can run the process model to update database just once after the loop, but I can't seem to find a workaround. Have you solved this problem?
I just figured out the solution yesterday..i have posted it now above. Please try to learn it and see if it helps...if not we can discuss more.
thanks
jaideep