Refresh token but have a ForEach loop downstream

Question

Hello,

My the below pipeline, i get the access token from my web activity followed by the for each loop. That access token is used for every single transaction within the For each loop. The lookup has around 3k rows, so, the foreach runs for 3k times.

Any recommendation on how to refresh the access token with jeopardizing/breaking the foreach loop . The loop can run for 30 mins or 45 or 90 mins.

Answer 1

1. Add a variable to store the token expiration time (e.g., tokenExpirationTime).
2. Modify your web activity to store both the access token and the expiration time.
3. Inside the ForEach loop, add a conditional activity to check if the current time is greater than or equal to the tokenExpirationTime.
4. If the condition is true, refresh the access token using another web activity and update the tokenExpirationTime.
5. Proceed with the remaining actions in the ForEach loop using the updated access token.