I have 7 integrations/flows from another platform (Unanet) into Salesforce. 6 flows work fine; 1 (higher volume and 2-part API call) frequently times out. The problem flow pattern is:
- Authenticate
- Get all Timesheets (endpoint1)
- Loop1 through each Timesheet
- Get all associated Timeslips (endpoint2)
- Loop2 through each Timeslip (loop within a loop – bad idea?)
- For each Timeslip, upsert into Salesforce (non-bulk upsert – bad idea?)
Is there a better pattern? Does Composer support “collections” (like Flows do) and a single bulk API call to upsert all Timeslips after collection (i.e., in a single upsert call vs multiple upsert calls)? If not, is there a way to “re-authenticate” mid-flow? Other patterns?
